Export more than 5 lakh records to excel in C# RRS feed

  • Question

  • User-1096956769 posted


    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 

    Tuesday, May 19, 2015 3:58 AM

All replies

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

    Tuesday, May 19, 2015 12:28 PM