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

Sdílet
Vložit
  • čas přidán 14. 05. 2021
  • 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.com/en-us/offi...
    Excel JavaScript API docs.microsoft.com/en-us/java...
    #excel #development #addin

Komentáře • 36

  • @josericardo3015
    @josericardo3015 Před 3 lety +2

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

  • @sandratoolan9598
    @sandratoolan9598 Před 11 dny

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

  • @wonjinpark7502
    @wonjinpark7502 Před 3 lety +1

    Thank you. I really love this!

  • @moonwinks3987
    @moonwinks3987 Před 2 lety +1

    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?

  • @atallpa
    @atallpa Před 2 lety

    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!

  • @thermodynamik
    @thermodynamik Před rokem

    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!

  • @anantbhat3640
    @anantbhat3640 Před 2 lety +2

    It really helped me a lot thanks a lot man

  • @johnpuopolo4413
    @johnpuopolo4413 Před rokem

    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.

  • @Dawalhasa
    @Dawalhasa Před 2 lety

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

  • @seanconnors3356
    @seanconnors3356 Před 2 lety

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

  • @rayhan354
    @rayhan354 Před rokem

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

  • @sgrlwatcher4804
    @sgrlwatcher4804 Před 2 lety +1

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

  • @josemunozvargas
    @josemunozvargas Před 2 lety

    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!!

  • @marsidev
    @marsidev Před 3 lety

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

  • @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
      @getitdonetube  Před rokem

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

    • @vijaykumardevireddy8051
      @vijaykumardevireddy8051 Před rokem

      @@getitdonetube thanks for the suggestion.

  • @praghatishm9366
    @praghatishm9366 Před 2 lety

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

  • @thefamousdjx
    @thefamousdjx Před 2 lety

    can you use other libraries in the javascript like puppetier?

    • @getitdonetube
      @getitdonetube  Před 2 lety +1

      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.

  • @iphoneandnick
    @iphoneandnick Před 3 lety +5

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

    • @junior75980
      @junior75980 Před 2 lety

      I want to know it too hahahaha

    • @iphoneandnick
      @iphoneandnick Před 2 lety

      @@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
      @richstrang Před 2 lety

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

  • @shinrafahell
    @shinrafahell Před 3 lety

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

  • @glennbullock3778
    @glennbullock3778 Před rokem

    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
      @getitdonetube  Před rokem +1

      Current version doesn't?

    • @glennbullock3778
      @glennbullock3778 Před rokem

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

    • @getitdonetube
      @getitdonetube  Před rokem

      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
      @glennbullock3778 Před rokem

      @@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)