excel package

Represents the Excel application that manages the workbook.

[ API set: ExcelApi 1.1 ]

Represents the AutoFilter object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.

[ API set: ExcelApi 1.9 ]

Represents an Office.js binding that is defined in the workbook.

[ API set: ExcelApi 1.1 ]

Represents the collection of all the binding objects that are part of the workbook.

[ API set: ExcelApi 1.1 ]

Represents a cell value conditional format.

[ API set: ExcelApi 1.6 ]

Represents a chart object in a workbook. To learn more about the Chart object model, see Work with charts using the Excel JavaScript API.

[ API set: ExcelApi 1.1 ]

Encapsulates the format properties for the overall chart area.

[ API set: ExcelApi 1.1 ]

Represents the chart axes.

[ API set: ExcelApi 1.1 ]

Represents a single axis in a chart.

[ API set: ExcelApi 1.1 ]

Encapsulates the format properties for the chart axis.

[ API set: ExcelApi 1.1 ]

Represents the title of a chart axis.

[ API set: ExcelApi 1.1 ]

Represents the chart axis title formatting.

[ API set: ExcelApi 1.1 ]

Encapsulates the bin options for histogram charts and pareto charts.

[ API set: ExcelApi 1.9 ]

Represents the border formatting of a chart element.

[ API set: ExcelApi 1.7 ]

Represents the properties of a box and whisker chart.

[ API set: ExcelApi 1.9 ]

A collection of all the chart objects on a worksheet.

[ API set: ExcelApi 1.1 ]

Represents the data label of a chart point.

[ API set: ExcelApi 1.7 ]

Encapsulates the format properties for the chart data labels.

[ API set: ExcelApi 1.1 ]

Represents a collection of all the data labels on a chart point.

[ API set: ExcelApi 1.1 ]

This object represents the attributes for a chart's error bars.

[ API set: ExcelApi 1.9 ]

Encapsulates the format properties for chart error bars.

[ API set: ExcelApi 1.9 ]

Represents the fill formatting for a chart element.

[ API set: ExcelApi 1.1 ]

This object represents the font attributes (font name, font size, color, etc.) for a chart object.

[ API set: ExcelApi 1.1 ]

Represents the substring in chart related objects that contains text, like ChartTitle object, ChartAxisTitle object, etc.

[ API set: ExcelApi 1.7 ]

Represents major or minor gridlines on a chart axis.

[ API set: ExcelApi 1.1 ]

Encapsulates the format properties for chart gridlines.

[ API set: ExcelApi 1.1 ]

Represents the legend in a chart.

[ API set: ExcelApi 1.1 ]

Represents the legendEntry in legendEntryCollection.

[ API set: ExcelApi 1.7 ]

Represents a collection of legendEntries.

[ API set: ExcelApi 1.7 ]

Encapsulates the format properties of a chart legend.

[ API set: ExcelApi 1.1 ]

Encapsulates the formatting options for line elements.

[ API set: ExcelApi 1.1 ]

Encapsulates the properties for a region map chart.

[ API set: ExcelApi 1.9 ]

Encapsulates the options for the pivot chart.

[ API set: ExcelApi 1.9 ]

This object represents the attributes for a chart plotArea object.

[ API set: ExcelApi 1.8 ]

Represents the format properties for chart plotArea.

[ API set: ExcelApi 1.8 ]

Represents a point of a series in a chart.

[ API set: ExcelApi 1.1 ]

Represents formatting object for chart points.

[ API set: ExcelApi 1.1 ]

A collection of all the chart points within a series inside a chart.

[ API set: ExcelApi 1.1 ]

Represents a series in a chart.

[ API set: ExcelApi 1.1 ]

Represents a collection of chart series.

[ API set: ExcelApi 1.1 ]

Encapsulates the format properties for the chart series

[ API set: ExcelApi 1.1 ]

Represents a chart title object of a chart.

[ API set: ExcelApi 1.1 ]

Provides access to the office art formatting for chart title.

[ API set: ExcelApi 1.1 ]

This object represents the attributes for a chart trendline object.

[ API set: ExcelApi 1.7 ]

Represents a collection of Chart Trendlines.

[ API set: ExcelApi 1.7 ]

Represents the format properties for chart trendline.

[ API set: ExcelApi 1.7 ]

This object represents the attributes for a chart trendline lable object.

[ API set: ExcelApi 1.8 ]

Encapsulates the format properties for the chart trendline label.

[ API set: ExcelApi 1.8 ]

Represents an IconSet criteria for conditional formatting.

[ API set: ExcelApi 1.6 ]

Represents a cell comment object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of comment objects that are part of the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a cell comment reply object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of comment reply objects that are part of the comment.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a conditional format DataBar Format for the negative side of the data bar.

[ API set: ExcelApi 1.6 ]

Represents a conditional format DataBar Format for the positive side of the data bar.

[ API set: ExcelApi 1.6 ]

An object encapsulating a conditional format's range, format, rule, and other properties. To learn more about the conditional formatting object model, read Apply conditional formatting to Excel ranges.

[ API set: ExcelApi 1.6 ]

Represents a collection of all the conditional formats that are overlap the range.

[ API set: ExcelApi 1.6 ]

Represents a rule, for all traditional rule/format pairings.

[ API set: ExcelApi 1.6 ]

Represents the border of an object.

[ API set: ExcelApi 1.6 ]

Represents the border objects that make up range border.

[ API set: ExcelApi 1.6 ]

Represents the background of a conditional range object.

[ API set: ExcelApi 1.6 ]

This object represents the font attributes (font style, color, etc.) for an object.

[ API set: ExcelApi 1.6 ]

A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

[ API set: ExcelApi 1.6 ]

Represents a custom conditional format type.

[ API set: ExcelApi 1.6 ]

Represents a custom property.

[ API set: ExcelApi 1.7 ]

Contains the collection of customProperty objects.

[ API set: ExcelApi 1.7 ]

Represents a custom XML part object in a workbook.

[ API set: ExcelApi 1.5 ]

A collection of custom XML parts.

[ API set: ExcelApi 1.5 ]

A scoped collection of custom XML parts. A scoped collection is the result of some operation, e.g. filtering by namespace. A scoped collection cannot be scoped any further.

[ API set: ExcelApi 1.5 ]

Represents an Excel Conditional Data Bar Type.

[ API set: ExcelApi 1.6 ]

Represents a collection of all the Data Connections that are part of the workbook or worksheet.

[ API set: ExcelApi 1.7 ]

Represents the Excel DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

Represents a collection of DataPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

Represents the data validation applied to the current range. To learn more about the data validation object model, read Add data validation to Excel ranges.

[ API set: ExcelApi 1.8 ]

Represents workbook properties.

[ API set: ExcelApi 1.7 ]

Manages the filtering of a table's column.

[ API set: ExcelApi 1.2 ]

Represents the Excel FilterPivotHierarchy.

[ API set: ExcelApi 1.8 ]

Represents a collection of FilterPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

Represents the format protection of a range object.

[ API set: ExcelApi 1.2 ]

An object containing the result of a function-evaluation operation

[ API set: ExcelApi 1.2 ]

An object for evaluating Excel functions.

[ API set: ExcelApi 1.2 ]

Represents a geometric shape inside a worksheet. A geometric shape can be a rectangle, block arrow, equation symbol, flowchart item, star, banner, callout, or any other basic shape in Excel.

