About the size of Excel generated by POI

[Ying <se...@gmail.com>]

Hello,

I'm generating excels by POI.
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.

Does anyone know about the reason for this and how can I get the final size of 
the file at the very beginning?

Thanks and Best Regards


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

Re: About the size of Excel generated by POI

[Nick Burch <ni...@alfresco.com>]

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org