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

[RPA-botDev (RPA)]

Hi Devs, please I have up to 3 million records and I need to write them into excel sheet but the problem is job execution stops cause of the large records.We decided to select 500000 as chunk and write to excel sheet, if sheet1 is full write to next sheet till all 3 million records have been written.Please assist on the code or logic to resolve this.Regards

[kirankumar.mahanthi1 (Kirankumar Mahanthi)]

Hi,

I assume you have 3 million rows in a datatable in that case we can use linq to split the datatable into multiple chunks. Please refer the below thread and suggestions. It might helpful for your requirement. Thanks.

Split Datatable into 4 different tables

Hey guys, So i generate a datatable with 100+ rows every week. Now i’d like to split that table into 4 parts with about equal numbers of rows in each. Found some rather complicated solutions but is there a simple way to do this? And also a random question: What would be the best language to learn to improve in UIpath? C#? Thanks,

[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