Friday, February 24, 2012

Export to Excel - more than 65536 rows

when exporting data to Excel..is there any way ..if data is more than 65536 rows.. it export the remaining data in next sheet

Out of curiosity, are you using a MicroSoft class to do this? Which one? And does it have a sheet number property?

|||

Hi,

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.

For how to use a macro to open the file, see:

http://support.microsoft.com/kb/120596/en-us

Thanks.

No comments:

Post a Comment