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
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