Hi, i am facin this isue, i am using extracting data table

Help Studio
1

Screenshot 2024-03-22 120441
Screenshot 2024-03-22 1204411017×214 29.1 KB

i usng extract data table. i scrapping name and links, in extract data table data can be write in singel cell, ([“Michael Seibel”, “Andrey Klen”, “Alex Neskin”, “Yaroslav Azhnyuk”, “Anastasia Kukhar”]) i can write this formate in excel singel cell, what activity use this process

1 Like
2

Hi @Venky_Mama ,

To write data from an Extract Data Table activity into a single cell in an Excel file, you can use the Write Cell activity in UiPath. However, before writing the data, you need to transform the extracted data into a format that can be written into a single cell.

  1. Transform the Data : Since you want to write the names and links into a single cell, you need to concatenate them into a single string. You can use the Join function in UiPath to concatenate the names and links into a single string with a delimiter.
  2. Write the Data to Excel : Once you have the concatenated string, you can use the Write Cell activity to write it into a specific cell in an Excel file.

→ Assign activity:
ConcatenatedString = String.Join(", ", yourDataTable.AsEnumerable().Select(Function(row) row(“Name”).ToString() + ": " + row(“Link”).ToString()).ToArray())

→ Write Cell activity:
Range: “A1” (or any other cell where you want to write the concatenated string)
Value: ConcatenatedString

Hope this helps you,
Thank you

4

Okay, then you can use write range work book activity

5

@Venky_Mama,

Your Extract Data Table activity will give you output as a DataTable.

Use Write Range Activity to write it to an excel file.
Provide Excel File name you want with .xlsx extention.
Provide Sheet Name as per your choice.
Enter "A1" in Range property
Enter your DataTable variable from Extract Data Table

Follow these steps.

Thanks,
Ashok :slight_smile:

6

Hi @Venky_Mama ,

Once you extracted data . Then you will have 1 datatable as a output of extract data table activity.

Now just drag write range workbook activity. Pass file path, sheet name & datatable (which already you have). Write Range as “A1”.

If you required, you can click on add header option.

Thanks

7

yes, but data can wriete to one by one colioum sir . ineed to singel sir plese understand me sir i hope u

8

@Venky_Mama,

Please show how data should be written in excel.

Thanks,
Ashok :slight_smile:

9

Screenshot 2024-03-22 132329
i dont need this format. i need to this formate . (new coloumn) 3 names write singel cell ex: ("amit manjihi,will devanny,petr novak). i need this formate sir. as limks will be write to same porocess

10

May I know only the New column 0 value need’s to concatinate and seperate by comma

11

Hey, please provide screenshot of output table!

12

Screenshot 2024-03-22 132329

13

I need Expected Output Format

14

May I know only the New column 0 value need’s to concatinate and seperate by comma

15

this one out put data. i need this format ( “Amit manjhi”,“will devenny”,“peeetr novak”).in singel coloum

16

sorry singel cell i need

17

→ Build a Data table
→ Apply Read range workbook activity provide column range of New column 0
->Assign a string variable hold the value String.Join(“,”, DataTable1.AsEnumerable().Select(Function(row) “”“” & row(“New Column 0”).ToString() & “”“”))
->Apply Add data row activity provide the array row as the string variable
->Write the excel by write range workbook activity and provide the start cell

I am getting the expected output. Attaching the file over here. Hope this will helps you now.
Test (2).zip (9.6 KB)

Thanks