Welcome back to the community after a long 4 months.
Wish you a very happy new year!!
So for your scenario, we have to use multiple set of loops to handle it.
First use a while loop with the condition set to true. This loop will run until we break it. Why we need this loop is we have to continuously run it for each rows/25 number until a rows are processed
Now within this loop have a read range to read the data in the excel.i suggest you to have a status column in the excel so that bot can update the status of all processed data each time it execute a record. Once the data is read onto a datatable, use a filter datatable and filter out the processed records so you will have only the records to be processed.
Now use another for each row activity inside the loop to navigate through the records.
Here we have to use a counter variable keep track of the number of records processed. When for each row activity.loops for 25 times, we have to break it and get back to the outer loop and start the next iteration.
Inside the for each row loop, once the record is processed update the excel row with the status complete and the break and move to outer loop for next iteration
Hope this helps