On Tuesday, May 26, 2015, Nick Burch <[email protected]> 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
