How can I read the same from a different sheet? I mean reading the 1st row from the 1st sheet, then 1st row from the second sheet and so on, then I move to the 2nd row from all the sheets
Welcome to forums
Check as below for your reference
-
Use Read Range activites for two excel sheets which will output two datatables., let’s say Dt1 and Dt2
-
Now use For Each row activity and declare a variable for Index in the properties and input any of the Datatable let’s say Dt1
-
Now use Assign activity as firstdtRow = dt1.Rows(Index).Item(“ColumnName”).ToString
-
Likewise SeconddtRow = dt2.Rows(Index).Item(“ColumnName”).ToString
Now the loop continues always it will give the results
Hope this will help you
Thanks
1 Like
For More reference on Index or Foreach you can check below for your reference
Hope this will help you
Thanks
1 Like