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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
