poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <n...@torchbox.com>
Subject Re: Questions on creating large spreadsheets with POI
Date Fri, 08 Feb 2008 11:54:54 GMT
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message