On Thu, 7 Feb 2008, Freidel, Dennis wrote:
Would like to use POI to create large spreadsheets, say 100 columns x
64000 rows.
The excel file format really wasn't designed to handle files that size
very well. You'll be much better off writing your data out as a CSV. Excel
will still load it just fine, but it'll be much much more memory and speed
efficient to write it out
1) is there a space/time tradeoff in POI?
Only in the sense of memory use vs available poi developer time :/
(There's certainly interest in making poi more memory efficient, but it's
a hard problem, and thus far no-one has been willing to work on it /
sponsor someone to work on it)
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?
No, only streaming read is supported. The excel file format just isn't set
up for streaming write, it's much to self-referential
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
