Excel has a very rich API surface. In this video we'll look at the Excel-specific API.
- [Instructor] In this chapter we're going to look at Excel.…In some ways this offers the richest possibilities…for extension because we can use it to drive…some very sophisticated data driven solutions…and powerful graphics.…In addition we have the option to create custom functions…which we'll look at later.…If we go to dev.office.com and find our way…to the getting started or the quick start for Excel…and I'm going to go to build your first Excel add-in…and it actually gives us a number of choices.…
Do I want to use Angular, jQuery, React, or Vue.…It's quite interesting, if I choose React…you can see it's sending me down the path…of using npm to install the generator and so on.…So if I go down this path I'm using…the modern web development tool chain.…Alternatively, if we back up and look at jQuery,…you'll see that it's recommending Visual Studio.…
There's another tab here that says…for going down the npm route,…but we can use Visual Studio and create the add-in that way.…And that's the way the tutorial,…or one of the options for setting up this tutorial.…
Author
Released
9/13/2018- How Office extensions work
- Using the Office.js libraries
- Working with ScriptLab
- Creating an add-in with Visual Studio
- Working with manifests and commands
- Deploying and debugging add-ins
- Developing new add-in controls
- Converting from JavaScript to TypeScript
- Working with Yeoman, Angular, and React
- Sideloading add-ins to different locations
- Guidelines for designing add-ins
- Using Office application APIs
- Publishing and licensing add-ins
Skill Level Intermediate
Duration
Views
Related Courses
-
Office 365: Administration (2017)
with David Elfassy2h 49m Intermediate -
Office 365: Provision Office 365
with Brian Culp1h 35m Intermediate
-
Introduction
-
What are Office add-ins?2m 34s
-
1. Getting Started
-
Office extensions2m 19s
-
How Office extensions work2m 23s
-
The Office.js libraries2m 3s
-
Introduction to ScriptLab4m 58s
-
-
2. Building Add-Ins with Visual Studio
-
Add-in manifests3m 55s
-
Add-in web projects4m 17s
-
Deploying and debugging3m 54s
-
Add-in commands3m 30s
-
Create a new control5m 35s
-
3. Using Other Libraries and Tooling with Add-Ins
-
An example in Angular3m 42s
-
The React framework2m 14s
-
An example in React6m 24s
-
Office UI Fabric3m 45s
-
Design guidelines2m 58s
-
Design toolkit4m 26s
-
Consuming external services4m 27s
-
4. Add-Ins for Word, PowerPoint, and OneNote
-
The Word API6m 6s
-
Explore glossary add-in code6m 36s
-
Tour the glossary add-in5m 43s
-
OneNote10m 28s
-
PowerPoint3m 33s
-
-
5. Add-Ins for Excel
-
The Excel API8m 10s
-
A built-in sample in Excel7m 43s
-
Repurposing7m 27s
-
Excel custom functions5m 39s
-
-
6. Add-Ins for Outlook
-
Sample Outlook add-in9m 49s
-
Outlook contextual add-ins1m 53s
-
Actionable messages3m 49s
-
7. Distributing Your Add-In
-
Add-in distribution options1m 59s
-
Publishing to the Store7m 54s
-
Licensing1m 56s
-
Centralized deployment2m 6s
-
Updating your add-in1m 5s
-
-
Conclusion
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.
CancelTake notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.
Share this video
Embed this video
Video: The Excel API