Loading

Divide data from one Datatable to two?

KRayudu V

12y1.7k.NET

I´m exporting Datatable to Excel workbook.

Problem is that excel can limited rows in every sheet.

So..

How can i divide one Datatable to two Datatable. Then i can have Datatable1 in sheet1 and Datatable2 in sheet2 any idea?.

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Tirthak Shah12y ago
Hii,

Try This inbuilt function Of Datatable
1. dataTable.Skip(0).Take(100);
2. dataTable.Skip(100).Take(100);
3. dataTable.Skip(200).Take(100);
4. dataTable.Skip(300).Take(100);
I hope It will Help You
0