ues.XmlObjectBase.save(XmlObjectBase.java:223)
> > >>> > at
> > >>> >
> > >>>
> >
> org.apache.poi.xssf.model.SharedStringsTable.writeTo(SharedStringsTable.java:279)
> > >>> > at
> > >>> >
> > >>>
> >
>> > at
> >>> >
> >>>
> org.apache.poi.ooxml.POIXMLDocumentPart.onSave(POIXMLDocumentPart.java:468)
> >>> > at org.apache.poi.ooxml.POIXMLDocument.write(POIXMLDocument.java:236)
> >>> > at
> >>> >
> >
t;> > at
>>> >
>>> org.apache.poi.xssf.streaming.SXSSFWorkbook.write(SXSSFWorkbook.java:943)
>>> > at com.excel.writer.ExcelWriter.write(ExcelWriter.java:48)
>>> > at com.excel.writer.ExcelWriter.main(ExcelWriter.java:74)
>>> >
>>> &g
celWriter.java:74)
>> >
>> >
>> > For the poi-ooxml with version 3.17 and its dependency
>> xmlbeans-2.6.0.jar,
>> > memory usage was twice better and it is enough to set 512MB to run this
>> > example, whereas using the latest 4.1.0 version, it requires
gt; OutOfMemoryError. It is not critical for small files like in this new
> > example, but it becomes critical if the file is much bigger and required
> > 10GB or even much more memory to be written.
> >
> > Best regards,
> > Kirill
> >
> >
> > -O
, it requires more than
> twice more memory (1.1GB ) to be executed without
>
> OutOfMemoryError. It is not critical for small files like in this new
> example, but it becomes critical if the file is much bigger and required
> 10GB or even much more memory to be written.
>
> Best reg
POI Users List and did not get any
> information about the raised issue.
> Now I have a subscription.
> Could you please update me regarding the issue?
>
> Best regards,
> Kirill
>
>
> From: Kirill Rajbhandary
> Sent: Wednesday, 5 June, 2019 09:49
> To: user@poi.ap
Dear POI Users Group,
Unfortunately, I found out that the latest POI library poi-ooxml with versions
4.0.1, 4.1.0 consumes much more memory than the version 3.17 when it is
required to write information to already existing large Excel file.
It requires approximately 6GB Java Heap Space to add
