CODEWITHSUNDEEP
ms-officeoffice-jscustom-functions-excel
SoftTimur
SoftTimur

Reputation: 5490

User Defined Function by JavaScript API for Excel

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?

Upvotes: 4

Views: 1520

Answers (1)

Michael Saunders
Michael Saunders

Reputation: 2668

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

Upvotes: 5

Related Questions