I'm having the exact same issue, I've tracked down this message from
StackOverflow.
I've tested read performance on two XLS and XLSX with identical content
(around 75000 rows, 25 columns).
HSSF takes under 5 sec; XSSF takes 15-20 sec.
Any idea what is the issue with XSSF performance?
On 15.02.2016 17:00, Drew Spencer wrote:
Mike DeHaan <mike <at> mikeandzoya.com> writes:
As a followup, a user has replied to my stack overflow post with some
information that might be helpful in tracking this issue down. Here is
the
link to his post:
http://stackoverflow.com/a/34266795/4471563
I ran the same tests in my environments and came up with similar
numbers.
-Mike DeHaan
I have also asked the same question. Would love to get an answer to this
either way. My similar post on StackOverflow is here:
http://stackoverflow.com/questions/34995058/apache-poi-much-quicker-
using-hssf-than-xssf-what-next
I received an good answer with the link to the streaming reader, but
unfortunately I don't think I can use it because my code runs on app
engine.
Thanks to anyone that can help.
Drew Spencer
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
