Created Excel File Size

[ap...@charter.net]

I am creating a spreadsheet with a large amount of data.  It has about 5 full (over 65000 rows) sheets.  The size of the file is about 91MB.  When I create the same file manually using Excel 2003 sp2, the file size is about 46MB.  I thought the problem might be formatting cells.  Originally, I was using POI 2.5 and formatted each cell individually.  I changed to POI 3.0 so I could format an entire column, but I still have this issue.  I am applying styles to individual cells when I manually create the large spreadsheet then cutting and pasting the rows to get the number I need to emulate the generated spreadsheet.

Is there any way to reduce the size of the spreadsheet I am creating using POI?

Thanks.

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org