poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Nick Burch <apa...@gagravarr.org>
Subject Re: WorkbookFactory.create taking long time
Date Tue, 26 May 2015 07:56:15 GMT
On Tue, 26 May 2015, Vipin wrote:
> Workbook wb = WorkbookFactory.create(attachment.getDataHandler.getInputStream());
>
> This call takes around 1400 ms to read 10k rows , each row has 4 column 
> and there is no formula. All columns have numbers and strings only.

I'd suggest you start with the advice in 
http://poi.apache.org/faq.html#faq-N10109, as well as ensuring that the 
delay isn't actually reading your attachment over the network!

There's also http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api if 
you really can't use XSSF usermodel, but for that kind of file it's 
unlikely

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


Mime
View raw message