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: [email protected]
For additional commands, e-mail: [email protected]
