Trying to extract data from excel and use each value from cell

Hello everyone! I am trying to extract data from excel file then use each value from each cell for input for a type into activity. Anyone have an idea of the best way to do this or any way to do this?

Also would like to add that the type activity stop after typing each row then the process starts again with the next cell

@juan_otero

easiest way to get the data from the excel file would be to use a Read Range activity to read the data in the excel sheet onto a datatable.

Next, use a For Each Row activity to loop through the datatable row by row.

Inside the loop, you can specify the type into activities to type the data in each column of that particular row in the location you need.

Syntax will be like

row(“ColumnName”).ToString

1 Like

Thanks will try

1 Like