I think u still ve an option Michael. Try using event model to process ur excel file. They say its fast and lighter.
But any suggestions for downloading..guys?? Cheers Joe -----Original Message----- From: Michael J. Prichard [mailto:[EMAIL PROTECTED] Sent: 21 February 2007 05:06 To: POI Users List Subject: Re: OutOfMemory - POI Interesting. I am trying to process a 34 MB file and I am getting a heap error as well. It dies when I do: HSSFWorkbook wb = new HSSFWorkbook(is); (is == InputStream) I am using POI 3.0 alpha 3 Any ideas? -Michael Joshi, Shailesh wrote: >Thanks Jai, > >Its 512mb , could u plz let me know ur heap size? Also what other care I >should take? > >Cheers >Joe > >-----Original Message----- >From: jaikiran pai [mailto:[EMAIL PROTECTED] >Sent: 20 February 2007 06:25 >To: POI Users List >Subject: Re: OutOfMemory - POI > >25K rows is not huge. I have been using HSSF for larger data without any >issues. What's the JVM heap size that you have currently? > >regards, >-Jaikiran > > >----- Original Message ---- >From: "Joshi, Shailesh" <[EMAIL PROTECTED]> >To: [email protected] >Sent: Monday, 19 February, 2007 2:23:37 PM >Subject: OutOfMemory - POI > > >Hi, >I'm using POI to download excel file with around 25K rows and around 90 >columns, but its throwing OutOfMemory error at certain point. What should be >the JVM heap size for such a large file to download from server. I am using >POI 3.0. Is there something where we can write data chunk-by-chunk so that it >will consume less memory? any tricks n tips for this issue? > >cheers >Joe > >======================================================================= >======= Please access the attached hyperlink for an important >electronic communications disclaimer: > >http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html >======================================================================= >======= > > > >__________________________________________________________ >Yahoo! India Answers: Share what you know. Learn something new >http://in.answers.yahoo.com/ > > >======================================================================= >======= Please access the attached hyperlink for an important >electronic communications disclaimer: > >http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html >======================================================================= >======= > > >--------------------------------------------------------------------- >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/ ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== --------------------------------------------------------------------- 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/
