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