In my Java project I use the Excel-FrameWork "SmartXLS" to calculate Excel files. http://www.smartxls.com/indexj.htm
To do this, the file is filled with values and then these are calculated using the method:
workbook.recalc();
This all works well. The only problem is when the file contains several sheets and a lot of formulas.
The time for the calculation with SmartXLS is between 5 - 7 seconds (workbook.recalc()).
I realize that in Java you probably can't reach the speed of calculation as when Excel runs native for example in a Windows environment. To reduce the size of the file I have already reduced the formulas to a minimum.
Do you have experience with SmartXLS? Are there any tips and tricks to speed up the calculation?
Or do you know other FrameWorks that provide fast calculations?
Does anyone have experience with POI and large Excel files and many calculations?