We are currently in the process of evaluating Aspose.Cells java for our project and have some difficulties understanding whether the tool can solve the following need:
In brief, we want to use Excel spreadsheets as a calculation engine and integrate it to our java application (which will handle persistence). We have some template spreadsheets with formulas. Our java application will select some data from the database, put them in one tab of the spreadsheet. At this point, we expect Aspose to refresh the value of the formulas of the spreadsheet. Then our application gets the results of those formulas and store them to the database.
Is it possible with Aspose Java ? How ?
Thanks in advance for your answers.