How to start processing records after a specific set threshold in excel

Help Activities
, ,
1

Hi all,

I am working on a scenario where there are very large number of records in excel file. The chrome got crashed after certain records. so I have put a threshold at 300.
Now I want to execute records from 301 from that data table. but I am unable to do it.

Any help in this regard will be highly appreciated.

Thank you
Regards
enthusiastic

2

Hi @enthusiastic ,

if you are allowed to add new column in the input excel add column in run time and add status of the case in that column like if the row is processed enter the status like completed or if any issue leave it blank.

if chrome crashed or stuck after some rows. you should have logic in the starting of the process like only extract the rows which are not completed(blank) only and save into data table so no need to use any threshold this way you can achieve and avoid already processed records.

sharing my thought. try and see if it suits your requirement. thanks.