Loop multiple times in one row before moving to next row using for each activity

I have an excel file that requires to fill up the form in a webpage. the excel file is arranged by the name of the company which required to submit multiple forms in a row. Therefore, I have almost 100 columns in a row. How do I loop the first row before moving on to using for each row for the next company?

Hi @felicia welcome to forum

To loop through each row of excel u can use for each row activity ,

Regards,

Nived N

Happy Automation

@felicia

it could look like this:

item is of datatype Object and represents the looped item from the row’s itemArray

2 Likes

Hi @felicia,

I suppose you would like to loop though all the columns from the first row, before moving to the second one, and so on
If so, you could use the following structure:

sol

Hope this helps
Best regards,
Marius

The pro approach is using a queue and the REF, everything else is just a workaround.