Excel JavaScript API overview

An Excel add-in interacts with objects in Excel by using the JavaScript API for Office, which includes two JavaScript object models:

  • Excel JavaScript API: Introduced with Office 2016, the Excel JavaScript API provides strongly-typed objects that you can use to access worksheets, ranges, tables, charts, and more.

  • Common APIs: Introduced with Office 2013, the Common API can be used to access features such as UI, dialogs, and client settings that are common across multiple types of Office applications.

This section of the documentation focuses on the Excel JavaScript API, which you'll use to develop the majority of functionality in add-ins that target Excel on the web or Excel 2016 or later. For information about the Common API, see JavaScript API for Office.

Learn programming concepts

See the following articles for information about important programming concepts:

Learn about API capabilities

Use other articles in this section of the documentation to learn about working with events, charts, ranges, tables, worksheets, and more. Also in this section, you'll find guidance about Excel JavaScript API concepts such as coauthoring in Excel add-ins, data validation, error handling, and performance optimization. See the table of contents for the complete list of available articles.

For hands-on experience using the Excel JavaScript API to access objects in Excel, complete the Excel add-in tutorial.

For detailed information about the Excel JavaScript API object model, see the Excel JavaScript API reference documentation.

Try out code samples in Script Lab

Use Script Lab to get started quickly with a collection of built-in samples that show how to complete tasks with the API. You can run the samples in Script Lab to instantly see the result in the task pane or worksheet, examine the samples to learn how the API works, and even use samples to prototype your own add-in.

See also