Search code examples
export-to-excel

Export data from Data table to Excel

I have a data table with 49000 rows and 300 columns data. How to export complete data into single excel? I tried the links below but file created with 396MB memory, file unable to open.

  1. http://www.gemboxsoftware.com/support/articles/asp-net-excel.

  2. http://www.codeproject.com/Tips/322964/DataSet-to-Excel-File-Conversion-using-ExcelLibrar

  3. http://exportdata.codeplex.com/

I need a solution to create the excel with less memory(mail attached file size) and open the file , Help me.

Solution

  • change file extension .xls to .csv export large data also.