I have a web service that inputs values into a large excel work, then has Aspose run CalculateFormula on the Workbook, and finally gets around 10 values from the spreadsheet.
Thanks for your posting and using Aspose.Cells for .NET.
Please set the Workbook.Settings.CreateCalcChain=false and see if it increases your performance.
Please see the following documentation article for your complete reference.
I didn’t see any difference in my unit test time. I’m going to see if it makes any difference when running in the web services.
Thanks for your feedback and using Aspose.Cells for .NET.
It makes difference when there are lot of diverse formulas inside a workbook
Other than this, you can also try the Worksheet.CalculateFormula() and direct calculation of the formula as discussed in this article and see if any of them could make any difference in your scenario.