[ API set: ExcelApi 1.9 ]

Represents the shape collection inside a shape group.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

Represents an IconSet criteria for conditional formatting.

[ API set: ExcelApi 1.6 ]

Represents an image in the worksheet. To get the corresponding Shape object, use Image.shape.

[ API set: ExcelApi 1.9 ]

Represents the Iterative Calculation settings.

[ API set: ExcelApi 1.9 ]

Represents a line inside a worksheet. To get the corresponding Shape object, use Line.shape.

[ API set: ExcelApi 1.9 ]

Represents a defined name for a range of cells or value. Names can be primitive named objects (as seen in the type below), range object, or a reference to a range. This object can be used to obtain range object associated with names.

[ API set: ExcelApi 1.1 ]

Represents an object containing values and types of a named item.

[ API set: ExcelApi 1.7 ]

A collection of all the NamedItem objects that are part of the workbook or worksheet, depending on how it was reached.

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

Represents the Excel PivotField.

[ API set: ExcelApi 1.8 ]

Represents a collection of all the PivotFields that are part of a PivotTable's hierarchy.

[ API set: ExcelApi 1.8 ]

Represents the Excel PivotHierarchy.

[ API set: ExcelApi 1.8 ]

Represents a collection of all the PivotHierarchies that are part of the PivotTable.

[ API set: ExcelApi 1.8 ]

Represents the Excel PivotItem.

[ API set: ExcelApi 1.8 ]

Represents a collection of all the PivotItems related to their parent PivotField.

[ API set: ExcelApi 1.8 ]

Represents the visual layout of the PivotTable.

[ API set: ExcelApi 1.8 ]

Represents an Excel PivotTable. To learn more about the PivotTable object model, read Work with PivotTables using the Excel JavaScript API.

[ API set: ExcelApi 1.3 ]

Represents a collection of all the PivotTables that are part of the workbook or worksheet.

[ API set: ExcelApi 1.3 ]

Represents a PivotTable Style, which defines style elements by PivotTable region.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of PivotTable styles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.

[ API set: ExcelApi 1.6 ]

Range represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc. To learn more about how ranges are used throughout the API, read Work with ranges using the Excel JavaScript API and Work with ranges using the Excel JavaScript API (advanced).

[ API set: ExcelApi 1.1 ]

RangeAreas represents a collection of one or more rectangular ranges in the same worksheet. To learn how to use discontinguous ranges, read Work with multiple ranges simultaneously in Excel add-ins.

[ API set: ExcelApi 1.9 ]

Represents the border of an object.

[ API set: ExcelApi 1.1 ]

Represents the border objects that make up the range border.

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.9 ]

Represents the background of a range object.

[ API set: ExcelApi 1.1 ]

This object represents the font attributes (font name, font size, color, etc.) for an object.

[ API set: ExcelApi 1.1 ]

A format object encapsulating the range's font, fill, borders, alignment, and other properties.

[ API set: ExcelApi 1.1 ]

Manages sorting operations on Range objects.

[ API set: ExcelApi 1.2 ]

RangeView represents a set of visible cells of the parent range.

[ API set: ExcelApi 1.3 ]

Represents a collection of RangeView objects.

[ API set: ExcelApi 1.3 ]

Represents the results from the removeDuplicates method on range

[ API set: ExcelApi 1.9 ]

The RequestContext object facilitates requests to the Excel application. Since the Office add-in and the Excel application run in two different processes, the request context is required to get access to the Excel object model from the add-in.

Represents the Excel RowColumnPivotHierarchy.

[ API set: ExcelApi 1.8 ]

Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

Represents the Excel Runtime class.

[ API set: ExcelApi 1.5 ]

Provides connection session for a remote workbook.

Setting represents a key-value pair of a setting persisted to the document (per file per add-in). These custom key-value pair can be used to store state or lifecycle information needed by the content or task-pane add-in. Note that settings are persisted in the document and hence it is not a place to store any sensitive or protected information such as user information and password.

[ API set: ExcelApi 1.4 ]

Represents a collection of key-value pair setting objects that are part of the workbook. The scope is limited to per file and add-in (task-pane or content) combination.

[ API set: ExcelApi 1.4 ]

Represents a generic shape object in the worksheet. A shape could be a geometric shape, a line, a group of shapes, etc. To learn more about the shape object model, read Work with shapes using the Excel JavaScript API.

[ API set: ExcelApi 1.9 ]

Represents a collection of all the shapes in the worksheet.

[ API set: ExcelApi 1.9 ]

Represents the fill formatting of a shape object.

[ API set: ExcelApi 1.9 ]

Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object.

[ API set: ExcelApi 1.9 ]

Represents a shape group inside a worksheet. To get the corresponding Shape object, use ShapeGroup.shape.

[ API set: ExcelApi 1.9 ]

Represents the line formatting for the shape object. For images and geometric shapes, line formatting represents the border of the shape.

[ API set: ExcelApi 1.9 ]

Represents a slicer object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of all the slicer objects on the workbook or a worksheet.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a slicer item in a slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of all the slicer item objects on the slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a Slicer Style, which defines style elements by region of the slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of SlicerStyle objects.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An object encapsulating a style's format and other properties.

[ API set: ExcelApi 1.7 ]

Represents a collection of all the styles.

[ API set: ExcelApi 1.7 ]

Represents an Excel table. To learn more about the table object model, read Work with tables using the Excel JavaScript API.

[ API set: ExcelApi 1.1 ]

Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

[ API set: ExcelApi 1.1 ]

Represents a column in a table.

[ API set: ExcelApi 1.1 ]

Represents a collection of all the columns that are part of the table.

[ API set: ExcelApi 1.1 ]

Represents a row in a table.

Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

[ API set: ExcelApi 1.1 ]

Represents a collection of all the rows that are part of the table.

Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

[ API set: ExcelApi 1.1 ]

Represents a scoped collection of tables. For each table its top-left corner is considered its anchor location and the tables are sorted top to bottom and then left to right.

[ API set: ExcelApi 1.9 ]

Manages sorting operations on Table objects.

[ API set: ExcelApi 1.2 ]

Represents a TableStyle, which defines the style elements by region of the Table.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of TableStyles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a specific text conditional format.

[ API set: ExcelApi 1.6 ]

Represents the text frame of a shape object.

[ API set: ExcelApi 1.9 ]

Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.

[ API set: ExcelApi 1.9 ]

Represents a Timeline style, which defines style elements by region in the Timeline.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a collection of TimelineStyles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents a Top/Bottom conditional format.

[ API set: ExcelApi 1.6 ]

Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc. To learn more about the workbook object model, read Work with workbooks using the Excel JavaScript API.

[ API set: ExcelApi 1.1 ]

The WorkbookCreated object is the top level object created by Application.CreateWorkbook. A WorkbookCreated object is a special Workbook object.

[ API set: ExcelApi 1.8 ]

Represents the protection of a workbook object.

[ API set: ExcelApi 1.7 ]

An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc. To learn more about the worksheet object model, read Work with worksheets using the Excel JavaScript API.

[ API set: ExcelApi 1.1 ]

Represents a collection of worksheet objects that are part of the workbook.

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.7 ]

Represents the protection of a sheet object.

[ API set: ExcelApi 1.2 ]

