Read fixed columns with dynamic rows

Help
, , ,
1

Hello everyone,
123
Good days~~

I want to read two rows from an excel like below,
but I don’t know the columns it will be every time
so I want to read a range with certain columns and dynamic rows.
Do you have any ideas?

Thanks for your help in advance.

2

Hi @ChangShuang

If the column names are the same, you can import the data using the column names.When using the Read Range activity, you can check the Add header property and import the body as a DataTable to handle the data as row (“HeaderName”). Tostring in the For each row activity.

3

Entering “” in the range value of Read Range will retrieve the entire data.

Do you want this?

4

No, there are other data in the other columns in the excel, I only want the first two columns

5

@ChangShuang

If you just want the 1st 2nd column of ExcelUse row (0) .tostring, row (1) .tostring within the “for each row” activity