On Mon, 14 Jan 2008, Rick Root wrote:
I recently started using the poi library (version 2.5 something is included with Adobe Coldfusion)... and I'm using it to generate excel spreadsheets.
It's probably worth upgrading to 3.0.1, or even better 3.0.2 beta 2, as there have been lots of bug fixes since then
Unfortunately, there seems to be a limitation of 65536 rows, while Excel 2007 can handle many many many more.
Only in its own format (xlsx or xlsb). If you try to save a file with than 65,536 rows or 256 columns as a normal xls file, you get a big error out of excel, and it truncates your data to fit
Since Excel *DOES* support something like a million rows and thousands of columns now, does anyone know if newer versions of POI support the "big grid", or if there are any plans for such support.
The ooxml support (for .xlsx files) will almost certainly support larger numbers of rows and cells. However, work on that has only just started, so won't be ready for many months
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
