Define a custom function in Office.js add-in with React

Question

I'm quite new working with the Office.js API. I created a React add-in project and I'm now trying to add a custom function which can simply add two cells just like the examples at create custom function in Excel. In this guide it says you have to create the add-in project as Excel Custom Functions

So my doubt is how can I create a custom function if the add-in project I created is React type instead of Excel Custom Functions

Henry Ecker · Accepted Answer · 2022-08-28 03:10:47Z

1

Yes, you definitely can. Currently, it means merging existing templates (react template and the one at custom functions template which are both available via yo office) and as feature moves out of preview we will have explicit guidance on https://aka.ms/customfunctions.

For now there are 4 things:

modify your manifest to add the customfunctions under the "allformfactors" element
add an customfunctions.html file which can load your JavaScript
add the customfunctions.json file
add a reference to your JavaScript

edited Aug 28, 2022 at 3:10

Henry Ecker♦

35.8k19 gold badges48 silver badges67 bronze badges

answered Jan 17, 2019 at 5:19

Keyur Patel - MSFT

8146 silver badges7 bronze badges

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

2 Comments

Romina Over a year ago

Is there any example on how to get that merge done? I tried to do the 4 stepts you mention but couldn't reach the CustomFunction object in order to do the associate.

Antoine Dahan Over a year ago

@Keyur Patel - MSFT - Could we get an updated answer to this as the structure of Excel add-in projects have changes since this was posted (there is no longer a customfunctions.json file, ect.). There is still no yeoman office template for creating an Excel Custom Functions project with a React Taskpane. Attempts I have made to go from a React Taskpane project to adding Custom functions and vice versa (from a Custom Functions project to adding a React Taskpane) have both failed.

Collectives™ on Stack Overflow

Define a custom function in Office.js add-in with React

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related