On Thu, 10 Feb 2011, Ying wrote:
But one thing very strange is that the size of the excels generated will be changed after opening and saving it. For example, the initial size of the file is 183kb, and it will become 76kb after saving it.
POI doesn't do some of the optimisations that excel does. For example, if you have lots of similar styled blank cells in a row, or lots of similar small integer values in a row, the POI file will be larger than the excel one.
(That said, if someone wanted to contribute a patch to have POI optimise to the Mul records at write time as appropriate we'd love to apply it!)
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
