Last post Dec 11, 2013 11:06 PM by chetan.sarode
Nov 21, 2013 10:35 AM|tsonev7|LINK
Hi. I have a report and when I run with a lot of data, exception is thrown which says that the row limit for excel sheet is exceeded.
Excel Rendering Extension: Number of rows exceeds the maximum possible in a worksheet of this version. Rows requested: 289843. Maximum rows: 65536.
My report structure doesn't allow the page to span more than 150-200 rows per page ( I've set page breaks). From what I understand, the reportviewer creates all the data into one worksheet and after that it split it into multiple worksheets depening on the
page breaks. That's the only reasonable think that could be happening.. Anyone has an idea if that is the case or something else ?
Dec 11, 2013 11:06 PM|chetan.sarode|LINK
From your description, it seems that you are failed to export data to excel which is more than 65536 records?
In Microsoft Excel 97 for Windows, Microsoft Excel 2000, Microsoft Excel 2002, and Microsoft Office Excel 2003, text files that contain more than 65,536 rows cannot be opened in their entirety. You cannot open these files because these versions of Microsoft
Excel are limited to 65,536 rows. If you open a file that contains more data than this, the text file is truncated at the row 65,536, and you receive the following error message:
File not loaded completely.
However, you can use a macro to open the file and automatically break the text into multiple worksheets
Versions of Excel earlier than Excel 97 have a limit of 16,384 rows.
Versions of Excel later than Excel 2003 have a limit of 1,048,576 rows.