I need to generate spreadsheet with a huge amount of data. It is about 6 full sheets. The size of the file I create is more than 80MB. If you create the same sheet using the Excel application it is much smaller. I was setting a style on each cell (creating styles and reusing them from the style array stored in the worksheet). To try to make it smaller I started assigning default styles to each column. That did not seem to make any difference.
Are there some techniques I can use to make the spreadsheet take up less disk space? Keeping the large file in memory is causing the server to get OutOfMemoryExceptions at different points depending on what else is going on on the server at the time. We have set the max memory on the server to 1.5GB. If it matters, we are running on Sol 8 with BEA Weblogic 8.1 sp5. Thanks in advance for any hints. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
