Excel Loop Iteration

Automation Studio
1

Hi,

I am trying to automate Excel using excel Loop. I have to iterate through excel till “n” no of rows. I am using 'while" loop for the same, but it’s not working. There’s no “for” loop in AssistEdge. Please provide some alternative approach.

Thanks

2

@isha.bhatnagar, excel loop loops through all the rows by itself. There is no need of using a while or for loop

3

Hi,

In case in excel loop you have n + x rows and you want to iterate only for n rows then declare an integer argument counter and increase its value by 1 every time. Once it reaches n use Break Excel activity to exit from the loop

Regards,
Amit Anand