Spreadsheet_Excel_Writer row limitation?
| From: | Josh Santangelo | Date: | Wed, 16 Nov 2005 02:57:31 +0000 |
| Subject: | Spreadsheet_Excel_Writer row limitation? | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-21937@lists.php.net to get a copy of this message | ||
I'm trying out Spreadsheet_Excel_Writer and it seems to work as advertised -- I'm pretty impressed.
However I'm having one major problem, which is that files with a large number of rows cannot be opened by Excel. I get an error that says "The file may be read-only, or you may be trying to access a read-only location." This happens whenever I create a worksheet with more than about 3000 rows. If I stay below that, everything works fine.
I'm wondering if this is a bug, since Excel is supposed to support 65536 rows per workbook.
thanks,
-josh