On Thu, 19 Nov 2009, Cyril.Chang wrote:
Issue Description : We Create an Excel File Manually with 218X1000 Cells say test_2.xls And then generate the same data via POI HSSF to output another file say test_2_poi.xls The file size test_2.xls : 1335 KB test_2_poi.xls : 3887 KB (is more than double size of test_2.xls)
If your document contains lots of small numbers, this is to be expected. I suspect Excel is making using of MulBlank and MulRK records, which compress the data for several adjacent cells into one record. POI doesn't currently. You can probably buy a lot of 2TB disks for the cost of sponsoring the development to add the compression feature to poi...
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
