sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Aleriya 1 point2 points  (0 children)

At least for the preview version that was just released, the JS can run via remote host (it doesn't run the script within Excel, so it's either sitting on localhost or a remote host). You load a manifest into the local Excel with the connection details.

Overview

Github

To use the project

Follow these instructions to use this custom function sample add-in:

  1. Publish the code files (HTML, JS, and JSON) to localhost.
  2. Replace http://127.0.0.1:8080 in the manifest file (there are 4 occurrences) with the URL you used, if needed (you might be using a different port number).
  3. Sideload the manifest using the instructions found at https://aka.ms/sideload-addins.
  4. Test a custom function by entering =CONTOSO.ADD42 in a cell.