Hi, I did a process on excel. How do i loop the process multiple time and stop it when Im done??
U can use For each Row for looping excel row wise
For this u need to read that data in sheet using read range and then u can loop that datatable
If you want to loop inside the Excel data and do some activities for each row then use For Each
But if you wan to run the entire process for multiple times then try as below
Counter will use to run how many times
Using that you can define IF condition
Mark as solution if this helps
You can loop through each row of your Excel spreadsheet with a For Each Row as @ImPratham45 mentioned. Use a Read Range to get the value of your spreadsheet, and use this variable in the For Each Row. It will loop through all of the data rows and exit once it has completed.