User Defined Function by JavaScript API for Excel

Question

I have a library of functions written in JavaScript, for example myfactorial(n) can caculate the factorial of n in my way.

I would hope to develop an add-in by JavaScript API for Excel, such that once a user loads the add-in, they could use the embedded functions, e.g., write in a formula: =myfactorial(A2) or =callfunction("myfactorial", A2). In short, it is about supporting User Defined Functions by JavaScript API for Excel, I guess they are asking the same thing here.

So, does any know how is the progress? Otherwise, is there some workaround that we could do?

Michael Saunders · Accepted Answer · 2017-11-06 21:23:24Z

5

Thanks for this question! User-defined functions are a central part of Excel customization today. We're working on a solution that will bring those capabilities across all our modern Excel platforms. We're still figuring out the design, so unfortunately I don't have a timeline or details to share right now. I'll give an update in a few months.

-Michael, PM for Office add-ins

Update 11/6/17: JavaScript custom functions in Excel are now available in Developer Preview for anyone to try: https://aka.ms/customfunctions

edited Nov 6, 2017 at 21:23

answered Nov 21, 2016 at 18:29

Michael Saunders

2,6781 gold badge15 silver badges21 bronze badges

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

6 Comments

cosmaioan Over a year ago

Any news regarding the subject of creating user defined functions ?

Michael Saunders Over a year ago

We've continued our work in this area, and it's still a priority for our team. We're looking forward to sharing more but right now I don't have announcements about the feature or release dates.

SoftTimur Over a year ago

@MichaelSaunders It seems that there is some update?

Michael Saunders Over a year ago

Update: it's live in Developer Preview! Please try it and send your feedback: aka.ms/customfunctions

Wolfram Kriesing Over a year ago

is this also available for Excel Online? (I could not find the docs explicitly stating that [I am still trying to learn to read the docs, but I am not so good at it])

|

Collectives™ on Stack Overflow

User Defined Function by JavaScript API for Excel

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related