CODEWITHSUNDEEP
office-jsoffice-2016custom-functions-excel
shyam_
shyam_

Reputation: 2470

whats the alternative to user defined functions in excel online office.js javascript lib

I am trying to develop the office excel add-in, similar to one i had for office 2013. in that i was using user defined function created using "VBA" and could fetch the data in the cells.

The advantage i had was 1. if i close my excel file and open it again, i could refresh the function and it would fetch the latest data.

i want to achieve something similar to that,

let me know how to achieve that using office js apis, I know that user defined functions are not supported in excel online

Upvotes: 2

Views: 2305

Answers (2)

Michael Saunders
Michael Saunders

Reputation: 2668

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

-Michael, PM for add-ins

Upvotes: 1

James Webster
James Webster

Reputation: 4104

The community has requested that Microsoft consider implementing this via the Excel and Office Developer Platform UserVoice pages;

https://officespdev.uservoice.com/forums/224641-general/suggestions/6936956-add-user-defined-function-support-to-the-apps-for

https://excel.uservoice.com/forums/274580-excel-online/suggestions/10243059-support-udf-user-defined-function-in-excel-online

One of these appears to be 'started', so hopefully we will see this feature in the Office Javascript API soon!

Upvotes: 1

Related Questions