Represents the Basic Type data validation criteria.

[ API set: ExcelApi 1.8 ]

Provides information about the binding that raised the DataChanged event.

[ API set: ExcelApi 1.2 ]

Provides information about the binding that raised the SelectionChanged event.

[ API set: ExcelApi 1.2 ]

Represents the properties of a single border returned by getCellProperties, getRowProperties, and getColumnProperties or the border property input parameter of setCellProperties, setRowProperties, and setColumnProperties.

[ API set: ExcelApi 1.9 ]

Represents the format.borders properties of getCellProperties, getRowProperties, and getColumnProperties or the format.borders input parameter of setCellProperties, setRowProperties, and setColumnProperties.

[ API set: ExcelApi 1.9 ]

Represents the returned properties of getCellProperties.

[ API set: ExcelApi 1.9 ]

Specifies which properties to load on the format.borders object.

[ API set: ExcelApi 1.9 ]

Represents the format.fill properties of getCellProperties, getRowProperties, and getColumnProperties or the format.fill input parameter of setCellProperties, setRowProperties, and setColumnProperties.

[ API set: ExcelApi 1.9 ]

Specifies which properties to load on the format.fill object.

[ API set: ExcelApi 1.9 ]

Represents the format.font properties of getCellProperties, getRowProperties, and getColumnProperties or the format.font input parameter of setCellProperties, setRowProperties, and setColumnProperties.

[ API set: ExcelApi 1.9 ]

Specifies which properties to load on the format.font object.

[ API set: ExcelApi 1.9 ]

Represents the returned format properties of getCellProperties or format input parameter of setCellProperties.

[ API set: ExcelApi 1.9 ]

Represents which properties to load on the format object.

[ API set: ExcelApi 1.9 ]

Represents which cell properties to load, when used as part of a "range.getCellProperties" method.

[ API set: ExcelApi 1.9 ]

Represents the format.protection properties of getCellProperties, getRowProperties, and getColumnProperties or the format.protection input parameter of setCellProperties, setRowProperties, and setColumnProperties.

[ API set: ExcelApi 1.9 ]

Provide information about the detail of WorksheetChangedEvent/TableChangedEvent

[ API set: ExcelApi 1.9 ]

Provides information about the chart that raised the Activated event.

[ API set: ExcelApi 1.8 ]

Provides information about the chart that raised the Added event.

[ API set: ExcelApi 1.8 ]

Provides information about the chart that raised the Deactivated event.

[ API set: ExcelApi 1.8 ]

Provides information about the chart that raised the Deleted event.

[ API set: ExcelApi 1.8 ]

Represents the returned properties of getColumnProperties.

[ API set: ExcelApi 1.9 ]

Represents which column properties to load, when used as part of a "range.getColumnProperties" method.

[ API set: ExcelApi 1.9 ]

Represents a cell value conditional format rule.

[ API set: ExcelApi 1.6 ]

Represents the criteria of the color scale.

[ API set: ExcelApi 1.6 ]

Represents a Color Scale Criterion which contains a type, value, and a color.

[ API set: ExcelApi 1.6 ]

Represents a rule-type for a Data Bar.

[ API set: ExcelApi 1.6 ]

Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset.

[ API set: ExcelApi 1.6 ]

Represents the Preset Criteria Conditional Format Rule

[ API set: ExcelApi 1.6 ]

Represents a Cell Value Conditional Format Rule

[ API set: ExcelApi 1.6 ]

Represents the rule of the top/bottom conditional format.

[ API set: ExcelApi 1.6 ]

Represents the Custom data validation criteria.

[ API set: ExcelApi 1.8 ]

Represents the error alert properties for the data validation.

[ API set: ExcelApi 1.8 ]

Represents the user prompt properties for the data validation.

[ API set: ExcelApi 1.8 ]

Data validation rule contains different types of data validation. You can only use one of them at a time according the Excel.DataValidationType.

[ API set: ExcelApi 1.8 ]

Represents the Date data validation criteria.

[ API set: ExcelApi 1.8 ]

Represents the filtering criteria applied to a column.

[ API set: ExcelApi 1.2 ]

Represents how to filter a date when filtering on values.

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

Represents a cell icon.

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

An interface describing the data returned by calling "application.toJSON()".

Represents the Excel application that manages the workbook.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the Application object, for use in "application.set({ ... })".

An interface describing the data returned by calling "autoFilter.toJSON()".

Represents the AutoFilter object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "bindingCollection.toJSON()".

Represents the collection of all the binding objects that are part of the workbook.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the BindingCollection object, for use in "bindingCollection.set({ ... })".

An interface describing the data returned by calling "binding.toJSON()".

Represents an Office.js binding that is defined in the workbook.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "cellValueConditionalFormat.toJSON()".

Represents a cell value conditional format.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the CellValueConditionalFormat object, for use in "cellValueConditionalFormat.set({ ... })".

An interface describing the data returned by calling "chartAreaFormat.toJSON()".

Encapsulates the format properties for the overall chart area.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartAreaFormat object, for use in "chartAreaFormat.set({ ... })".

An interface describing the data returned by calling "chartAxes.toJSON()".

Represents the chart axes.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartAxes object, for use in "chartAxes.set({ ... })".

An interface describing the data returned by calling "chartAxis.toJSON()".

An interface describing the data returned by calling "chartAxisFormat.toJSON()".

Encapsulates the format properties for the chart axis.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartAxisFormat object, for use in "chartAxisFormat.set({ ... })".

Represents a single axis in a chart.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "chartAxisTitle.toJSON()".

An interface describing the data returned by calling "chartAxisTitleFormat.toJSON()".

Represents the chart axis title formatting.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartAxisTitleFormat object, for use in "chartAxisTitleFormat.set({ ... })".

Represents the title of a chart axis.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartAxisTitle object, for use in "chartAxisTitle.set({ ... })".

An interface for updating data on the ChartAxis object, for use in "chartAxis.set({ ... })".

An interface describing the data returned by calling "chartBinOptions.toJSON()".

Encapsulates the bin options for histogram charts and pareto charts.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartBinOptions object, for use in "chartBinOptions.set({ ... })".

An interface describing the data returned by calling "chartBorder.toJSON()".

Represents the border formatting of a chart element.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartBorder object, for use in "chartBorder.set({ ... })".

An interface describing the data returned by calling "chartBoxwhiskerOptions.toJSON()".

Represents the properties of a box and whisker chart.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartBoxwhiskerOptions object, for use in "chartBoxwhiskerOptions.set({ ... })".

An interface describing the data returned by calling "chartCollection.toJSON()".

A collection of all the chart objects on a worksheet.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartCollection object, for use in "chartCollection.set({ ... })".

An interface describing the data returned by calling "chart.toJSON()".

An interface describing the data returned by calling "chartDataLabel.toJSON()".

An interface describing the data returned by calling "chartDataLabelFormat.toJSON()".

Encapsulates the format properties for the chart data labels.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartDataLabelFormat object, for use in "chartDataLabelFormat.set({ ... })".

Represents the data label of a chart point.

[ API set: ExcelApi 1.7 ]

An interface describing the data returned by calling "chartDataLabels.toJSON()".

Represents a collection of all the data labels on a chart point.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartDataLabels object, for use in "chartDataLabels.set({ ... })".

