Fetching contributors…
Cannot retrieve contributors at this time
34 lines (27 sloc) 3.41 KB

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 to learn more.

  • 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: A member of the Worksheets collection. The Worksheets collection contains all the Worksheet objects 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 a object that sorting operations on Table objects.
  • RangeSort: Represents a object that sorting operations on Range objects.
  • Filter: Represents a fitler object that manages the filtering of a table's column.
  • Worksheet Protection: Represents the protection of a worksheet object.
  • Worksheet Function: Represents a container for Microsoft Excel worksheet functions that can be called through JavaScript.
  • NamedItem: Represents a defined name for a range of cells or a value. Names can be primitive-named objects, range object, etc.
  • Binding: An abstract class that represents a binding to a section of the workbook.
    • Binding Collection:A collection of all the Binding objects that are part of the workbook.
  • TrackedObject Collection: Allows add-ins to manage a range object reference across sync() batches.
  • Request Context: The RequestContext object facilitates requests to the Excel application.
Additional resources