Hi
We have a requirement to generate .xlsx file with more than 500000 rows
and each row contains 35 to 40 columns in it .
Since SXSSFWorkbook has the ability to do without large memory occupation we
tried with following approach.
SXSSFWorkbook workbook = new SXSSFWorkbook(xssfWorkbook, 100);
Until 3 lacs record it is working fine but if we go beyond such limit based
on server load some time we are experiencing the Out Of Memory error .
Also even during the success scenario we feel like it is taking large time
to generate the file .
>From another discussion here we understood like there is another approach
like this
**********************************
*/
"
If you need to generate such large worksheets, I would recommend direct
streaming in XML.
The approach would be to create a template file using poi-ooxml, Setup
sheets, number formats, cell styles, etc.
Then write a custom application that streams data in a text file. You don't
need a deep knowledge of SpreadsheetML
format for that, just follow the pattern in the template. The final step
would be to inject this file in the template. "/*
********************************
Is it recommended to go with above highlighted approach ?
Please provide some suggestions here .
Thanks In Advance ...!
--
Sent from: http://apache-poi.1045710.n5.nabble.com/POI-User-f2280730.html
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
