How can I read the same row from different sheet

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

@mohammed.alsaadi

Welcome to forums

Check as below for your reference

  1. Use Read Range activites for two excel sheets which will output two datatables., let’s say Dt1 and Dt2

  2. 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

  3. Now use Assign activity as firstdtRow = dt1.Rows(Index).Item(“ColumnName”).ToString

  4. 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

@mohammed.alsaadi

For More reference on Index or Foreach you can check below for your reference

Reference

Hope this will help you

Thanks

1 Like