How to Build Custom Excel Functions in the Excel JavaScript API

Поделиться
HTML-код
  • Опубликовано: 6 сен 2024

Комментарии • 15

  • @Shivaaayy
    @Shivaaayy 4 года назад +1

    Your videos are awesome
    I created a taskpan add-in using yo office
    I want to publish my add-in
    Can you please make a video on taskpan add-in publishing options demo 🙏🙏

    • @SigmaCoding
      @SigmaCoding  4 года назад +2

      That will be part of the series don't worry. :)

    • @Shivaaayy
      @Shivaaayy 4 года назад

      Did you include creation of line chart in your series too?

  • @uangyy
    @uangyy 4 года назад

    Could you please tell me how to configure the shared javascript runtime in script lab? Because I want to call Excel APIs in my customfunction.

  • @fcernst
    @fcernst 4 года назад

    I always have "Enable iterative calculation" turned on in Excel. I have spreadsheets that have cells that need to iterate between each other to come to a solution. I have a user-defined function in VBA that works when used in this iterative scenario, however the same function written in Java Script with Script Lab gives the #CALC error... It won't iterate. Have you seen this behavior? Is there anyway to fix this? Great video, and hope this question helps others too.

  • @JfrArias
    @JfrArias 4 года назад

    Wonderful 👌, Thanks

  • @tuyoexcelypowerbi
    @tuyoexcelypowerbi 4 года назад

    Thanks!

    • @SigmaCoding
      @SigmaCoding  4 года назад +1

      I had a feeling you would like this one, I noticed your channel covers the JavaScript API. Finally, there is more than a few channels that cover the topic!

    • @tuyoexcelypowerbi
      @tuyoexcelypowerbi 4 года назад +1

      @@SigmaCoding Yes, I love all videos that you publish but specially the ones related with Excel JavaScript API. I think this will be the future for Excel. I played weeks ago with custom functions through Script Lab but I did not try with Visual Studio yet. Another thing interesting is to play with the Ribbon and add new menus and icons with the manifest file... this is incredible!!! Also I am playing with the task pane designing it with HTML and CSS. Many things to learn!! By the way, I only know your channel that covers this topic apart of Microsoft Developers Channel

    • @SigmaCoding
      @SigmaCoding  4 года назад +1

      @@tuyoexcelypowerbi Yeah, it's definitely exciting to see some of the new features we have access to. I'm hoping that as time goes on, it just becomes easier to found examples and such. You'll have to let me know how the whole ribbon modification goes. It would be interesting to see how much control we get over that process.
      Excellent channel, by the way, even though I don't speak Spanish, it's neat to see the topics you cover.

    • @tuyoexcelypowerbi
      @tuyoexcelypowerbi 4 года назад

      @@SigmaCoding You can activate English captions from RUclips, check the videos set up when watching, I am not confident to record videos in english :--)
      Two days ago I watched a famous Excel MVP covering the Office Scripts tool, after this the Office JavaScript API will be more popular, more people interested in learning, more examples...
      I have a course published about this in VIMEO, if you wanna watch how I work with the Ribbon through the manifest file just go here: tuyoyexcel.com/ Videos are in Spanish too but you will understand the process without problem. Just e-mail me to info@tuyoyexcel.com and I will provide a free token. I am updating the course when I have time. Another thing interesting you can watch is how a publish an addin in a local server via IIS.

  • @TheMrRowden
    @TheMrRowden 4 года назад

    I love you

  • @tonyhunter8483
    @tonyhunter8483 4 года назад

    Can you do a video on how the shared runtime work? I have not been able to get that to work... Here is my question on stackoverflow.
    stackoverflow.com/questions/62347335/excel-js-add-in-shared-runtime-not-working