Export GridView to Excel with more than 65536 rows…

Posted: May 14, 2007 | Author: | Filed under: ASP.NET 2 | Leave a comment

"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.