I have created Excel Web Addin project using VS 2019 and trying to incorporate Custom Functions into this project. Unfortunately all the documentation on MSDN refer to Yeoman generator so I am not sure either VS created project doesn't support custom functions OR I am missing something? I have added following factor under HOST
<AllFormFactors>
<ExtensionPoint xsi:type="CustomFunctions">
<Script>
<SourceLocation resid="CustomFunction.Script" />
</Script>
<Page>
<SourceLocation resid="CustomFunction.Page" />
</Page>
<Namespace resid="CustomFunction.Namespace" />
</ExtensionPoint>
</AllFormFactors>And all the URL point to the files which I created
<bt:Url id="CustomFunction.Script" DefaultValue="~remoteAppUrl/CustomFunctions/CustomFunction.js" />
<bt:Url id="CustomFunction.Page" DefaultValue="~remoteAppUrl/CustomFunctions/CustomFunction.html" />My CustomFunction.js file content looks like:
// The initialize function must be run each time a new page is loaded.
(function () {
Office.initialize = function (reason) {
// If you need to initialize something you can do so here.
};
/**
* Add two numbers
* @customfunction
* @param {number} first First number
* @param {number} second Second number
* @returns {number} The sum of the two numbers.
*/
function add2(first, second) {
return first + second;
}
CustomFunctions.associate("ADD2", add2);
})();<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8" />
<meta http-equiv="X-UA-Compatible" content="IE=Edge" />
<meta http-equiv="Expires" content="0" />
<title></title>
<script src="https://appsforoffice.microsoft.com/lib/1.1/hosted/custom-functions-runtime.js" type="text/javascript"></script>
</head>
<body>
</body>
</html>I can debug the project successfully and when I run it, Excel open but no add-in loaded into it. Can anyone point out the right direction please?
You don't have the JSON archive with the metadata:
You have to configure your metadata JSON manually :
Manually create JSON
You can create a new folder with HTML, JS, and JSON archives. Then, you point them in the manifest (page, script, and metadata).