Excel JavaScript API reference

You can use the Excel JavaScript API to build add-ins for Excel 2016. 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, relationships, and methods that are available on the object. Explore the links from the menu to learn more.

Note that the relationships section within the document lists the properties that are used to navigate from the main object to another related object. These are non-scalar objects that themselves may contain other properties, methods and relationships.

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.

  • 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.

  • TableSort: Represents an object that manages sorting operations on Table objects.

  • RangeSort: Represents a object that manages sorting operations on Range objects.

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

  • WorksheetProtection: Represents the protection of a Worksheet object.

  • 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.