Get data from specific column in excel using automation anywhere

Question

We need to fetch data from a column in an excel sheet. The problem is that order of column can change as e.g

The same file can be configured as :

So how do we fetch data from the Marks column?

Have tried Start Loop control (Each row in Excel dataset Session) But I don't see any control to loop through all the columns for row in the current iteration (nested loop).

Answer 1

Hi, you can use the column name directly (and without quotes) provided you have selected that the Excel dataset contains headers.please refer the screenshot below: