Anthony Andrews wrote:
Manesh is correct. Just checked with Microsoft and the maximum number
of rows in a sheet is 65,536 and the maximum number of columns is
256. Further, it is not possible to increase either of these limits.
If you are trying to write this amount of data onto a single sheet
then you will have to re-consider the design and split it across
several sheets IMO.
That being said, the limit for HSSF (with -Xmx1g) is around 6,000,000
empty cells, which can be reached without exceeding the maximum row or
column count.
Daniel
--
Daniel Noll
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
