how to export 5,00,000 records into excel [xls] format

Posted by Prabu_Spark under ASP.NET on 6/18/2013 | Points: 10 | Views : 2349 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]

Reply | Reply with Attachment

Alert Moderator

Responses

Posted by: Allemahesh on: 6/18/2013 [Member] [MVP] Silver | Points: 25

0	I think you can not export 5,00,000 records into excel sheet. But I am not sure. But you can use the different sheets for different records. E.g.: Sheet 1 -> 50,000 records. Sheet 2 -> 50,000 records. Sheet 3 -> 50,000 records. and so on.... Hope this will help you. Happy coding. Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Harilakshmi on: 6/19/2013 [Member] Starter | Points: 25

0	Hi, You can't because xls is restricted to 65536 rows in total. You would need to devide it into different sheets or use xlsx instead. Thanks & Regards, HariLakshmi. Prabu_Spark, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts