4

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
  • 2,662
  • 1
  • 12
  • 21
SoftTimur
  • 5,630
  • 38
  • 140
  • 292

1 Answers1

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

Michael Saunders
  • 2,662
  • 1
  • 12
  • 21
  • 4
    Any news regarding the subject of creating user defined functions ? – cosmaioan Mar 26 '17 at 20:29
  • 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. – Michael Saunders Mar 26 '17 at 20:57
  • @MichaelSaunders It seems that there is some update? – SoftTimur Oct 20 '17 at 04:25
  • 2
    Update: it's live in Developer Preview! Please try it and send your feedback: https://aka.ms/customfunctions – Michael Saunders Nov 06 '17 at 21:24
  • 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]) – Wolfram Kriesing Feb 10 '18 at 20:50
  • I just got an email which told me "Custom functions are officially in Preview! Try them! more info in https://aka.ms/customfunctions". But on that page `Deployment via the Office 365 Admin Portal and AppSource are not yet enabled.` is still there. So today developers still can NOT submit add-ins with custom functions? – SoftTimur Nov 07 '18 at 00:39