Have you tried forcing the JVM to run the garbage collector before calling the write method? I do not know if it will help at all but you can quite quickly make the necessary cahnge to your code and run it to check.
"Gossard, Ann L." <[EMAIL PROTECTED]> wrote: I tried that. I made it 1G and it still did it. Thanks for the response. -----Original Message----- From: Paul Häder [mailto:[EMAIL PROTECTED] Sent: Monday, November 13, 2006 1:30 PM To: POI Users List Subject: Re: question Ann, when you're dealing with large files like that, you might want to try increasing the JVM's maximum heap size with the "-Xmx" option. Paul Gossard, Ann L. wrote: >Question: Is POI able to support multiple reading and writing to >different XLS files? I have 3 XLS files, 1 is read only, and I handle >this one by reading in everything I need then closing and doing garbage >collection. The other two are read/write and can get pretty big, i.e. >1000 excel sheets in one doc. I get an 'out-of-memory' exception on the >workbook.write(out); for the 1000 sheet workbook. The other excel file >has only one sheet but 1000 lines on Sheet1. Suggestions? > >If this has come up previously, then please forward to me the suggested >solution. > >Thank you, > >Ann > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------- Cheap Talk? Check out Yahoo! Messenger's low PC-to-Phone call rates.
