You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Tobias Meyer <tm...@allocation.net> on 2005/11/03 20:08:13 UTC
Excel out of memory when using HSSFCell.ENCODING_UTF_16
Hello list,
I'm using poi-2.5.1-final to generate an excel sheet with 92 columns - text,
numbers, booleans and dates.
The problem occurs, if I use the UTF_16 encoding (which I need for chinese
letters), but not if I use HSSFCell.ENCODING_COMPRESSED_UNICODE.
Excel completely refuses to open the generated file with an error message
"not enough memory" (a translation from german, so this propably is not the
exact message).
OpenOffice can open the file, but has many cells with "*** ERROR IN SST
***", starting in row 628 of approximately 6500, in column 72. (that is cell
nr. 57756).
The problem does not occur if there are fewer lines (than ca. 600?? - I have
not extensively tested this)
I tried to write a testcase, but unfortunately the problem seems to be a
little tricky to trigger.
Has anyone seen similar behaviour before?
What can I do to investigate further?
Thanks a lot,
Tobias
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
Re: Excel out of memory when using HSSFCell.ENCODING_UTF_16
Posted by Karl-Heinz Zengerle <ka...@sawag.com>.
Hi Tobias.
Does this also occur if you build an Excel file with the same content
newly from the scratch? Your file seems to be corrupted.
If you increase Java VM (e.g. -Xmx256m) what's the result then?
Regards, Karl-Heinz.
Am Do 03.11.2005 20:08 schrieb Tobias Meyer <tm...@allocation.net>:
> Hello list,
>
> I'm using poi-2.5.1-final to generate an excel sheet with 92 columns -
> text,
> numbers, booleans and dates.
> The problem occurs, if I use the UTF_16 encoding (which I need for
> chinese
> letters), but not if I use HSSFCell.ENCODING_COMPRESSED_UNICODE.
>
> Excel completely refuses to open the generated file with an error
> message
> "not enough memory" (a translation from german, so this propably is
> not the
> exact message).
> OpenOffice can open the file, but has many cells with "*** ERROR IN
> SST
> ***", starting in row 628 of approximately 6500, in column 72. (that
> is cell
> nr. 57756).
>
> The problem does not occur if there are fewer lines (than ca. 600?? -
> I have
> not extensively tested this)
>
> I tried to write a testcase, but unfortunately the problem seems to be
> a
> little tricky to trigger.
>
> Has anyone seen similar behaviour before?
> What can I do to investigate further?
>
> Thanks a lot,
> Tobias
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> Mailing List: http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/