Hi Matthias, U may try event based POI APIs to read the large excel sheet. Though its not as simple as user model APIs but takes less memory.
Cheers Joe -----Original Message----- From: Karr, David [mailto:[EMAIL PROTECTED] Sent: 28 March 2007 06:28 To: POI Users List Subject: RE: How to read just one sheet out of a large excel file? The options "-Xms -Xmx" are intended to be supplied with actual memory values. Specifying "-Xmx" by itself doesn't do any good. You might try "-Xmx1024m". > -----Original Message----- > From: Matthias Knapp [mailto:[EMAIL PROTECTED] > Sent: Tuesday, March 27, 2007 2:54 AM > To: poi-user@jakarta.apache.org > Subject: How to read just one sheet out of a large excel file? > > Hi, > > I´d like to read and write within an existing excel file (10 > MB) via HSSF, but I always encounter an OutOfMemoryError (not enough > heap space). The options java -Xms -Xmx don´t work. > > So my question is, if there is any possibility to read (and > write) only one sheet out of the whole excel file to avoid the heap > space problem? I only need to change data in one sheet, so the other > sheets (main part of the 10 MB) don´t interest. > > Please anyone suggest me how to do this > > thanks and rgds > Matthias > > > --------------------------------------------------------------------- > 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/