Free Support Forum - aspose.com

Force Excel Recalculatons

I have an Excel file with several heavy duty actuarial calculations. In an ASP.NET application, I want to pass in values to the appropriate cells, do a spreadsheet recalculation, and fetch the results.

Excel on the desktop does this through background recalculations. What's the best way to do this in a Web-based way? Is there any example somewhere? Do I save the file into a stream first?

Hi,


Sure you may do it with Aspose.Cells. Aspose.Cells has its own Formula Calculation Engine that is a bit efficient too. You may simply load or open your template file by Aspose.Cells e.g
Workbook wb = new Workbook(file_Path);
and then input your values into the cells then perform the calculations by calling Workbook.CalculateFormula() method at runtime, now you are good to go for retrieving the calculated values.

See the topics for your reference:
http://www.aspose.com/docs/display/cellsnet/Calculating+Formulas
http://www.aspose.com/docs/display/cellsnet/Calculating+Formulas+Once+Only

Thank you.