Hello All,
I was in need of exporting multiple tables in a DataSet to an Excel file with multiple sheets. I found a very good article in codeproject.com.
http://www.codeproject.com/KB/office/ExportDataSetToExcel.aspx was able to successfully export each of my datatables in the dataset to excel worksheets. This solution worked for small number of rows. But when the data got larger I am consistently getting the system.outofmemoryexception. THis is because the code is using up the memory when creating excel.
Does anyone have another option to do the above?
Thanks in advance
...
Go to the complete details ...