Excel JavaScript add-in APIs

on YouTube ↗06m

" summary

Excel 2016 adds hundreds of new APIs that manipulate worksheets, ranges, tables, charts and formatting; the demo builds an inventory tracker that creates a table, sets a total row to a MIN formula, scans rows to find and highlight the lowest item, adds a worksheet and a column chart, and all requests run with batching and promises via context.sync. A host-check utility API returns a boolean for Excel API 1.1 and the APIs run on Excel 2016 for Windows and Excel Online.

AI-written summary · about

" chapters (5)

1. 0:00Introduction and overview
2. 2:05Building an inventory add-in
3. 4:24Creating charts and sheets
4. 5:18Demo results
5. 5:36Resources and support

" related talks

• 24mJavaScript, spreadsheets and APITomasz Stachewicz · ConfrontJS 2022
• 01h 16mExploring Google APIs with Python & JavaScriptWesley J. Chun · Silicon Valley Code Camp 2018
• 22mBuild with Word as a platform: Word JavaScript APIs and key user scenariosYun Wang · Microsoft Build 2023
• 44mWeb APIs You Should Be Using in 2026: Unlocking Next-Level Web ExperiencesNhlanhla Lucky Nkosi · NDC Copenhagen 2026
• 22mExtending the Web - explore new UI surfaces with WebExtensionsOliver Dunk · Wey Wey Web 2024
• 58mA Look At Modern Web APIs You Might Not KnowJulian Burr · NDC Melbourne 2025
• 50mMost useful browser APIsPavol Hejný · DevConf.CZ 2020
• 27mHow we make Web Apps lightning fast at MicrosoftSean Thomas Larkin · JSCamp Barcelona 2019