Re: subject: Re: Worksheet failing when reaching a large number of rows-Using SXSSFWorkbook

Hi all, Don
I see from your code the main difference with mine: you use a new object
when calling new_SXSSFWorkbook(). In our case, we create a streaming
workbook from an opened xssf workbook: we need to get from an existing xssf
a given template, which later is populated with rows created with the SXSSF
workbook. From what I understand, it is a valid way to create a SXSSF
workbook. POI documentations have several constructors for SXSSF workbook,
and the third one says
SXSSFWorkbook
<https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/streaming/SXSSFWorkbook.html#SXSSFWorkbook-org.apache.poi.xssf.usermodel.XSSFWorkbook->
(XSSFWorkbook
<https://poi.apache.org/apidocs/dev/org/apache/poi/xssf/usermodel/XSSFWorkbook.html>
workbook)
Construct a workbook from a template.
where that template is a XSSF object.I have seen some comments on this
object creation, saying that it means it is a plain XSSF object, and Excel
is created entirely in memory. I can`t believe that opinion. But experience
is the last truth. Does anyone have experience creating a SXSSF object from
a given template?
We continued testing, and indeed the problem happens when calling the SXSSF
write method. It means for me that POI can't write from a large temp file
to an Excel physical file. We will try changing the memory heap for our
java session, but it will be done next week. We used java with default
configuration until now.
Default config uses 2GB of heap. We will try 4GB. Maybe it is not the
problem, but I will try. (Our support recommended giving it a try.).
I was not able to get some cases from the POI site on this issue. Maybe I
did not search properly. I have some time to try this week. Maybe.
Thanks again, Don for your interest. I hope it will be solved, and I will
post my findings here.
Kindly
Jorge Ubeda