How to iterate for this table structure?

Help
1

I have database with this structure:

aaaa

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?

2

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

3

And I got “System.Data.DataRow”

4

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

1 Like
5

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

6

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

7

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

image
image852×627 25 KB