Introduction to the Office JavaScript API & Script Lab
Vložit
- čas přidán 25. 07. 2024
- 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
Link: github.com/areed1192/sigma_co...
Resources:
--------------------------------------------------
Facebook Page: / codingsigma
Facebook Group: / sigmacoding
GitHub Sigma Coding: github.com/areed1192/sigma_co...
Support Sigma Coding:
--------------------------------------------------
Patreon: / sigmacoding
Amazon Associates: amzn.to/3bsTI5P **
Related Topics:
--------------------------------------------------
Title: Using Object Methods & Properties in the Office JavaScript API
Link: • Using Object Methods &...
Title: Office JavaScript API: Asynchronous & Synchronous Programming
Link: • Office JavaScript API:...
Title: Introduction to the Office JavaScript API & Script Lab
Link: • Introduction to the Of...
**Amazon Associates Disclosure:
--------------------------------------------------
I am a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for sites to earn advertising fees by advertising and linking to Amazon.com. One of the ways I support the channel is by using Amazon Associates to earn fees on purchases you make. That means when you use the link above, it will track any purchases made from that link and give a small portion of it to the Sigma Coding. I love this approach because it allows you to do what you're already doing (shopping) but also helps support the channels you care about. Also, it makes it where I can invest that revenue to help improve and grow the channel.
Tags:
--------------------------------------------------
#JavaScriptAPI #MicrosoftOffice #ScriptLab
A full course about all of this is needed!!! Even if it´s under subscription!!!
Thanks for your tutorials!!!!
Yeah I found that this topic is not covered on CZcams, so I thought it would be a good topic to cover. More videos will be coming out soon that cover some of the fundamental concepts of TypeScript so we understand the differences if we are jumping over from VBA.
Outstanding introduction! Just what I needed to get started.
That's what I needed
The tutorial is excellent thank
Very helpful. Thank you.
Glad it was helpful!
Yeeeeessss, this is awesome.
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.
Can we add word addins project in angular project, if yes please explain the procedure.
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.
Well, it depends on what you mean by replacing it. I mean if we are talking about the specific functions, there is no reason you couldn't, but you would have to code all those functions. However, you would just have to work with arrays of data instead of having a user interface.
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.
I would say anything related to PowerPoint is probably a no go at this point as the API is barely functional. However, you could look into content add-ins that allow you to embed objects in Office Apps.
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.
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?
What the future looks like, it's kind of hard to tell but you can guarantee that the Office API will be part of it in some fashion. I'm not sure if you heard but recently Microsoft announced that they will have a script recording tool that generates source code for the JavaScript API.
That was always the biggest setback for the Office API is that there was no "macro recorder" equivalent. With a new tool that will ultimately mimic the VBA macro recorder, there is nothing, at least from a very simple perspective, stopping us from moving over to the new office API.
The only other thing missing is building in the rest of the object model. Right now, certain elements are missing. For example, you can't do anything in PowerPoint except insert an image. Until that is fixed we can't call the Office API a replacement. Additionally, I will be curious to see how they restrict certain parts of the API in the Online version of Office compared to the Desktop Version.
For example, data connections are extremely limited in the browser version so we can't use it from the Office API.
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?
I'm a little confused. Are you asking if the API can be used within Node?
@@SigmaCoding Yes essentially have a node server or even just a plain js file and create a word document from there, as well as modify it. Kind of like a puppeteer for Word.
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?
What an amazing fps! Which tool did you use to record the video?
I have an Alienware laptop with a Nividia graphics card so I get access to an app called the `GeForce Experience` and that application allows for screen recording.
@@SigmaCoding Cool, I was also able to do it. Thanks!
@@SigmaCoding hey 👋. I would like to format individual characters inside an Excel cell using Office-JS. Is that passible ?
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
Just have a quick question. Are these API's can be used to generate a professional word document from a JavaScriptbased web application?
That's a good question, my understanding that this API is used more for interacting with the Office Application. I don't know if you could generate a Word Document if Office isn't open.
You mean, the web application can interact with word document?
@@phanivasabattula7460 You can, but if you want to make it available to everyone in your organisation you either have to share your snippets and get individuals to import them themselves (challenging for some users), or otherwise publish an addon to somewhere only a suitably authorised developer has access to. Neither are really adequate replacements for what we can currently do with VBA, where its built into the application if you own it.
Does the JS API replace VBA? >> Will it be possible to create documents having JS macros?
Well, that's the ultimate goal, but we are still far away from that. The JS API still lacks numerous parts of the VBA object model. I have started to get a little worried because I've noticed that they aren't updating the API as frequently as they once did. I'm not sure what their goal is with the API but there is still a lot of work to do with it. For example, PowerPoint has almost no functionality in the API so you can't rely on API for automation scripts.
@@SigmaCoding is it possible to create buttons that run javascript in the file? something like here www.lystech.com/webhelp/Content/calculate-in-pdf/
The Script Lab loads too lowly in my Excel on Win7.（I'm from China）it prevents me from learning it efficiently.
Yeah I don't think Script Lab was made for Windows 7, unfortunately the only thing you could do is upgrade to Windows 10.
@@SigmaCoding thanks for your reply. It's a good news for me . I have focus on this new tools for almost one year. but have no deep study because of its loading speed. I will have a try on Win 10. Thank you again !!!
14:00
yep....please get to the point quickly
Thanks, spent 30 mins watching something that was a 15 minutes read on the docs.
maybe you should create doscord server
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
Don't even get me started, PowerPoint is even worst. You still can't do anything with it, and it's been out for a few years now.