The current version of Excel handles max 64K rows.
We've just had this discussion, sort of... for the record, the above
is an incorrect statement. The current version of Excel supports a
million rows + ... but not in the Excel 97/2000/2003 file format
Will current implementation of
POI allow to address rows beyond 64K limit?
Apparently, this is something they've just started working on and it
will be "many months" before it's available.
The new format is differently encoded. The older format remains
limited forever, it is binary, and a direct descendent of the
original 80's Excel format. Think of the new format as an XML
serialization of the older format.
So, just because the POI developers create support for the larger
format that does not necessarily mean that it won't take lots of
memory to read or write a big file in POI 3.1 - which is where on
their roadmap this support is planned. I think that this is the main
focus for 3.1. The beginning of support for the new format is already
appearing in the svn trunk, but it has been excluded from the just
released 3.0.2 BETA2.
Join the dev list and step up if you must scratch this itch for
yourself!
Regards,
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
