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

1 Like

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