An interface for updating data on the ChartDataLabel object, for use in "chartDataLabel.set({ ... })".

An interface describing the data returned by calling "chartErrorBars.toJSON()".

An interface describing the data returned by calling "chartErrorBarsFormat.toJSON()".

Encapsulates the format properties for chart error bars.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartErrorBarsFormat object, for use in "chartErrorBarsFormat.set({ ... })".

This object represents the attributes for a chart's error bars.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartErrorBars object, for use in "chartErrorBars.set({ ... })".

An interface describing the data returned by calling "chartFont.toJSON()".

This object represents the font attributes (font name, font size, color, etc.) for a chart object.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartFont object, for use in "chartFont.set({ ... })".

An interface describing the data returned by calling "chartFormatString.toJSON()".

Represents the substring in chart related objects that contains text, like ChartTitle object, ChartAxisTitle object, etc.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartFormatString object, for use in "chartFormatString.set({ ... })".

An interface describing the data returned by calling "chartGridlines.toJSON()".

An interface describing the data returned by calling "chartGridlinesFormat.toJSON()".

Encapsulates the format properties for chart gridlines.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartGridlinesFormat object, for use in "chartGridlinesFormat.set({ ... })".

Represents major or minor gridlines on a chart axis.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartGridlines object, for use in "chartGridlines.set({ ... })".

An interface describing the data returned by calling "chartLegend.toJSON()".

An interface describing the data returned by calling "chartLegendEntryCollection.toJSON()".

Represents a collection of legendEntries.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartLegendEntryCollection object, for use in "chartLegendEntryCollection.set({ ... })".

An interface describing the data returned by calling "chartLegendEntry.toJSON()".

Represents the legendEntry in legendEntryCollection.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartLegendEntry object, for use in "chartLegendEntry.set({ ... })".

An interface describing the data returned by calling "chartLegendFormat.toJSON()".

Encapsulates the format properties of a chart legend.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartLegendFormat object, for use in "chartLegendFormat.set({ ... })".

Represents the legend in a chart.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartLegend object, for use in "chartLegend.set({ ... })".

An interface describing the data returned by calling "chartLineFormat.toJSON()".

Encapsulates the formatting options for line elements.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartLineFormat object, for use in "chartLineFormat.set({ ... })".

Represents a chart object in a workbook.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "chartMapOptions.toJSON()".

Encapsulates the properties for a region map chart.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartMapOptions object, for use in "chartMapOptions.set({ ... })".

An interface describing the data returned by calling "chartPivotOptions.toJSON()".

Encapsulates the options for the pivot chart.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ChartPivotOptions object, for use in "chartPivotOptions.set({ ... })".

An interface describing the data returned by calling "chartPlotArea.toJSON()".

An interface describing the data returned by calling "chartPlotAreaFormat.toJSON()".

Represents the format properties for chart plotArea.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the ChartPlotAreaFormat object, for use in "chartPlotAreaFormat.set({ ... })".

This object represents the attributes for a chart plotArea object.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the ChartPlotArea object, for use in "chartPlotArea.set({ ... })".

An interface describing the data returned by calling "chartPoint.toJSON()".

An interface describing the data returned by calling "chartPointFormat.toJSON()".

Represents formatting object for chart points.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartPointFormat object, for use in "chartPointFormat.set({ ... })".

Represents a point of a series in a chart.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "chartPointsCollection.toJSON()".

A collection of all the chart points within a series inside a chart.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartPointsCollection object, for use in "chartPointsCollection.set({ ... })".

An interface for updating data on the ChartPoint object, for use in "chartPoint.set({ ... })".

An interface describing the data returned by calling "chartSeriesCollection.toJSON()".

Represents a collection of chart series.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartSeriesCollection object, for use in "chartSeriesCollection.set({ ... })".

An interface describing the data returned by calling "chartSeries.toJSON()".

An interface describing the data returned by calling "chartSeriesFormat.toJSON()".

Encapsulates the format properties for the chart series

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartSeriesFormat object, for use in "chartSeriesFormat.set({ ... })".

Represents a series in a chart.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartSeries object, for use in "chartSeries.set({ ... })".

An interface describing the data returned by calling "chartTitle.toJSON()".

An interface describing the data returned by calling "chartTitleFormat.toJSON()".

Provides access to the office art formatting for chart title.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartTitleFormat object, for use in "chartTitleFormat.set({ ... })".

Represents a chart title object of a chart.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the ChartTitle object, for use in "chartTitle.set({ ... })".

An interface describing the data returned by calling "chartTrendlineCollection.toJSON()".

Represents a collection of Chart Trendlines.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartTrendlineCollection object, for use in "chartTrendlineCollection.set({ ... })".

An interface describing the data returned by calling "chartTrendline.toJSON()".

An interface describing the data returned by calling "chartTrendlineFormat.toJSON()".

Represents the format properties for chart trendline.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartTrendlineFormat object, for use in "chartTrendlineFormat.set({ ... })".

An interface describing the data returned by calling "chartTrendlineLabel.toJSON()".

An interface describing the data returned by calling "chartTrendlineLabelFormat.toJSON()".

Encapsulates the format properties for the chart trendline label.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the ChartTrendlineLabelFormat object, for use in "chartTrendlineLabelFormat.set({ ... })".

This object represents the attributes for a chart trendline lable object.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the ChartTrendlineLabel object, for use in "chartTrendlineLabel.set({ ... })".

This object represents the attributes for a chart trendline object.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the ChartTrendline object, for use in "chartTrendline.set({ ... })".

An interface for updating data on the Chart object, for use in "chart.set({ ... })".

Provides ways to load properties of only a subset of members of a collection.

An interface describing the data returned by calling "colorScaleConditionalFormat.toJSON()".

Represents an IconSet criteria for conditional formatting.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ColorScaleConditionalFormat object, for use in "colorScaleConditionalFormat.set({ ... })".

An interface describing the data returned by calling "commentCollection.toJSON()".

Represents a collection of comment objects that are part of the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the CommentCollection object, for use in "commentCollection.set({ ... })".

An interface describing the data returned by calling "comment.toJSON()".

Represents a cell comment object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface describing the data returned by calling "commentReplyCollection.toJSON()".

Represents a collection of comment reply objects that are part of the comment.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the CommentReplyCollection object, for use in "commentReplyCollection.set({ ... })".

An interface describing the data returned by calling "commentReply.toJSON()".

Represents a cell comment reply object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the CommentReply object, for use in "commentReply.set({ ... })".

An interface for updating data on the Comment object, for use in "comment.set({ ... })".

An interface describing the data returned by calling "conditionalDataBarNegativeFormat.toJSON()".

Represents a conditional format DataBar Format for the negative side of the data bar.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalDataBarNegativeFormat object, for use in "conditionalDataBarNegativeFormat.set({ ... })".

An interface describing the data returned by calling "conditionalDataBarPositiveFormat.toJSON()".

Represents a conditional format DataBar Format for the positive side of the data bar.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalDataBarPositiveFormat object, for use in "conditionalDataBarPositiveFormat.set({ ... })".

An interface describing the data returned by calling "conditionalFormatCollection.toJSON()".

Represents a collection of all the conditional formats that are overlap the range.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalFormatCollection object, for use in "conditionalFormatCollection.set({ ... })".

An interface describing the data returned by calling "conditionalFormat.toJSON()".

