Hi,
I want to write column(“College”) in my data table to my column(E) in excel.
Please help me in this
Hi,
I want to write column(“College”) in my data table to my column(E) in excel.
Please help me in this
Welcome to UiPath forum.
I would like to guide you about how to do it.
Steps:
1.Create a int32 variable for loop input value and set the default to the first row that you want to write data
2.Read data to datatable
3.Put Excel file that you want to write data to [Excel Application Scope]
4.Loop your datatable by [For Each Row]
5.Using [Write cell] to put data to column E
in range field input [“E”+int32Variable.ToString]
6.[Assign] int32Variable = int32Variable+1 for in increase Variable value
Sample project:
AddDataToExcel.zip (28.7 KB)
I hope this information will be useful for you