Divide data from one Datatable to two?

Question

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?.

Tirthak Shah · Answer

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