Work with Excel formulas in Spreadsheet with Aspose.Cells RESTful API

Aspose.Cells Cloud Product Family
,
1

Hey folks,


We’re considering using Aspose.Cells Cloud for a project. We’re thinking of using an Excel spreadsheet (.xlsm - with macros and formulas) as a backend to drive a web application. Here’s what we’re thinking of:

1. The user will be able to input some values from the website, which will be written to the excel spreadsheet.
2. The spreadsheet performs some calculations based on the user input.
3. We read the output of the formulae from the excel spreadsheet and present that information to the user on the website.

My question is whether this is possible to achieve using Aspose.Cells Cloud? And more specifically, can Aspose.Cells Cloud force Excel to recalculate formulae after writing to some cells?

Thanks!
2

Hi,


Thanks for your posting and considering Aspose.Cells.

Excel formulas are supported but the execution of Macros are not supported.

Aspose.Cells for Cloud uses Aspose.Cells behind the scenes, so these excel formulas should be supported in Cloud too.


So your requirements are achievable but if you exclude Macros and if your formula is found in the above article.

ramfe3e3:
can Aspose.Cells Cloud force Excel to recalculate formulae after writing to some cells?

Yes, this is supported as explained earlier. Thanks for your understanding and have a good day.