RE : Out of memory exception, and too large files generated

[fr...@ing.be]

sorry, I found out where the problem was, it's in our code...
No POI problem, in fact. *gasp*

-----Original Message-----

I have the same problem exporting smaller files, but my generated sheet
contains many styles and many merged cells, which disables the use of
csv
file...
The file created contains two rows per 'record', in which some cells are

vertically merged, 2 by 2 (7 merged cells for a total of 16 columns).
The size of the generated XLS file is quite too big, and seems to rise
exponentially:
 10 records ->    14 Kb
 20 records ->    28 Kb
 50 records ->   102 Kb
100 records ->   337 Kb
200 records -> 1,220 Kb
500 records -> 7,179 Kb
I get 'out of memory' when generating files for more records...

The tricky bit about it is that when I open and save the 500 records
generated
file using Excel 2003, it's size change from 7,179 Kb to 276 Kb (569 Kb
if I
save to XLS_97 format).

I can't figure out what unnecessary information is appended to the file
(I
opened it with a hex editor, it seems to contain useless bytes, but I
don't
know yet what the structure of these files is).

Does anyone have a clue, or did anyone already encounter this kind of
problem?

__________
Disclaimer: This e-mail is intended for the exclusive use by the
person(s) mentioned as recipient(s). This e-mail and its attachments,
if any, contain confidential information and/or information protected
by intellectual property rights or other rights. This e-mail
does not constitute any commitment for ING or its subsidiaries except when
expressly otherwise agreed in a written agreement between the
intended recipient and the originating subsidiaries of ING, sender of
the mail.
If you receive this message by mistake, please, notify the sender
with the "reply" option and delete immediately this e-mail
from your system, and destroy all copies of it. You may not, directly
or indirectly, use, disclose, distribute, print or copy, this e-mail
or any part of it if you are not the intended recipient.
You have to take at any time all necessary measures against viruses.

---------------------------------------------------------------------
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/