An object encapsulating a conditional format's range, format, rule, and other properties.

[ API set: ExcelApi 1.6 ]

An interface describing the data returned by calling "conditionalFormatRule.toJSON()".

Represents a rule, for all traditional rule/format pairings.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalFormatRule object, for use in "conditionalFormatRule.set({ ... })".

An interface for updating data on the ConditionalFormat object, for use in "conditionalFormat.set({ ... })".

An interface describing the data returned by calling "conditionalRangeBorderCollection.toJSON()".

Represents the border objects that make up range border.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalRangeBorderCollection object, for use in "conditionalRangeBorderCollection.set({ ... })".

An interface describing the data returned by calling "conditionalRangeBorder.toJSON()".

Represents the border of an object.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalRangeBorder object, for use in "conditionalRangeBorder.set({ ... })".

An interface describing the data returned by calling "conditionalRangeFill.toJSON()".

Represents the background of a conditional range object.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalRangeFill object, for use in "conditionalRangeFill.set({ ... })".

An interface describing the data returned by calling "conditionalRangeFont.toJSON()".

This object represents the font attributes (font style, color, etc.) for an object.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalRangeFont object, for use in "conditionalRangeFont.set({ ... })".

An interface describing the data returned by calling "conditionalRangeFormat.toJSON()".

A format object encapsulating the conditional formats range's font, fill, borders, and other properties.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the ConditionalRangeFormat object, for use in "conditionalRangeFormat.set({ ... })".

An interface describing the data returned by calling "customConditionalFormat.toJSON()".

Represents a custom conditional format type.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the CustomConditionalFormat object, for use in "customConditionalFormat.set({ ... })".

An interface describing the data returned by calling "customPropertyCollection.toJSON()".

Contains the collection of customProperty objects.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the CustomPropertyCollection object, for use in "customPropertyCollection.set({ ... })".

An interface describing the data returned by calling "customProperty.toJSON()".

Represents a custom property.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the CustomProperty object, for use in "customProperty.set({ ... })".

An interface describing the data returned by calling "customXmlPartCollection.toJSON()".

A collection of custom XML parts.

[ API set: ExcelApi 1.5 ]

An interface for updating data on the CustomXmlPartCollection object, for use in "customXmlPartCollection.set({ ... })".

An interface describing the data returned by calling "customXmlPart.toJSON()".

Represents a custom XML part object in a workbook.

[ API set: ExcelApi 1.5 ]

An interface describing the data returned by calling "customXmlPartScopedCollection.toJSON()".

A scoped collection of custom XML parts. A scoped collection is the result of some operation, e.g. filtering by namespace. A scoped collection cannot be scoped any further.

[ API set: ExcelApi 1.5 ]

An interface for updating data on the CustomXmlPartScopedCollection object, for use in "customXmlPartScopedCollection.set({ ... })".

An interface describing the data returned by calling "dataBarConditionalFormat.toJSON()".

Represents an Excel Conditional Data Bar Type.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the DataBarConditionalFormat object, for use in "dataBarConditionalFormat.set({ ... })".

An interface describing the data returned by calling "dataPivotHierarchyCollection.toJSON()".

Represents a collection of DataPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the DataPivotHierarchyCollection object, for use in "dataPivotHierarchyCollection.set({ ... })".

An interface describing the data returned by calling "dataPivotHierarchy.toJSON()".

Represents the Excel DataPivotHierarchy.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the DataPivotHierarchy object, for use in "dataPivotHierarchy.set({ ... })".

An interface describing the data returned by calling "dataValidation.toJSON()".

Represents the data validation applied to the current range.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the DataValidation object, for use in "dataValidation.set({ ... })".

An interface describing the data returned by calling "documentProperties.toJSON()".

Represents workbook properties.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the DocumentProperties object, for use in "documentProperties.set({ ... })".

An interface describing the data returned by calling "filter.toJSON()".

Manages the filtering of a table's column.

[ API set: ExcelApi 1.2 ]

An interface describing the data returned by calling "filterPivotHierarchyCollection.toJSON()".

Represents a collection of FilterPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the FilterPivotHierarchyCollection object, for use in "filterPivotHierarchyCollection.set({ ... })".

An interface describing the data returned by calling "filterPivotHierarchy.toJSON()".

Represents the Excel FilterPivotHierarchy.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the FilterPivotHierarchy object, for use in "filterPivotHierarchy.set({ ... })".

An interface describing the data returned by calling "formatProtection.toJSON()".

Represents the format protection of a range object.

[ API set: ExcelApi 1.2 ]

An interface for updating data on the FormatProtection object, for use in "formatProtection.set({ ... })".

An interface describing the data returned by calling "functionResult.toJSON()".

An object containing the result of a function-evaluation operation

[ API set: ExcelApi 1.2 ]

An interface describing the data returned by calling "geometricShape.toJSON()".

Represents a geometric shape inside a worksheet. A geometric shape can be a rectangle, block arrow, equation symbol, flowchart item, star, banner, callout, or any other basic shape in Excel.

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "groupShapeCollection.toJSON()".

Represents the shape collection inside a shape group.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the GroupShapeCollection object, for use in "groupShapeCollection.set({ ... })".

An interface describing the data returned by calling "headerFooter.toJSON()".

An interface describing the data returned by calling "headerFooterGroup.toJSON()".

[ API set: ExcelApi 1.9 ]

An interface for updating data on the HeaderFooterGroup object, for use in "headerFooterGroup.set({ ... })".

[ API set: ExcelApi 1.9 ]

An interface for updating data on the HeaderFooter object, for use in "headerFooter.set({ ... })".

An interface describing the data returned by calling "iconSetConditionalFormat.toJSON()".

Represents an IconSet criteria for conditional formatting.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the IconSetConditionalFormat object, for use in "iconSetConditionalFormat.set({ ... })".

An interface describing the data returned by calling "image.toJSON()".

Represents an image in the worksheet. To get the corresponding Shape object, use Image.shape.

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "iterativeCalculation.toJSON()".

Represents the Iterative Calculation settings.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the IterativeCalculation object, for use in "iterativeCalculation.set({ ... })".

An interface describing the data returned by calling "line.toJSON()".

Represents a line inside a worksheet. To get the corresponding Shape object, use Line.shape.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the Line object, for use in "line.set({ ... })".

An interface describing the data returned by calling "namedItemArrayValues.toJSON()".

Represents an object containing values and types of a named item.

[ API set: ExcelApi 1.7 ]

An interface describing the data returned by calling "namedItemCollection.toJSON()".

A collection of all the NamedItem objects that are part of the workbook or worksheet, depending on how it was reached.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the NamedItemCollection object, for use in "namedItemCollection.set({ ... })".

An interface describing the data returned by calling "namedItem.toJSON()".

Represents a defined name for a range of cells or value. Names can be primitive named objects (as seen in the type below), range object, or a reference to a range. This object can be used to obtain range object associated with names.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the NamedItem object, for use in "namedItem.set({ ... })".

An interface describing the data returned by calling "pageBreakCollection.toJSON()".

[ API set: ExcelApi 1.9 ]

An interface for updating data on the PageBreakCollection object, for use in "pageBreakCollection.set({ ... })".

An interface describing the data returned by calling "pageBreak.toJSON()".

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "pageLayout.toJSON()".

