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

[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,