Java Programming

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

PROBLEM : Jakarta POI - writing large Excel files

807569May 27 2006 — edited May 27 2006

I have a program that extracts a lot of data from about 1500 txt files. I want to save this data to an excel file.
Everything works fine, but when the amount of data gets too large, I get an java.lang.outOfMemoryError! It works with 200 files.
The problem is, everything is in the memory until all data has been collected, THEN it's written to a file.

Is there a method to partially write a excel file with POI, so I can handle larger amount of data or something like that? starting the program with -xmx or -xms won't help.

Thanks for any help!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 24 2006

Added on May 27 2006

7 comments

248 views