Office Add-ins platform overview
Subscribe Now!
New videos every Weekend!
Like what I do? Donate
Did I help you? Did one of my tutorials save you sometime?
You can say thank you by buying me a cup of coffee, I go through a lot of it.
Help keep Greater Good resources free for everyone. Please donate today.
Download project or source code from below link(s)
Hey, guys welcome back to my channel, I'm Lung Pamai, and in this new series, I'll introduce you to Office Add-ins platform. For demonstration purpose, we'll create a panel or task pane for Excel which will run across platforms.
In nutshell, Office Add-ins can do almost anything a webpage can do inside a browser, so, you extend your app functionalities by using familiar web technologies such as HTML, CSS, and JavaScript. The best thing is that it can run in Office across multiple platforms, including Windows, Mac, iPad, and in a browser. This is because it doesn't involve code that runs on the user's device or in the Office client. Having said that, I do believe that VBA will be around for a long time and still be the king in Client-Side for office app automation. VBA's new features documentation was last updated this year on Jan 22 for Office 2019.
One thing to point out is that - VBA developers have huge leverage because you already know the object hierarchy, properties and methods which you'll be accessing using Excel JavaScript API.
If you're new to Visual Studio, I will leave a link where you can download Visual Studio IDE. I'm using Visual Studio Community Version for Windows but it is also available for Mac if you are Mac User. Community Version is free, you can install it by simply following the instructions on your screen but if you have any specific question please comment below. If you do not find the tools/templates you need while creating the project, you can install more tools and features at any time.
https://docs.microsoft.com/en-us/office/dev/add-ins/overview/office-add-ins
https://docs.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=visualstudio
https://docs.microsoft.com/en-us/office/dev/add-ins/excel/
Visual Studio: Best-in-class tools for any developer
https://visualstudio.Not finding the templates for Web Add-in? Install 'Office/SharePoint development' from 'Get Tools and Features...' and restart VS.
If you've previously installed Visual Studio 2019, use the Visual Studio Installer to ensure that the Office/SharePoint development workload is installed.
If you don't already have Office, you can join the Office 365 Developer Program to get a free, 90-day renewable Office 365 subscription to use during development.
More resources will be added with more videos/tutorials.
To Support - Subscribe | Like | Share | Donate: https://www.paypal.me/lpamaiQuestions/feedback - comment or vbaa2z.team@gmail.com
Exception Unhandled Error. Ensure your internet is on.
Additional Reference Materials / Links.
https://www.w3schools.com/tags/att_input_checked.asphttps://www.daoudisamir.com/references/vs_ebooks/html5_css3.pdf
https://developer.mozilla.org/en-US/docs/Web/JavaScript/Guide/Control_flow_and_error_handling
https://htmlcheatsheet.com/js/
https://developer.mozilla.org/en-US/docs/Web/HTML/Element/input/number
https://developer.microsoft.com/en-us/fabric-js/components/checkbox/checkbox
https://docs.microsoft.com/en-us/office/dev/add-ins/quickstarts/excel-quickstart-jquery?tabs=visualstudio
No comments:
Post a Comment
Note: only a member of this blog may post a comment.