I’m looking to use Aspose Cells as a calculation engine for a very large excel tool using java. I only need to define a few cells as inputs and other cells as outputs.
For example, I put a value into cell #1 and I want to get the output of cell #2. The issue is that the formula in cell #2 refers to many different preceding cells in different worksheets which also have formulas pointing to other cells.
Does Aspose provide a way of serializing/extracting/compiling these formulas in an efficient way based on inputs and outputs that can be saved to the disk and be reloaded in the future so I wouldn’t have to load the entire workbook again for each run?
Or is there a way to convert the formula into a java function that takes inputs and returns calculated outputs without having to modify the underlying workbook cells and recalculate in Aspose?