Excel support for calling Azure functions with parameters
being able to call an Azure function directly from a worksheet.
Updating this status to reflect the fact that there is no schedule for this, although it’s a really interesting and valid scenario. Please also make sure to send this through Office feedback channels.
David Pallmann commented
Here is one way to invoke an Azure Function from an Excel worksheet:
Chris McManaman commented
Is there a way to vote on this? This would be incredibly valuable.
I would be interested in knowing how this could be done.
Could an Azure Function Library be available within MS Office/ VBA, as well?
Ie if one part of the organisation writes functions within Azure, it is available to other parts within Excel.
This would bring the flexibility of VBA/Excel back to the competent user with all the plumbing and number-crunching done somewhere else.