Hi,
Is there any method or way to refresh the .xlsx file with formulas using java aspose.cell.
My requirement is on click of a button a predefined aspose spread sheet with formulas (calculations)should populate datas to be specified sheets and using this input data, the sheet named 'OUTPUT 'should run the formulas and calculated result should upload to database. The import data from database is working perfectly fine but when I take the calculated data from 'OUTPUT ' giving the value "#N/A". That means the automatic calculation (refresh) is not happening. I have tried with the method 'workbook.calculateformula()', but it taking large amout of time to finish the calculation since the spreadsheet have lot of calculations.
It would be great if any one can provide me a solution ASAP.
Thanks & Regards
Aneesh