Microsoft Office clients enable developers to create add-ins that extend Microsoft Excel with custom functionality. Through a JavaScript API, developers can manipulate the content in an Excel workbook from an app running in the task pane.
In this module, you'll learn how to build an Excel add-in that inserts (and replaces) text ranges, tables, charts, and dialogs.
This module is also published as a Microsoft Learn module: Build Office Add-ins for Excel.
The lab for this module is available in multiple units within the associated Microsoft Learn module. Use the following links to jump to the specific unit. Each Microsoft Learn unit represents a different lab exercise & demo in the presentation.
-
Exercise - Work with tables and charts in Excel Add-ins
In this exercise, you'll learn how to work with tables and charts using the Office.js Excel JavaScript API. After creating a table, you'll learn how you can apply sorting and filtering actions on the data within the table. You'll also learn how to create and edit charts in the workbook using from your custom Excel add-in.
-
Exercise - Work with worksheets and add-in commands
In this exercise, you'll learn how to freeze the header row of the table that you previously created, so that it remains visible even as the user scrolls down the worksheet. You'll also learn how to toggle worksheet protection on and off.
-
Exercise - Work with dialogs in Excel
In this exercise, you'll open a dialog in your add-in, pass a message from the dialog process to the task pane process, and close the dialog.
- Work with tables and charts in Excel Add-ins
- Work with worksheets and add-in commands
- Work with dialogs in Excel
This module has been recorded and is available in the Office Development YouTube channel: Building Office Add-ins for Excel
| Roles | Author(s) |
|---|---|
| Lab Manuals / Slides | Andrew Connell (Microsoft MVP, Voitanos) @andrewconnell |
| Version | Date | Comments |
|---|---|---|
| 1.21 | May 5, 2023 | 2023Q4 content refresh |
| 1.20 | December 5, 2022 | 2023Q2 content refresh |
| 1.19 | September 5, 2022 | 2023Q1 content refresh |
| 1.18 | May 2, 2022 | 2022Q4 content refresh |
| 1.17 | February 22, 2022 | 2022Q3 content refresh |
| 1.16 | December 7, 2021 | 2022Q2 content refresh |
| 1.15 | September 6, 2021 | 2022Q1 content refresh |
| 1.14 | June 17, 2021 | 2021Q4 content refresh |
| 1.13 | February 25, 2021 | 2021Q3 content refresh |
| 1.12 | November 25, 2020 | 2021Q2 content refresh |
| 1.11 | September 1, 2020 | 2021Q1 content refresh |
| 1.10 | May 1, 2020 | 2020Q4 content refresh |
| 1.9 | April 6, 2020 | FY2020Q3 content refresh & port module to MS Learn |
| 1.8 | March 5, 2020 | 2020Q3 content refresh |
| 1.7 | Dec 9, 2019 | 2020Q2 content refresh |
| 1.6 | Sept 7, 2019 | 2020Q1 content refresh |
| 1.5 | June 7, 2019 | 2019Q4 content refresh |
| 1.4 | Mar 1, 2019 | 2019Q3 content refresh |
| 1.3 | Nov 23, 2018 | 2019Q2 content refresh |
| 1.2 | Sept 14, 2018 | 2019Q1 content refresh |
| 1.1 | June 28, 2018 | Added screencast |
| 1.0 | June 8, 2018 | Initial release |
THIS CODE IS PROVIDED AS IS WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING ANY IMPLIED WARRANTIES OF FITNESS FOR A PARTICULAR PURPOSE, MERCHANTABILITY, OR NON-INFRINGEMENT.