How can I read column by column and row by row?

Hi,

How can I read the row by row for each column?

Regards,

image

Hi @Canberk

You may use a for each row inside a for each loop.

You may refer to my example below.
Book1.xlsx (8.5 KB) ReadRowColumn.xaml (5.9 KB)

1 Like

Thanks @Gluon but how can I start second column.

Regards,

Hey. You can start the second column once the first column is done.
The robot will loop through all the columns and for each column, it loops through each row.
For each col in dt.Columns
for each row in dt
{action}

May you post your .xaml file is you are still encountering difficulties.
Cheers

For example,
image

I wrote this expression and I get image

My question is how can I eliminate first part;
image

You may refer to the attached file.

ReadRowColumn.xaml (5.9 KB)

Cheers

Thank you for your help. @Gluon

Cheers.