Excel JavaScript API overview

You can use the Excel JavaScript API to build add-ins for Excel 2016 or later. The following list shows the high-level Excel objects that are available in the API. Each object page link contains a description of the properties, events, and methods that are available on the object. Explore the links from the menu to learn more.

Some of the core Excel objects are listed below for convenience:

  • Workbook: The top-level object that contains related workbook objects such as worksheets, tables, ranges, etc. It also can be used to list related references.

  • Worksheet: Represents a worksheet in a workbook.

  • Range: Represents a cell, a row, a column, or a selection of cells containing one or more contiguous blocks of cells.

    • ConditionalFormat: An object defining a rule and a format applied to the range when the rule's condition is met.
    • DataValidation: An object that restricts user input to a range based on a variety of criteria.
    • RangeSort: Represents a object that manages sorting operations on a range.
  • Table: Represents a collection of organized cells designed to make management of the data easy.

  • Chart: Represents a chart object in a worksheet, which is a visual representation of underlying data.

  • PivotTable: Represents an Excel PivotTable, which is a hierarchical grouping and presentation of data.

  • Filter: Represents an object that manages the filtering of a table's column.

  • NamedItem: Represents a defined name for a range of cells or a value.

  • Binding: An abstract class that represents a binding to a section of the workbook.

Excel JavaScript API requirement sets

Requirement sets are named groups of API members. Office Add-ins use requirement sets specified in the manifest or use a runtime check to determine whether an Office host supports APIs that an add-in needs. For detailed information about Excel JavaScript API requirement sets, see the Excel JavaScript API requirement sets article.

Excel JavaScript API reference

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

See also