Develop Excel JavaScript Add-In for Web, Windows & Mac - Microsoft Office Programming Tutorial

Learn how to develop Microsoft Excel JavaScript Add-In that works on Web, Windows & Mac. We'll be using NodeJS and VSCode and, of course, you'll need Excel to test it :)
Documentation used:
Build an Excel task pane add-in docs.microsoft...
Excel JavaScript API docs.microsoft...
#excel #development #addin

[@sandratoolan9598]

Despite being vry long ago - FK I appreciate it when its 4 mins 30 vs a 4 day affair. Thanks.

[@josericardo3015]

As usual, very well explained! Hope to watch more tutorials about excel addins. If possible, for web

[@moonwinks3987]

Thank you for the video. Can you please do a video on how to connect the task pane to a database and display results in the database?

[@Dawalhasa]

Thanks Bro You are far far more better than professional one.............

[@getitdonetube]

:)

[@anantbhat3640]

It really helped me a lot thanks a lot man

[@getitdonetube]

Good to hear

[@thermodynamik]

Thank you very much for this tutorial. The way and pace you explain it is great. Since you seem to know what you do; may I ask you a question? I need to build a PowerPoint AddIn that - beside other things - should display content (html, javascript) from our server on a PowerPoint slide. Do you know how to do this or can you give me a hint or the right keywords to find a solution? Thanks in advance!

[@iphoneandnick]

how do you go about deploying such an add-in?

[@junior75980]

I want to know it too hahahaha

[@iphoneandnick]

@@junior75980 best thing is to share the folder of the manifest file. Then go into your excel settings and go to my addins and add it. Theres documentation on this.

[@richstrang]

Deploy via the Microsoft Admin Centre, just a case of allocating an AD group to control scope then upload Manifest.

[@wonjinpark7502]

Thank you. I really love this!

[@sgrlwatcher4804]

Taskkane button not showing. please let me know what you can do?

[@atallpa]

Totally usefull i like very much i ll as my resource for a future. The main thing is that i dont believe it ill work in old excels! thank you!

[@johnpuopolo4413]

Thanks for this video - very useful. I, too, am on a Mac. Has anyone figured out how to make the debugger in VS Code work when developing an Excel add-in on the Mac? Thanks.

[@rayhan354]

how can I change the code from opening a new excel to open an existing excel file?

[@seanconnors3356]

Do you know if this can, end game level, retrieve data from one excel file to another in One Drive?

[@josemunozvargas]

Hi. What happend if I send this file to another person? Does he need to install node.js and all that staff? Is it posible to upload these scripts to a server and then connect it with excel in several computers with excel desktop? Maybe it is not yet posible. I do not know. I am thinking about macros made in VBA. You can send those files to everyone who uses excel desktop and macro works!!

[@thefamousdjx]

can you use other libraries in the javascript like puppetier?

[@getitdonetube]

You can use packages that work with front end javascript, but they shouldn't require node to run after build. So puppetier likely won't work.

[@vijaykumardevireddy8051]

Great video, had a doubt regarding alert function as this is not going to work do we have any alternate solution for error popups in add-ins?

[@getitdonetube]

You can use a modal or simply a div that you can make visible when needed using JavaScript.

[@vijaykumardevireddy8051]

@@getitdonetube thanks for the suggestion.

[@marsidev]

Nice video and nice add-in! There is possible to share an excel file + the html project together?

[@getitdonetube]

No. Add-in is application level.

[@praghatishm9366]

Is there any way to send events to QT Application from these add-ins?

[@getitdonetube]

What does "QT Application" mean?

[@glennbullock3778]

Any chance you remember how to download the version of Excel that supports OfficeWebAddinDeveloperExtras? I'd really like to be able to debug my Add-in. Thx.

[@getitdonetube]

Current version doesn't?

[@glennbullock3778]

@@getitdonetube Version 16.51. License: Microsoft 365 Subscription. I've loaded and reloaded that sucker a dozen times.

[@getitdonetube]

I think this may be connected to Mac OS version and updates they made rather than Office version.In docs it mentions High Sierra learn.microsoft.com/en-us/office/dev/add-ins/testing/debug-office-add-ins-on-ipad-and-mac

[@glennbullock3778]

@@getitdonetube Thanks brutha. I saw that. I'm on Big Sur. Later than High Sierra. You're kind for responding. If it get too taxing, I'll hit up support. (Ugh)

[@shinrafahell]

Hi, is it possible to embed this adding in our Excel file?

[@getitdonetube]

No.

[@thefamousdjx]

U can embed the content addin