Run the CONTOSO.ADD function, with numbers 10 and 200 as input parameters, by typing the value =CONTOSO.ADD(10,200) in the cell and pressing enter. Notice that the autocomplete menu shows the list of all functions in the CONTOSO namespace. In Excel, go to any cell and enter =CONTOSO. Next, try out the ADD custom function by completing the following steps. You'll use the CONTOSO namespace to access the custom functions in Excel. manifest.xml file specifies that all custom functions belong to the CONTOSO namespace. The custom functions project that you created contains some prebuilt custom functions, defined within the. Select the file manifest.xml and choose Open, then choose Upload. and navigate to the root directory of the project that the Yeoman generator created. In Excel, choose the Insert tab and then choose Add-ins.Ĭhoose Manage My Add-ins and select Upload My Add-in.Ĭhoose Browse. In this workbook, complete the following steps to sideload your add-in. To use your custom functions add-in, open a new workbook in Excel on the web. When you run this command, the local web server will start.
To test your add-in in Excel on a browser, run the following command. When you run this command, the local web server will start and Excel will open with your add-in loaded. To test your add-in in Excel on Windows or Mac, run the following command.
