0 votes
1 view
in RPA by (12.8k points)

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

enter image description here

The same file can be configured as :

enter image description here

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).

1 Answer

0 votes
by (29.8k points)
edited by

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:

enter image description here

Welcome to Intellipaat Community. Get your technical queries answered by top developers !