Comments on: Run Your Own Custom Functions in Excel (JavaScript Add-in)/2017/12/01/excel-addin-custom-function/Professional Development, Data ScienceTue, 19 Dec 2023 23:05:43 +0000hourly1http://wordpress.com/By: agrawaldeepak/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-42528Tue, 19 Dec 2023 23:05:43 +0000/?p=6024#comment-42528In reply to Tsuyoshi Matsuzaki.

Thanks for your help, its working now. My SSL certificate was not valid.

Liked by 1 person

]]>
By: Tsuyoshi Matsuzaki/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-42527Tue, 19 Dec 2023 02:42:19 +0000/?p=6024#comment-42527In reply to Tsuyoshi Matsuzaki.

I share my manifest (.xml) which works for me.
I will continue to run the hosted website (https://tsmatsuz1215.azurewebsites.net/) in this manifest and please check if it works.

https://1drv.ms/u/s!AuopXnMb-AqcgeZQAZqj3O3o-fq4nA?e=y6sf8j

You can download all source code – index.html, mypage.html, myfunc.js, myfunc.json – by accessing with your browser.
I will delete this website one month later, and please download source code till then.

When you host your Azure web site by your own, please use the following web.config to expose JSON file.

https://stackoverflow.com/questions/48137750/azure-web-app-does-not-load-json-file

Like

]]>
By: agrawaldeepak/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-42524Sun, 17 Dec 2023 21:39:33 +0000/?p=6024#comment-42524In reply to Tsuyoshi Matsuzaki.

Thanks for your reply, I am trying to build simple excel custom functions add-in without using yeoman and not for Azure. I checked, the JSON file is exposed still the custom function is not appearing in Excel. Would it be possible for you to upload a zip file with complete project. Thank you very much.

Like

]]>
By: Tsuyoshi Matsuzaki/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-42523Fri, 15 Dec 2023 07:08:58 +0000/?p=6024#comment-42523In reply to agrawaldeepak.

Thank you for your feedback.
Make sure that myfunc.json is exposed in your web site. (By default, JSON file is not exposed in Azure web app. I have added this note in the post.)

P.S.
The reference for myfunc.js in mypage.html is not required and I also have removed this reference. (Sorry for my mistake.)
But this might not be the cause for your error.

Like

]]>
By: agrawaldeepak/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-42522Fri, 15 Dec 2023 01:07:41 +0000/?p=6024#comment-42522Hi There, after implementing this, I am getting “An unknown error has occurred while downloading this resource. Please re-load your add-in.” Please suggest

Like

]]>
By: Nazim/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-41966Sun, 07 May 2023 07:17:24 +0000/?p=6024#comment-41966How can I call API in the function as API when I call external API then it is giving me #BUSY!.
I want to return API response as string. Even I tried async – false (giving me – #VALUE!). but nothing worked

Like

]]>
By: Rick Sellers/2017/12/01/excel-addin-custom-function/comment-page-1/#comment-4107Tue, 10 Jul 2018 22:24:24 +0000/?p=6024#comment-4107whoa! sweet!

the reference to https://appsforoffice.edog.officeapps.live.com/lib/beta/hosted/office.js is critical, right? What’s in there?

Like

]]>