poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: XSSFWorkbook/SXSSFWorkbook.. takes to much time to generate .xlsx..
Date Fri, 14 Nov 2014 07:47:22 GMT
On Fri, 14 Nov 2014, nitinK wrote:
> I have 64000 records with 13 columns and it is taking 25-30 minutes to 
> generate...can anyone please help me..I have to complete my performance 
> testing...

See the FAQ for advice - http://poi.apache.org/faq.html#faq-N10109 - the 
problem is most likely in your code for fetching Data. Writing a 64k row, 
13 column file with XSSF takes 15 seconds on my laptop (HSSF and SXSSF 
were both 3 seconds). Any problem would therefore seem to be with your 
code, not POI!

Nick

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


Mime
View raw message