Hi! Would like to use POI to create large spreadsheets, say 100 columns x 64000 rows. Have noticed in some simple testing, that the space the JVM takes is roughly 10 times the size of the resulting spreadsheet (e.g. 1.2 Gig used for a spreadsheet of 110Meg). Using Microsoft Office as a server uses space roughly proportional to the size of the spreadsheet (e.g. 120Meg) while taking substantially longer.
Questions: 1) is there a space/time tradeoff in POI? Are there options which could reduce the memory footprint while lengthening the time needed to create the spreadsheet? 2) is there an ability with POI to incrementally create the spreadsheet instead of having to create the whole thing and then write it to a stream? 3) might there be another solution than POI which would take less memory for large spreadsheets? (though we much prefer the use of POI) Thanks much for any help! Dennis Dennis Freidel Dfreide at searshc.com Phone: (847) 286-3214 extension 63214 IT Systems Engineer Sears Holdings Corporation, 3333 Beverly Road, E3-266A Hoffman Estates, IL 60179 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
