I am looking for a way to loop though the columns of an excel sheet, rather than rows. How can I do that?
Hi,
Assume you read an excel sheet through the Read from Excel File and save the results into data
variable, then in your Loop Through Set specify the Set as =data.header
and Current Item Name as column
. The column
variable will then contain the names of the individual columns.