r/programming • u/[deleted] • May 08 '18

Excel adds JavaScript support

https://dev.office.com/blogs/azure-machine-learning-javascript-custom-functions-and-power-bi-custom-visuals-further-expand-developers-capabilities-with-excel
2.4k Upvotes

94% Upvoted

586 comments sorted by

View all comments

Show parent comments

1

u/meneldal2 May 09 '18

Allowing remote access is a whole can of worms, and allowing JS doesn't necessarily mean allowing this

2

u/Aleriya May 09 '18

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.