Export data from dataset to excel with more than 65000 records with multiple excel sheets in asp.net

Hi ,

Please check below links for exporting data from dataset to excel with multiple excel sheets in asp.net .

http://www.codeproject.com/KB/office/OutputDatasetToExcel.aspx (This link is working fine but it is accept only 65000 records but excel 2007 it is open the 10 lac records per sheet)


another one if you fine tune that code then we achive the multiple sheets in excel with number of rows.

http://www.codeproject.com/KB/office/ExportDataSetToExcel.aspx

Regards,
Uday