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: [email protected] > 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/
