Introduction to the Office JavaScript API & Script Lab

To expand Office customization beyond the desktop application, Microsoft has developed a new JavaScript API that will allow us to customize Office to Office Online and even the Office applications found on Macs and iPads. In this video, we begin our discussion of the Office API and explore a new Office add-in called Script Lab that will allow us to experiment with our development directly in our Office applications.

Video Resources:
--------------------------------------------------
Resource: GitHub File

Resources:
--------------------------------------------------

Support Sigma Coding:
--------------------------------------------------

Related Topics:
--------------------------------------------------
Title: Using Object Methods & Properties in the Office JavaScript API

Title: Office JavaScript API: Asynchronous & Synchronous Programming

Title: Introduction to the Office JavaScript API & Script Lab

**Amazon Associates Disclosure:
--------------------------------------------------

Tags:
--------------------------------------------------
#JavaScriptAPI #MicrosoftOffice #ScriptLab

[tuyoexcelypowerbi]

A full course about all of this is needed!!! Even if it´s under subscription!!!
Thanks for your tutorials!!!!

[mattd]

Question, I have saved off HTML files containing Bokeh (python library) outputs, essentially interactive plots in html/css that are backed by js to provide interactive functionality. Would there a means, using this JavaScript API, to develop some sort of content add-in to display these local HTML files in Powerpoint? I've attempted to explore the Web Viewer Add-In but it does not work well, in fact I couldn't get it to work at all.

[wisjnujudho]

Is it possible to replace excel completely by coding in typescript? I'm thinking something like web app to calculate and automate everything vlookup or index match from different database (bank, AR, AP, sales, purchase). I lack of dictionary what to look into google. Since i don't have any programming background so i kind of kicking around the bush.

[ericthehalfmexican]

Outstanding introduction! Just what I needed to get started.

[bluefish]

great video; however, as with any software demo, there is only one thing that can go wrong...it doesn't work. the demo didn't work as intended, nor did my install of Script Lab.

i received the error message, "Script Lab no longer supports the IE11 browser (the latest) or embedded browser control. Please upgrade to a supported version of MS 365 or open office on the web in a supported browser." oh well...roadblocks seem to be a constant issue, regardless of software used.

[mathiasdreke]

Does the JS API replace VBA? >> Will it be possible to create documents having JS macros?

[musthagmohamed]

The video is awesome and helpful. Please let me know how to compile distribute the "Script Lab" office add-in code to my family and friends. Thank you in advance.

[tamalbose]

I need to get Tag importance (eg Low importance or High Importance of email) by API for outlook mail (like using Office.Context.Mailbox etc), please give me solution

[gthaker]

I am trying to add the scritlab addin to Office 2013 (MS Word and Excel are what I am interested in.) I can't seem to add this. Should Office 2013 (Word and Excel) work w/ this addin? It seems to say 2013 is supported but I can't get there. Anyone has success w/ office 2013?

[shaistabaig]

Can we add word addins project in angular project, if yes please explain the procedure.

[yuting]

I just discovered this today still trying with python with power bi but well for some setting issue hasn’t got in there yet much but I’m more familiar with this

[secretagentx-]

So I can only use javascript to edit word documents from within word? I can't, for example, create a word file in node and add text and images to it, straight from a node server?

[simonzcroft]

looks great, though many more steps to access the API compared with the VBA object model.
Will this be THE way to do office scripting in the future - Sounds like its now an official MS product?

[phanivasabattula]

Just have a quick question. Are these API's can be used to generate a professional word document from a JavaScriptbased web application?

[duxingsky]

The Script Lab loads too lowly in my Excel on Win7.（I'm from China）it prevents me from learning it efficiently.

[FelipeGualberto]

What an amazing fps! Which tool did you use to record the video?

[this-is-bioman]

Yeah, it's so great that you still cannot print a Word document or a single Excel worksheet or export them as PDF :-\ I don't get it how such basic functionality is missing the entire time. It should have been added in the version 0.0.0.0.0.0.0.1

[TroenderTass]

Thanks, spent 30 mins watching something that was a 15 minutes read on the docs.

[sledziu]

maybe you should create doscord server