Consider u have 10000 records u started working on excel sheet suddenly it got closed due to some issue network or server and if u have completed some loops its comes to upto middle around 100 and u have to start from 101 how how will u identify its sta

Help Activities
3

Hi @TUSHAR_LENDAY,
If you do not have to keep a track of rows that you have processed, you can delete each row from the Excel sheet once you have finished processing. In case the process stops midway and you have to start the process again, then the BOT will start picking up the next rows directly.

In case you do have to keep track of the rows that you have processed, then you can simply append each row in a separate sheet after the row is processed and before the row is deleted from your original sheet.

Let me know if this helps

Thanks,
Nishant