[ API set: ExcelApi 1.9 ]

An interface for updating data on the PageLayout object, for use in "pageLayout.set({ ... })".

An interface describing the data returned by calling "pivotFieldCollection.toJSON()".

Represents a collection of all the PivotFields that are part of a PivotTable's hierarchy.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotFieldCollection object, for use in "pivotFieldCollection.set({ ... })".

An interface describing the data returned by calling "pivotField.toJSON()".

Represents the Excel PivotField.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotField object, for use in "pivotField.set({ ... })".

An interface describing the data returned by calling "pivotHierarchyCollection.toJSON()".

Represents a collection of all the PivotHierarchies that are part of the PivotTable.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotHierarchyCollection object, for use in "pivotHierarchyCollection.set({ ... })".

An interface describing the data returned by calling "pivotHierarchy.toJSON()".

Represents the Excel PivotHierarchy.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotHierarchy object, for use in "pivotHierarchy.set({ ... })".

An interface describing the data returned by calling "pivotItemCollection.toJSON()".

Represents a collection of all the PivotItems related to their parent PivotField.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotItemCollection object, for use in "pivotItemCollection.set({ ... })".

An interface describing the data returned by calling "pivotItem.toJSON()".

Represents the Excel PivotItem.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotItem object, for use in "pivotItem.set({ ... })".

An interface describing the data returned by calling "pivotLayout.toJSON()".

Represents the visual layout of the PivotTable.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the PivotLayout object, for use in "pivotLayout.set({ ... })".

An interface describing the data returned by calling "pivotTableCollection.toJSON()".

Represents a collection of all the PivotTables that are part of the workbook or worksheet.

[ API set: ExcelApi 1.3 ]

An interface for updating data on the PivotTableCollection object, for use in "pivotTableCollection.set({ ... })".

An interface describing the data returned by calling "pivotTable.toJSON()".

Represents an Excel PivotTable.

[ API set: ExcelApi 1.3 ]

An interface describing the data returned by calling "pivotTableStyleCollection.toJSON()".

Represents a collection of PivotTable styles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the PivotTableStyleCollection object, for use in "pivotTableStyleCollection.set({ ... })".

An interface describing the data returned by calling "pivotTableStyle.toJSON()".

Represents a PivotTable Style, which defines style elements by PivotTable region.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the PivotTableStyle object, for use in "pivotTableStyle.set({ ... })".

An interface for updating data on the PivotTable object, for use in "pivotTable.set({ ... })".

An interface describing the data returned by calling "presetCriteriaConditionalFormat.toJSON()".

Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the PresetCriteriaConditionalFormat object, for use in "presetCriteriaConditionalFormat.set({ ... })".

An interface describing the data returned by calling "rangeAreas.toJSON()".

RangeAreas represents a collection of one or more rectangular ranges in the same worksheet.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the RangeAreas object, for use in "rangeAreas.set({ ... })".

An interface describing the data returned by calling "rangeBorderCollection.toJSON()".

Represents the border objects that make up the range border.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the RangeBorderCollection object, for use in "rangeBorderCollection.set({ ... })".

An interface describing the data returned by calling "rangeBorder.toJSON()".

Represents the border of an object.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the RangeBorder object, for use in "rangeBorder.set({ ... })".

An interface describing the data returned by calling "rangeCollection.toJSON()".

[ API set: ExcelApi 1.9 ]

An interface for updating data on the RangeCollection object, for use in "rangeCollection.set({ ... })".

An interface describing the data returned by calling "range.toJSON()".

An interface describing the data returned by calling "rangeFill.toJSON()".

Represents the background of a range object.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the RangeFill object, for use in "rangeFill.set({ ... })".

An interface describing the data returned by calling "rangeFont.toJSON()".

This object represents the font attributes (font name, font size, color, etc.) for an object.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the RangeFont object, for use in "rangeFont.set({ ... })".

An interface describing the data returned by calling "rangeFormat.toJSON()".

A format object encapsulating the range's font, fill, borders, alignment, and other properties.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the RangeFormat object, for use in "rangeFormat.set({ ... })".

Range represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the Range object, for use in "range.set({ ... })".

An interface describing the data returned by calling "rangeViewCollection.toJSON()".

Represents a collection of RangeView objects.

[ API set: ExcelApi 1.3 ]

An interface for updating data on the RangeViewCollection object, for use in "rangeViewCollection.set({ ... })".

An interface describing the data returned by calling "rangeView.toJSON()".

RangeView represents a set of visible cells of the parent range.

[ API set: ExcelApi 1.3 ]

An interface for updating data on the RangeView object, for use in "rangeView.set({ ... })".

An interface describing the data returned by calling "removeDuplicatesResult.toJSON()".

Represents the results from the removeDuplicates method on range

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "rowColumnPivotHierarchyCollection.toJSON()".

Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the RowColumnPivotHierarchyCollection object, for use in "rowColumnPivotHierarchyCollection.set({ ... })".

An interface describing the data returned by calling "rowColumnPivotHierarchy.toJSON()".

Represents the Excel RowColumnPivotHierarchy.

[ API set: ExcelApi 1.8 ]

An interface for updating data on the RowColumnPivotHierarchy object, for use in "rowColumnPivotHierarchy.set({ ... })".

An interface describing the data returned by calling "runtime.toJSON()".

Represents the Excel Runtime class.

[ API set: ExcelApi 1.5 ]

An interface for updating data on the Runtime object, for use in "runtime.set({ ... })".

An interface describing the data returned by calling "settingCollection.toJSON()".

Represents a collection of key-value pair setting objects that are part of the workbook. The scope is limited to per file and add-in (task-pane or content) combination.

[ API set: ExcelApi 1.4 ]

An interface for updating data on the SettingCollection object, for use in "settingCollection.set({ ... })".

An interface describing the data returned by calling "setting.toJSON()".

Setting represents a key-value pair of a setting persisted to the document (per file per add-in). These custom key-value pair can be used to store state or lifecycle information needed by the content or task-pane add-in. Note that settings are persisted in the document and hence it is not a place to store any sensitive or protected information such as user information and password.

[ API set: ExcelApi 1.4 ]

An interface for updating data on the Setting object, for use in "setting.set({ ... })".

An interface describing the data returned by calling "shapeCollection.toJSON()".

Represents a collection of all the shapes in the worksheet.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ShapeCollection object, for use in "shapeCollection.set({ ... })".

An interface describing the data returned by calling "shape.toJSON()".

An interface describing the data returned by calling "shapeFill.toJSON()".

Represents the fill formatting of a shape object.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ShapeFill object, for use in "shapeFill.set({ ... })".

An interface describing the data returned by calling "shapeFont.toJSON()".

Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ShapeFont object, for use in "shapeFont.set({ ... })".

An interface describing the data returned by calling "shapeGroup.toJSON()".

Represents a shape group inside a worksheet. To get the corresponding Shape object, use ShapeGroup.shape.

[ API set: ExcelApi 1.9 ]

An interface describing the data returned by calling "shapeLineFormat.toJSON()".

Represents the line formatting for the shape object. For images and geometric shapes, line formatting represents the border of the shape.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the ShapeLineFormat object, for use in "shapeLineFormat.set({ ... })".

Represents a generic shape object in the worksheet. A shape could be a geometric shape, a line, a group of shapes, etc.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the Shape object, for use in "shape.set({ ... })".

