Hi all,
Currently I'm working with apache POI in 3.9 version (can't use upper
version for the moment).
With this code :
String path = getFilePath();
FileInputStream fis = new FileInputStream(path);
Workbook wbk = WorkbookFactory.create(fis);
return wbk;
I observe the creation of workbook is VERY slow for a xlsm file. When I try
with XSSFWorkbook the problem is the same.
The file is not especially big (260 Ko) and the performance are 50 worst
than an xls file.
This code is execute on local JVM, not in server context.
I already saw this issue on mailing list but I don't find solution for me.
In my program will open dozen and dozen XLSM file and the program have
performance constraints so in need to have an optimize this. Do you have a
solution?
NB : I just try to set parameters to my JVM with more memory but it don't
have any effect
Thanks for your answer.
Best regards,
Alexandre Lefèvre
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/WookbookFactory-and-XSSFWorkbook-very-slow-with-some-file-POI-3-9-tp5714902.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
