Optimizing workbook for speedy evaluation

2016-07-05 Thread Markus Kirsten
Hi, I’m developing an application that will use Excel for all definitions of calculations/algorithms and then use Apache POI to update a set of (input) cells, evaluate another set of (output) cells and then use these results for presentations. The only Excel files I use are xlsx, so I’m only usi

Re: Optimizing workbook for speedy evaluation

2016-07-05 Thread Blake Watson
1) Ensure I only save relevant sheets/cells from the files (to speed up retrieval/parsing) 2) Override parsing in XSSFWorkbook to avoid unnecessary work such as themes, styles etc 3) Pool the workbooks to avoid creating them every time (even though I need to be able to update them separately for ev