poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vipin Sharma <vipinsharm...@gmail.com>
Subject Re: WorkbookFactory.create taking long time
Date Tue, 26 May 2015 12:26:11 GMT
On Tuesday, May 26, 2015, Nick Burch <apache@gagravarr.org> wrote:

> 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
>
> I tried SSPerformanceTest , i am able to get result in 1-2 seconds in all
cases.
Best result is in case of HSSF. WorkbookFactory.create() takes around 650
mili seconds and I am loading 1.5 mb file from network so i think it is
acceptable.

Is there any way i can improve performance of XSSF file ?


-- 
Thanks
Vipin Sharma
+919769618738

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message