An interface describing the data returned by calling "slicerCollection.toJSON()".

Represents a collection of all the slicer objects on the workbook or a worksheet.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the SlicerCollection object, for use in "slicerCollection.set({ ... })".

An interface describing the data returned by calling "slicer.toJSON()".

An interface describing the data returned by calling "slicerItemCollection.toJSON()".

Represents a collection of all the slicer item objects on the slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the SlicerItemCollection object, for use in "slicerItemCollection.set({ ... })".

An interface describing the data returned by calling "slicerItem.toJSON()".

Represents a slicer item in a slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the SlicerItem object, for use in "slicerItem.set({ ... })".

Represents a slicer object in the workbook.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface describing the data returned by calling "slicerStyleCollection.toJSON()".

Represents a collection of SlicerStyle objects.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the SlicerStyleCollection object, for use in "slicerStyleCollection.set({ ... })".

An interface describing the data returned by calling "slicerStyle.toJSON()".

Represents a Slicer Style, which defines style elements by region of the slicer.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the SlicerStyle object, for use in "slicerStyle.set({ ... })".

An interface for updating data on the Slicer object, for use in "slicer.set({ ... })".

An interface describing the data returned by calling "styleCollection.toJSON()".

Represents a collection of all the styles.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the StyleCollection object, for use in "styleCollection.set({ ... })".

An interface describing the data returned by calling "style.toJSON()".

An object encapsulating a style's format and other properties.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the Style object, for use in "style.set({ ... })".

An interface describing the data returned by calling "tableCollection.toJSON()".

Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the TableCollection object, for use in "tableCollection.set({ ... })".

An interface describing the data returned by calling "tableColumnCollection.toJSON()".

Represents a collection of all the columns that are part of the table.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the TableColumnCollection object, for use in "tableColumnCollection.set({ ... })".

An interface describing the data returned by calling "tableColumn.toJSON()".

Represents a column in a table.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the TableColumn object, for use in "tableColumn.set({ ... })".

An interface describing the data returned by calling "table.toJSON()".

Represents an Excel table.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "tableRowCollection.toJSON()".

Represents a collection of all the rows that are part of the table.

Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the TableRowCollection object, for use in "tableRowCollection.set({ ... })".

An interface describing the data returned by calling "tableRow.toJSON()".

Represents a row in a table.

Note that unlike Ranges or Columns, which will adjust if new rows/columns are added before them, a TableRow object represent the physical location of the table row, but not the data. That is, if the data is sorted or if new rows are added, a table row will continue to point at the index for which it was created.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the TableRow object, for use in "tableRow.set({ ... })".

An interface describing the data returned by calling "tableScopedCollection.toJSON()".

Represents a scoped collection of tables. For each table its top-left corner is considered its anchor location and the tables are sorted top to bottom and then left to right.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the TableScopedCollection object, for use in "tableScopedCollection.set({ ... })".

An interface describing the data returned by calling "tableSort.toJSON()".

Manages sorting operations on Table objects.

[ API set: ExcelApi 1.2 ]

An interface describing the data returned by calling "tableStyleCollection.toJSON()".

Represents a collection of TableStyles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the TableStyleCollection object, for use in "tableStyleCollection.set({ ... })".

An interface describing the data returned by calling "tableStyle.toJSON()".

Represents a TableStyle, which defines the style elements by region of the Table.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the TableStyle object, for use in "tableStyle.set({ ... })".

An interface for updating data on the Table object, for use in "table.set({ ... })".

An interface describing the data returned by calling "textConditionalFormat.toJSON()".

Represents a specific text conditional format.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the TextConditionalFormat object, for use in "textConditionalFormat.set({ ... })".

An interface describing the data returned by calling "textFrame.toJSON()".

Represents the text frame of a shape object.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the TextFrame object, for use in "textFrame.set({ ... })".

An interface describing the data returned by calling "textRange.toJSON()".

Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.

[ API set: ExcelApi 1.9 ]

An interface for updating data on the TextRange object, for use in "textRange.set({ ... })".

An interface describing the data returned by calling "timelineStyleCollection.toJSON()".

Represents a collection of TimelineStyles.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the TimelineStyleCollection object, for use in "timelineStyleCollection.set({ ... })".

An interface describing the data returned by calling "timelineStyle.toJSON()".

Represents a Timeline style, which defines style elements by region in the Timeline.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

An interface for updating data on the TimelineStyle object, for use in "timelineStyle.set({ ... })".

An interface describing the data returned by calling "topBottomConditionalFormat.toJSON()".

Represents a Top/Bottom conditional format.

[ API set: ExcelApi 1.6 ]

An interface for updating data on the TopBottomConditionalFormat object, for use in "topBottomConditionalFormat.set({ ... })".

An interface describing the data returned by calling "workbookCreated.toJSON()".

An interface describing the data returned by calling "workbook.toJSON()".

Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "workbookProtection.toJSON()".

Represents the protection of a workbook object.

[ API set: ExcelApi 1.7 ]

An interface for updating data on the Workbook object, for use in "workbook.set({ ... })".

An interface describing the data returned by calling "worksheetCollection.toJSON()".

Represents a collection of worksheet objects that are part of the workbook.

[ API set: ExcelApi 1.1 ]

An interface for updating data on the WorksheetCollection object, for use in "worksheetCollection.set({ ... })".

An interface describing the data returned by calling "worksheet.toJSON()".

An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc.

[ API set: ExcelApi 1.1 ]

An interface describing the data returned by calling "worksheetProtection.toJSON()".

Represents the protection of a sheet object.

[ API set: ExcelApi 1.2 ]

An interface for updating data on the Worksheet object, for use in "worksheet.set({ ... })".

Represents the List data validation criteria.

[ API set: ExcelApi 1.8 ]

Represents the options in page layout margins.

[ API set: ExcelApi 1.9 ]

Represents page zoom properties.

[ API set: ExcelApi 1.9 ]

Represents the necessary strings to get/set a hyperlink (XHL) object.

[ API set: ExcelApi 1.7 ]

Represents a string reference of the form SheetName!A1:B5, or a global or local named range.

[ API set: ExcelApi 1.2 ]

Represents the replace criteria to be used.

[ API set: ExcelApi 1.9 ]

Represents the returned properties of getRowProperties.

[ API set: ExcelApi 1.9 ]

Represents which row properties to load, when used as part of a "range.getRowProperties" method.

[ API set: ExcelApi 1.9 ]

Represents the Basic Type data validation criteria.

[ API set: ExcelApi 1.8 ]

Represents the search criteria to be used.

[ API set: ExcelApi 1.9 ]

Provides information about the document that raised the SelectionChanged event.

[ API set: ExcelApi 1.2 ]

Represents the input parameter of setCellProperties.

[ API set: ExcelApi 1.9 ]

Represents the input parameter of setColumnProperties.

[ API set: ExcelApi 1.9 ]

Represents the input parameter of setRowProperties.

[ API set: ExcelApi 1.9 ]

Provides information about the setting that raised the SettingsChanged event

[ API set: ExcelApi 1.4 ]

Provides information about the shape that raised the Activated event.

[ API set: ExcelApi 1.9 ]

Provides information about the shape that raised the Deactivated event.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.8 ]

Represents a condition in a sorting operation.

