Build data table to excel

Learn Academy Feedback
1

Hello. i have one excel file and i want to put header with build data table activity and write another excel file, but when i write it it only have headers but no value on row, what is the problem ?

2

Can you show the workflow picture

Thanks
@Hamidy1667

3

@Hamidy1667 Do you want to Add Headers to your Excel File?

4

yes here it is Edit Range.xaml (51.9 KB)

edit
edit923×656 23.8 KB

5

yes i have on excel that i will edit it , and after edit i want to add headers and write to another excel file or csv file, csv is better

6

@Hamidy1667 If you want to add Headers/Columns you don’t need to use Build Datatable Activity, I guess you can Read the Excel File, Get the Datatable as Output, Edit the Datatable as you wanted to, Add the Headers/Columns using Add Data Column Activity and Write the Datatable to another Csv File that you want using Write Csv Activity.

If you have any Questions, Please ask them.

1 Like
7

you mean first i should out put data table from excel file and after that should i put add data column?

8

but earlier i used build data table from web scraping data and it worked very well but with excel it doesnt

9

@Hamidy1667 Yes, Build Data Table is just used to Build a Schema for the Datatable, and if you want to Add Default Values you can add them, but to Add values Dynamically to it, you’ll need to use Add Data row Activity.

Using Read Range Activity will Directly give you the Datatable with the Excel Data in it. Hence you don’t need to use Build Datatable.

1 Like
10

can please check my work flow upper, im little lost now, i f you have to time to tell more simple way

11

i want to name 6 cloumn so ,replace another excel values unther this new column names, these values changing dynmacilly so i want stable column name

12

@Hamidy1667 Do you want to Rename the Columns in the Excel File and put in a CSV File?

13

initially there is no name for columns its just a row, but i want to put for every column a name, like a b c d e f , 6 cloumn name, and with this names save it to csv

14

@Hamidy1667 Can you provide your Excel File as well ? If Possible Show us the Expected Excel output File.

15

res.xlsx (7.8 KB)
this is excel file, that first one column will delet, then i want to name header for columns and write new csv file

16

this is expected output
res out.xlsx (9.3 KB)

17

@Hamidy1667 Can you Check this Workflow :
Edit Range.zip (12.0 KB)

The Number of names provided in the NewColumnNames variable should be the same as the Number of Columns in the Original Excel.

Also Will the Excel Have Empty Columns present ?

18

yes the number wıll be same as 6 and there ıs one empty column that ı wıll delet ıt fırst

19

ı thınk somthing wrong with the workflow that you created

range
range1208×690 39.2 KB

20

@Hamidy1667 Can you Update packages in the xaml, manly the UiPath.Core.Activities and UiPath.Excel.Activities to the Latest Version