excel - Execute both custom function and commands function in a shared runtime using office js

Question

I have built an Excel Addin using Excel JS API. The addin generates a custom function, so I have followed the instructions provided here so that I can create the required shared runtime environment. Now I would like to add a button on the Ribbon of xsi:type="ExecuteFunction"

I know that in general I have to specify the FunctionFile resource to point to commands.html and there (command.js)implement my function which will actually just open a link on a browser. It will be a help/manual button. But the configuration suggests that we should update FunctionFile resid to point to functions.html instead of commands.html. I have tried to make it this way but it does not work on Excel Desktop App. It only works on Excel Online.

Is there a workaround for this, so that I can keep my working custom function and trigger a function/command from a ribbon button?

标签： exceloffice-jsoffice-addins

Answer 1

共享 javascript 运行时的限制

iPad 或一次性购买的 Office 2019 或更早版本目前不支持 Excel 自定义函数。