Export more than 5 lakh records to excel in C#

Question

User-1096956769 posted

Hi,

Please provide me the C# code for exporting more than 5 lakh records in one shot.  I tried with my code. I could able to generate only 3 lakh records after that it throws system memory overflow expection

Thank you 

Answer 1

User269602965 posted

If inserting into XLS there is row limitation of 64,000 rows

If inserting into XSLX there is also limitatons.  Usually when the dataset is over 1 gig in size, XLSX does not perform so well.

Even MSACCESS has size limitations when trying to insert data.

so you have 500,000 records and who knows how many cols,

you may very well expect out of memory errors.