Re: 64K Row Limit In Excel and POI

[Rick Root <ri...@webworksllc.com>]

On 1/15/08, Borisov, Viktor <Vi...@gs.com> wrote:
>
> 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.

-- 
Rick Root
New Brian Vander Ark Album, songs in the music player and cool behind
the scenes video at www.myspace.com/brianvanderark

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: 64K Row Limit In Excel and POI

[David Fisher <df...@jmlafferty.com>]

>>
>> 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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org