Hi sir,
Tell me the steps to export 5,00,000 records into excel [xls excel 2003 format]. I can able to export 65,536 rows.
If i export 5,00,000 records, i am getting System out of memory exception, Kindly give me the solution for this problem.
Loading
Pankaj PandeyPosted Jun 19, 2013, 12:58 AM
i suggest you to use excel 2007 or higher version to store the high volume of rows.
Ravishankar SinghPosted Jun 18, 2013, 8:27 AM
Ravi ShekharPosted Jun 18, 2013, 7:30 AM
Try to use higher version of excel. you can save 500000 or higher data in excel 2007 and higher. Or you can use .csv to store data.
Regards,
Ravi shekhar
Santhosh Kumar JayaramanPosted Jun 18, 2013, 7:23 AM
Check Microsoft;s link
http://support.microsoft.com/kb/120596