[ API set: ExcelApi 1.2 ]

Subtotals for the Pivot Field.

[ API set: ExcelApi 1.8 ]

Provides information about the table that raised the OnAdded event.

[ API set: ExcelApi 1.9 ]

Provides information about the table that raised the Changed event.

[ API set: ExcelApi 1.7 ]

Provides information about the table that raised the OnDeleted event.

[ API set: ExcelApi 1.9 ]

Provides information about the table that raised the filter applied event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Provides information about the table that raised the SelectionChanged event.

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

Provides information about the workbook's onAutoSaveSettingChanged event.

[ API set: ExcelApi 1.9 ]

Provides information about the worksheet that raised the Activated event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the Added event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the Calculated event.

[ API set: ExcelApi 1.8 ]

Provides information about the worksheet that raised the Changed event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the ColumnSorted event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Provides information about the worksheet that raised the Deactivated event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the Deleted event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the filter applied event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Provides information about the worksheet format change event.

[ API set: ExcelApi 1.9 ]

Represents the options in sheet protection.

[ API set: ExcelApi 1.2 ]

Provides information about the worksheet row hidden change event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Provides information about the worksheet that raised the RowSorted event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents the worksheet search criteria to be used.

[ API set: ExcelApi 1.9 ]

Provides information about the worksheet that raised the SelectionChanged event.

[ API set: ExcelApi 1.7 ]

Provides information about the worksheet that raised the left-clicked/tapped event.

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Aggregation Function for the Data Pivot Field.

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.1 ]

Represents the state of calculation across the entire Excel application.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

Specifies the type of the category axis.

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

Specifies the unit of time for chart axes and data series.

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

Specifies the bin's type of a histogram chart or pareto chart series.

[ API set: ExcelApi 1.9 ]

Represents the quartile calculation type of chart series layout. Only applies to a box and whisker chart.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.8 ]

Represents which parts of the error bar to include.

[ API set: ExcelApi 1.9 ]

Represents the range type for error bars.

[ API set: ExcelApi 1.9 ]

Represents the gradient style of a chart series. This is only applicable for region map charts.

[ API set: ExcelApi 1.9 ]

Represents the gradient style type of a chart series. This is only applicable for region map charts.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.7 ]

Represents the mapping level of a chart series. This only applies to region map charts.

[ API set: ExcelApi 1.9 ]

Represents the region level of a chart series layout. This only applies to region map charts.

[ API set: ExcelApi 1.9 ]

Represents the region projection type of a chart series layout. This only applies to region map charts.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.7 ]

Represents the parent label strategy of the chart series layout. This only applies to treemap charts

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.8 ]

Specifies whether the series are by rows or by columns. On Desktop, the "auto" option will inspect the source data shape to automatically guess whether the data is by rows or columns; in Excel on the web, "auto" will simply default to "columns".

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.8 ]

Represents the horizontal alignment for the specified object.

[ API set: ExcelApi 1.7 ]

Represents the vertical alignment for the specified object.

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.8 ]

Represents the position of chart title.

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 for All/Formats/Contents, 1.7 for Hyperlinks & HyperlinksAndFormats. ]

Specifies the close behavior for Workbook.close API.

[ API set: ExcelApi 1.9 ]

Represents the operator of the text conditional format type.

[ API set: ExcelApi 1.6 ]

Represents the format options for a Data Bar Axis.

[ API set: ExcelApi 1.6 ]

Represents the Data Bar direction within a cell.

[ API set: ExcelApi 1.6 ]

Represents the types of conditional format values.

[ API set: ExcelApi 1.6 ]

Represents the direction for a selection.

[ API set: ExcelApi 1.6 ]

Represents the types of conditional format values.

[ API set: ExcelApi 1.6 ]

Represents the criteria for the Preset Criteria conditional format type.

[ API set: ExcelApi 1.6 ]

Represents the types of conditional format values.

[ API set: ExcelApi 1.6 ]

[ API set: ExcelApi 1.6 ]

Represents the operator for each icon criteria.

[ API set: ExcelApi 1.6 ]

[ API set: ExcelApi 1.6 ]

[ API set: ExcelApi 1.6 ]

[ API set: ExcelApi 1.6 ]

Represents the operator of the text conditional format type.

[ API set: ExcelApi 1.6 ]

Represents the criteria for the above/below average conditional format type.

[ API set: ExcelApi 1.6 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

[ API set: CustomFunctions 1.1 ]

[ API set: CustomFunctions 1.1 ]

[ API set: ExcelApi 1.7 ]

Represents Data validation error alert style. The default is "Stop".

[ API set: ExcelApi 1.8 ]

Represents Data validation operator enum.

[ API set: ExcelApi 1.8 ]

Represents Data validation type enum.

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.2 ]

Aggregation Function for the Data Pivot Field.

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

Specifies the shape type for a GeometricShape object.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.4 ]

[ API set: ExcelApi 1.1 for String,Integer,Double,Boolean,Range,Error; 1.7 for Array ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.9 ]

The format of the image.

[ API set: ExcelApi 1.9 ]

The ShowAs Calculation function for the Data Pivot Field.

[ API set: ExcelApi 1.9 ]

Represents the criteria for the top/bottom values filter.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.8 ]

Specifies the way that an object is attached to its underlying cells.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.1 for Unknown, Empty, String, Integer, Double, Boolean, Error. 1.7 for RichValue ]

[ API set: ExcelApi 1.7 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Specifies the save behavior for Workbook.save API.

[ API set: ExcelApi 1.9 ]

Specifies the search direction.

[ API set: ExcelApi 1.9 ]

Determines the type of automatic sizing allowed.

[ API set: ExcelApi 1.9 ]

Specifies a shape's fill type.

[ API set: ExcelApi 1.9 ]

The type of underline applied to a font.

[ API set: ExcelApi 1.9 ]

The dash style for a line.

[ API set: ExcelApi 1.9 ]

The style for a line.

[ API set: ExcelApi 1.9 ]

Specifies which part of the shape retains its position when the shape is scaled.

[ API set: ExcelApi 1.9 ]

Specifies whether the shape is scaled relative to its original or current size.

[ API set: ExcelApi 1.9 ]

Specifies the horizontal alignment for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the horizontal overflow for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the orientation for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the reading order for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the vertical alignment for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the vertical overflow for the text frame in a shape.

[ API set: ExcelApi 1.9 ]

Specifies the type of a shape.

[ API set: ExcelApi 1.9 ]

Specifies where in the z-order a shape should be moved relative to other shapes.

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.1 ]

The ShowAs Calculation function for the Data Pivot Field.

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi BETA (PREVIEW ONLY) ]

Represents the sort direction.

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.2 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.9 ]

[ API set: ExcelApi 1.8 ]

[ API set: ExcelApi 1.1 ]

[ API set: ExcelApi 1.7 ]

Creates and opens a new workbook. Optionally, the workbook can be pre-populated with a base64-encoded .xlsx file.

[ API set: ExcelApi 1.8 ]

Executes a batch script that performs actions on the Excel object model, using a new RequestContext. When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Executes a batch script that performs actions on the Excel object model, using the RequestContext of previously-created API objects.

Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created API object. When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.

Executes a batch script that performs actions on the Excel object model, using the RequestContext of a previously-created object. When the promise is resolved, any tracked objects that were automatically allocated during execution will be released.