You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Oleg Rempel <Re...@managetopia.com> on 2012/02/17 15:04:42 UTC

change from poi-3.7 to poi-ooxml-3.7

Hello,

I am working with the apache.poi developments for MS Excel Input/Output. After 
changing from the HSSFWorkbook to the XSSFWorkbook, requires at my java 
program more MBs of RAM. 1,5 GB in place of 260 MB. 
Can this be controlled? Are there properties / settings of Excel that can be 
deactivated for this?
Thanks for any help.

Oleg



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


Re: change from poi-3.7 to poi-ooxml-3.7

Posted by Oleg Rempel <Re...@managetopia.com>.
Thank you, Nick!
Thank you, Yegor!
It has helped!


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


Re: change from poi-3.7 to poi-ooxml-3.7

Posted by Nick Burch <ni...@alfresco.com>.
On Tue, 21 Feb 2012, Oleg Rempel wrote:
> Oleg Rempel <Rempel.Oleg <at> managetopia.com> writes:
>> I am working with the apache.poi developments for MS Excel 
>> Input/Output. After changing from the HSSFWorkbook to the XSSFWorkbook, 
>> requires at my java program more MBs of RAM. 1,5 GB in place of 260 MB.

Sounds about right. The .xlsx format needs more memory to process

>> Can this be controlled?

Are you reading or writing? If reading, you can use sax based parsing for 
a streaming, low memory way to read a .xlsx file. For writing, SXSSF lets 
you write in chunks, minimising the amount of stuff that has to be kept in 
memory. See the website for details on both

Nick

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


Re: change from poi-3.7 to poi-ooxml-3.7

Posted by Oleg Rempel <Re...@managetopia.com>.
Oleg Rempel <Rempel.Oleg <at> managetopia.com> writes:

> 
> Hello,
> 
> I am working with the apache.poi developments for MS Excel Input/Output. 
After 
> changing from the HSSFWorkbook to the XSSFWorkbook, requires at my java 
> program more MBs of RAM. 1,5 GB in place of 260 MB. 
> Can this be controlled? Are there properties / settings of Excel that can be 
> deactivated for this?
> Thanks for any help.
> 
> Oleg
> 


No comments?
Or is my question not understandable?

Oleg



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