Excel javascript custom functions deployement

Question

Now that I built my first Excel javascript custom function I want to deploy it so users can add it in their sheets, but didn't find any useful infos. My questions:

What to deploy exactly? (manifest, js files...)
Where to deploy? Is a shared folder enought?
Do I need NodeJs in client machines?

Deploy custom function could be similar to deploy an Office Add-in, here's the docs may help you: Custom Function, Publish, You need to publish your website(js) to a server, and the put the server website in the manifest, and share the manifest to others. For internal share, you could use ScriptLab — Dongqi Lv
– Dongqi Lv, Commented Aug 10, 2020 at 3:17

Phoebe Yuan · Accepted Answer · 2020-11-20 04:57:39Z

1

The over view introduction on how to deploy custom function could be find Custom function. Custom Function deployment is similar to an Office Add-in and change in manifest is needed.

answered Nov 20, 2020 at 4:57

Phoebe Yuan

913 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

RESTfulInSeattle · Accepted Answer · 2023-06-18 07:07:56Z

*Edit, I found this section, and will update my answer when I've successfully deployed to production.

https://learn.microsoft.com/en-us/office/dev/add-ins/publish/publish?view=excel-js-preview

Deployment documentation is hard to find. The dist folder contains the files for a Production environment. Look for the Resources node in your manifest.xml. Here is one referring to files in localhost. These are in the dist folder. You'll want to upload the contents of the dist folder to a server file share, or S3 bucket, after all of your changes have been built.

<Resources>
      <bt:Images>
        <bt:Image id="Icon.16x16" DefaultValue="https://localhost:3000/assets/icon-16.png"/>
        <bt:Image id="Icon.32x32" DefaultValue="https://localhost:3000/assets/icon-32.png"/>
        <bt:Image id="Icon.80x80" DefaultValue="https://localhost:3000/assets/icon-80.png"/>
      </bt:Images>
      <bt:Urls>
        <bt:Url id="Functions.Script.Url" DefaultValue="https://localhost:3000/public/functions.js"/>
        <bt:Url id="Functions.Metadata.Url" DefaultValue="https://localhost:3000/public/functions.json"/>
        <bt:Url id="GetStarted.LearnMoreUrl" DefaultValue="https://go.microsoft.com/fwlink/?LinkId=276812"/>
        <bt:Url id="Taskpane.Url" DefaultValue="https://localhost:3000/taskpane.html"/>
      </bt:Urls>
      <bt:ShortStrings>
        <bt:String id="Functions.Namespace" DefaultValue="FinTools_Azure"/>
        <bt:String id="GetStarted.Title" DefaultValue="Quantitative Finance SaaS"/>
        <bt:String id="CommandsGroup.Label" DefaultValue="Commands Group"/>
        <bt:String id="TaskpaneButton.Label" DefaultValue="Show Taskpane"/>
      </bt:ShortStrings>
      <bt:LongStrings>
        <bt:String id="GetStarted.Description" DefaultValue="FinTools_Azure has successfully loaded"/>
        <bt:String id="TaskpaneButton.Tooltip" DefaultValue="Click to Show a Taskpane"/>
      </bt:LongStrings>
</Resources>

Then update all of those links, and anywhere else in manifest.xml that refers to localhost

Collectives™ on Stack Overflow

Excel javascript custom functions deployement

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related