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.