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 ,
it could look like this:
item is of datatype Object and represents the looped item from the row’s itemArray
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:
Hope this helps
The pro approach is using a queue and the REF, everything else is just a workaround.