Add data in excel

[Vasanth_Kumar]

Hi,

I want to write column(“College”) in my data table to my column(E) in excel.

Please help me in this

[Natapong (Natapong Raojutitam)]

Hi @Vasanth_Kumar

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