How to iterate for this table structure?



I have database with this structure:


I want to iterate for this table after find in rows “INDEX”. So I want get value “A” , “B”, “C”.
After that I want value right “A”, “B”, “C”. How I can do this?


using For each Row activity and fetch the value by row(“Column Name”)


And I got “System.Data.DataRow”


@Katarzyna_Jan Inside the for each row use get row item than you can get column values


row(“Column Name”).ToString where .ToString converts into a string.


I don’t get it. I don’t know how to do this.


Hi @Katarzyna_Jan

How to make it work.

  1. Read range in the range of your choosing. Include headers.
  2. Iterate through rows of the resulting DataTable and process them