poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Jörn Franke <jornfra...@gmail.com>
Subject Re: Large Data Excel generation
Date Tue, 21 May 2019 12:55:31 GMT
Can you share the code?
What is the time and what time do you expect?

> Am 21.05.2019 um 12:58 schrieb rdhanara <rdhanara@ford.com>:
> 
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 

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


Mime
View raw message