I am Working On an Reporting Related automation Process, Where i am dealing with the Large Datatable.
Currently We are facing a Problem Due to Larger File Size where the Size is Exceeds 25MB We are not able to Send the File in Attachment to the Particular Stake holder.
To Resolve this Issue I have Decided to Divide the Excel file As per the Numbers of Rows.
So If the Size of the Excel File will Exceeds 25MB, In that case I will Store Some of the Rows in Other File and Remove the Same From Main File and Send it to Stake Holders.
I wanted to Access the Datarows as per the index. For Example if My Source Datatable has 100000 Rows, then I want to Divide this in Two Files.
1st File should have 1 to 50000 Records and the Second Should have remaining One.
Can Someone please help me out to Achieve this?
I can iterate the Datatable but Due to Large Numbers of Rows It will take Quite Long time so would not Prefer to use them.
Any Help is Very Appreciated.
Thanks in Advanced.