Select 500000 records and write to excel sheet till all records are processed

[Srini84 (Srinivas Kadamati)]

@RPA-botDev

Check below thread for your reference

Remove lines from datatable until its empty

Have a look here:

Hope this will help you

thanks