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