Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Message-ID: <474A418B4638D2119A820001FAF8F77B0C842219@usfrmx01.medco.com>
From: "Suarez, David" <david_suarez@medcohealth.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Subject: RE: Is is possible to incrementally write an Excel document creat
	ed u sing POI/HSSF?
Date: Mon, 13 Jan 2003 13:07:31 -0500
MIME-Version: 1.0
Content-Type: text/plain

Is memory efficient?
I'll let the bench numbers speak for themselves.
Java JVM setting of -Xms128M -Xmx512M     in order to create 20meg file

When JVM memory setting was lower,  it would crash with "Out of Memory".
So the benchmark numbers mean 512meg is needed to create 20meg file.

I am also looking for a way flush the contents of memory but keeping
Workbook object intact( which I believe has the Spreadsheet "header" info)
so I can create more rows.   I did not notice anywhere in the api an
"append" method.  

I'm glad to see that I am not only one who has encountered this limitation. 
 

-----Original Message-----
From: Dana Spiegel [mailto:dana@farechase.com] 
Sent: Monday, January 13, 2003 12:50 PM
To: 'poi-user@jakarta.apache.org'
Subject: Is is possible to incrementally write an Excel document created u
sing POI/HSSF?

I'm programmatically generating an Excel document that contains a lot of
data (the final document size is 20+ MB). I would like to incrementally
flush the document to disk to conserve memory usage (so the entire document
doesn't have to kept in memory through the POI package).

Is this possible? Is the POI/HSSF package efficient in its memory usage such
that such a thing isn't necessary?

Any insight would be helpful; I've searched the archives and can't seem to
find any discussion of this issue...

Thanks,

D a n a   S p i e g e l 
FareChase  ::  www.farechase.com 
50 West 23rd Street, PH, New York, NY 10010 
p  +1 646 452 0665  ::  m  +1 917 402 0422  ::  f +1 646 452 0667  ::  e
dana@farechase.com