Call Excel REST API using app only permissions
I would like to be able to call the Excel REST API using app only permissions.
My use case is to have excel workbooks with models that have complex calculations. I could then use then call the Excel REST API from say an Azure Function using a Managed Identity that first populates some cells (that are parameters so to speak) and then calculates the workbook and gets the result from another cell, so basically I can delegate the "programming" of the complex model to a finance user who knows how to build complex models in excel.
I would effectively be using the Excel workbook as my custom calculation engine, allowing me to build some non-trivial code as a (straight-forward to any finance expert) model, and I can simply use the Excel REST API to "return" the result of the calculation.
Dont see why this isn't allowed as an application with app only permissions can add or delete a document that is an Excel workbook so why not allow it to manipulate the contents as well?