How to run Office Web Add in automatically on opening/closing Excel

0
votes

I am using 'Office Web Add In' to add some functionality into the office applications like excel,word etc.I want to trigger this functionality on opening/closing of excel.

Problem is the Office Web Add In runs only on user-interaction, when the user clicks on the menu in the ribbons option.

I am not able to trigger this add-in functionality automatically. This is achievable in other type of add-ins such as Excel- VBA or VSTO Add In.

How can I trigger the add-in functionality automatically on opening excel ?

Have searched for a solution online, but could not find so. Found something called as 'Auto Open Task Pane' feature which still does not works properly.

1
office-jsexcel-addins

1 Answers

0
votes

I am assuming you are addin is built through office yeoman generator or may be on your own with proper manifest file.

Please see the official docs

https://docs.microsoft.com/en-us/office/dev/add-ins/develop/automatically-open-a-task-pane-with-a-document

Please note: Auto open will only work on the below applications.

enter image description here

Also in your manifest file you can add

<Action xsi:type="ShowTaskpane">
    <TaskpaneId>Office.AutoShowTaskpaneWithDocument</TaskpaneId>
    <SourceLocation resid="Contoso.Taskpane.Url" />
</Action>

More clear documentation is available on the official link.

Hope it helps.