Programmatically Creating Custom Functions in an Excel Add-in using JavaScript

Question

I'm in the process of "translating" a Google Sheets add-on to an Excel add-in. I have trouble finding if and how custom functions would be programmatically created using JavaScript in an Excel add-in (which btw is really simple for Google Sheets).

Is this possible? If so, could you provide a basic example?

Michael Saunders · Accepted Answer · 2017-11-06 21:28:50Z

2

JavaScript custom functions in Excel are now available in Developer Preview for anyone to try building as part of an add-in: https://aka.ms/customfunctions

-Michael (PM for add-ins)

answered Nov 6, 2017 at 21:28

Michael Saunders

2,6781 gold badge15 silver badges21 bronze badges

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

Comments

Jessevl · Accepted Answer · 2016-06-23 09:45:51Z

0

Not sure what you're after. In the new add-in model in Excel add-ins are basically web pages in a frame with a document object that you can manipulate and that refers to the worksheet. You can create any function provided the APIs available are sufficient.

answered Jun 23, 2016 at 9:45

Jessevl

9191 gold badge6 silver badges4 bronze badges

1 Comment

Alexandre Raffin Over a year ago

Alright, that's probably a lack of research on my part then. For Google Sheets add-ons, you can just call your functions in cells by putting an '=' sign before like =functionName(arg1;arg2). I was wondering if there was the same mechanism that would allow the functions to be automatically called or if I have to watch the cells and parse the function name and the arguments if the cell started with an '=' sign.

Collectives™ on Stack Overflow

Programmatically Creating Custom Functions in an Excel Add-in using JavaScript

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related