Export GridView to Excel with more than 65536 rows…

"Export Gridview To Excell more than 65536 records " http://forums.asp.net/thread/1708589.aspx

There is a work around for this issue. The new Office 2007’s Excel has this: "The Excel 2007 "Big Grid" increases the maximum number of rows per worksheet from 65,536 to over 1 million…".

You can use your export code to save the file as usual and open this file in Excel 2007 and save it in the new format with the extension .xlsx.

 

Advertisements