excel package

Reference

Classes

Excel.Application	Represents the Excel application that manages the workbook.
Excel.AutoFilter	Represents the `AutoFilter` object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.
Excel.Binding	Represents an Office.js binding that is defined in the workbook.
Excel.BindingCollection	Represents the collection of all the binding objects that are part of the workbook.
Excel.CellValueConditionalFormat	Represents a cell value conditional format.
Excel.Chart	Represents a chart object in a workbook. To learn more about the chart object model, see Work with charts using the Excel JavaScript API.
Excel.ChartAreaFormat	Encapsulates the format properties for the overall chart area.
Excel.ChartAxes	Represents the chart axes.
Excel.ChartAxis	Represents a single axis in a chart.
Excel.ChartAxisFormat	Encapsulates the format properties for the chart axis.
Excel.ChartAxisTitle	Represents the title of a chart axis.
Excel.ChartAxisTitleFormat	Represents the chart axis title formatting.
Excel.ChartBinOptions	Encapsulates the bin options for histogram charts and pareto charts.
Excel.ChartBorder	Represents the border formatting of a chart element.
Excel.ChartBoxwhiskerOptions	Represents the properties of a box and whisker chart.
Excel.ChartCollection	A collection of all the chart objects on a worksheet.
Excel.ChartDataLabel	Represents the data label of a chart point.
Excel.ChartDataLabelFormat	Encapsulates the format properties for the chart data labels.
Excel.ChartDataLabels	Represents a collection of all the data labels on a chart point.
Excel.ChartDataTable	Represents the data table object of a chart.
Excel.ChartDataTableFormat	Represents the format of a chart data table.
Excel.ChartErrorBars	This object represents the attributes for a chart's error bars.
Excel.ChartErrorBarsFormat	Encapsulates the format properties for chart error bars.
Excel.ChartFill	Represents the fill formatting for a chart element.
Excel.ChartFont	This object represents the font attributes (such as font name, font size, and color) for a chart object.
Excel.ChartFormatString	Represents the substring in chart related objects that contain text, like a `ChartTitle` object or `ChartAxisTitle` object.
Excel.ChartGridlines	Represents major or minor gridlines on a chart axis.
Excel.ChartGridlinesFormat	Encapsulates the format properties for chart gridlines.
Excel.ChartLegend	Represents the legend in a chart.
Excel.ChartLegendEntry	Represents the legend entry in `legendEntryCollection`.
Excel.ChartLegendEntryCollection	Represents a collection of legend entries.
Excel.ChartLegendFormat	Encapsulates the format properties of a chart legend.
Excel.ChartLineFormat	Encapsulates the formatting options for line elements.
Excel.ChartMapOptions	Encapsulates the properties for a region map chart.
Excel.ChartPivotOptions	Encapsulates the options for the pivot chart.
Excel.ChartPlotArea	This object represents the attributes for a chart plot area.
Excel.ChartPlotAreaFormat	Represents the format properties for a chart plot area.
Excel.ChartPoint	Represents a point of a series in a chart.
Excel.ChartPointFormat	Represents the formatting object for chart points.
Excel.ChartPointsCollection	A collection of all the chart points within a series inside a chart.
Excel.ChartSeries	Represents a series in a chart.
Excel.ChartSeriesCollection	Represents a collection of chart series.
Excel.ChartSeriesFormat	Encapsulates the format properties for the chart series
Excel.ChartTitle	Represents a chart title object of a chart.
Excel.ChartTitleFormat	Provides access to the formatting options for a chart title.
Excel.ChartTrendline	This object represents the attributes for a chart trendline object.
Excel.ChartTrendlineCollection	Represents a collection of chart trendlines.
Excel.ChartTrendlineFormat	Represents the format properties for the chart trendline.
Excel.ChartTrendlineLabel	This object represents the attributes for a chart trendline label object.
Excel.ChartTrendlineLabelFormat	Encapsulates the format properties for the chart trendline label.
Excel.ColorScaleConditionalFormat	Represents the color scale criteria for conditional formatting.
Excel.Comment	Represents a comment in the workbook.
Excel.CommentCollection	Represents a collection of comment objects that are part of the workbook.
Excel.CommentReply	Represents a comment reply in the workbook.
Excel.CommentReplyCollection	Represents a collection of comment reply objects that are part of the comment.
Excel.ConditionalDataBarNegativeFormat	Represents a conditional format for the negative side of the data bar.
Excel.ConditionalDataBarPositiveFormat	Represents a conditional format for the positive side of the data bar.
Excel.ConditionalFormat	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.
Excel.ConditionalFormatCollection	Represents a collection of all the conditional formats that are overlap the range.
Excel.ConditionalFormatRule	Represents a rule, for all traditional rule/format pairings.
Excel.ConditionalRangeBorder	Represents the border of an object.
Excel.ConditionalRangeBorderCollection	Represents the border objects that make up range border.
Excel.ConditionalRangeFill	Represents the background of a conditional range object.
Excel.ConditionalRangeFont	This object represents the font attributes (font style, color, etc.) for an object.
Excel.ConditionalRangeFormat	A format object encapsulating the conditional formats range's font, fill, borders, and other properties.
Excel.CultureInfo	Provides information based on current system culture settings. This includes the culture names, number formatting, and other culturally dependent settings.
Excel.CustomConditionalFormat	Represents a custom conditional format type.
Excel.CustomProperty	Represents a custom property.
Excel.CustomPropertyCollection	Contains the collection of custom properties.
Excel.CustomXmlPart	Represents a custom XML part object in a workbook.
Excel.CustomXmlPartCollection	A collection of custom XML parts.
Excel.CustomXmlPartScopedCollection	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.
Excel.DataBarConditionalFormat	Represents an Excel conditional data bar type.
Excel.DataConnectionCollection	Represents a collection of all the data connections that are part of the workbook.
Excel.DataPivotHierarchy	Represents the Excel DataPivotHierarchy.
Excel.DataPivotHierarchyCollection	Represents a collection of DataPivotHierarchy items associated with the PivotTable.
Excel.DataValidation	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.
Excel.DatetimeFormatInfo	Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.
Excel.DocumentProperties	Represents workbook properties.
Excel.Filter	Manages the filtering of a table's column.
Excel.FilterPivotHierarchy	Represents the Excel FilterPivotHierarchy.
Excel.FilterPivotHierarchyCollection	Represents a collection of FilterPivotHierarchy items associated with the PivotTable.
Excel.FormatProtection	Represents the format protection of a range object.
Excel.FunctionResult	An object containing the result of a function-evaluation operation
Excel.Functions	An object for evaluating Excel functions.
Excel.GeometricShape	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.
Excel.GroupShapeCollection	Represents the shape collection inside a shape group.
Excel.HeaderFooter
Excel.HeaderFooterGroup
Excel.IconSetConditionalFormat	Represents an icon set criteria for conditional formatting.
Excel.Image	Represents an image in the worksheet. To get the corresponding `Shape` object, use `Image.shape`.
Excel.IterativeCalculation	Represents the iterative calculation settings.
Excel.Line	Represents a line inside a worksheet. To get the corresponding `Shape` object, use `Line.shape`.
Excel.NamedItem	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.
Excel.NamedItemArrayValues	Represents an object containing values and types of a named item.
Excel.NamedItemCollection	A collection of all the `NamedItem` objects that are part of the workbook or worksheet, depending on how it was reached.
Excel.NumberFormatInfo	Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.
Excel.PageBreak
Excel.PageBreakCollection
Excel.PageLayout	Represents layout and print settings that are not dependent on any printer-specific implementation. These settings include margins, orientation, page numbering, title rows, and print area.
Excel.PivotField	Represents the Excel PivotField.
Excel.PivotFieldCollection	Represents a collection of all the PivotFields that are part of a PivotTable's hierarchy.
Excel.PivotHierarchy	Represents the Excel PivotHierarchy.
Excel.PivotHierarchyCollection	Represents a collection of all the PivotHierarchies that are part of the PivotTable.
Excel.PivotItem	Represents the Excel PivotItem.
Excel.PivotItemCollection	Represents a collection of all the PivotItems related to their parent PivotField.
Excel.PivotLayout	Represents the visual layout of the PivotTable.
Excel.PivotTable	Represents an Excel PivotTable. To learn more about the PivotTable object model, read Work with PivotTables using the Excel JavaScript API.
Excel.PivotTableCollection	Represents a collection of all the PivotTables that are part of the workbook or worksheet.
Excel.PivotTableScopedCollection	Represents a scoped collection of PivotTables. The PivotTables are sorted based on the location of the PivotTable's top-left corner. They are ordered top-to-bottom and then left-to-right.
Excel.PivotTableStyle	Represents a PivotTable style, which defines style elements by PivotTable region.
Excel.PivotTableStyleCollection	Represents a collection of PivotTable styles.
Excel.PresetCriteriaConditionalFormat	Represents the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.
Excel.Query	Represents a Power Query query.
Excel.QueryCollection	Represents the collection of queries in the workbook.
Excel.Range	Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells. To learn more about how ranges are used throughout the API, start with Ranges in the Excel JavaScript API.
Excel.RangeAreas	`RangeAreas` represents a collection of one or more rectangular ranges in the same worksheet. To learn how to use discontiguous ranges, read Work with multiple ranges simultaneously in Excel add-ins.
Excel.RangeAreasCollection	Contains the collection of cross-workbook level ranges.
Excel.RangeBorder	Represents the border of an object.
Excel.RangeBorderCollection	Represents the border objects that make up the range border.
Excel.RangeCollection
Excel.RangeFill	Represents the background of a range object.
Excel.RangeFont	This object represents the font attributes (font name, font size, color, etc.) for an object.
Excel.RangeFormat	A format object encapsulating the range's font, fill, borders, alignment, and other properties.
Excel.RangeSort	Manages sorting operations on `Range` objects.
Excel.RangeView	RangeView represents a set of visible cells of the parent range.
Excel.RangeViewCollection	Represents a collection of `RangeView` objects.
Excel.RemoveDuplicatesResult	Represents the results from `Range.removeDuplicates`.
Excel.RequestContext	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.
Excel.RowColumnPivotHierarchy	Represents the Excel RowColumnPivotHierarchy.
Excel.RowColumnPivotHierarchyCollection	Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.
Excel.Runtime	Represents the Excel Runtime class.
Excel.Setting	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.
Excel.SettingCollection	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.
Excel.Shape	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.
Excel.ShapeCollection	Represents a collection of all the shapes in the worksheet.
Excel.ShapeFill	Represents the fill formatting of a shape object.
Excel.ShapeFont	Represents the font attributes, such as font name, font size, and color, for a shape's `TextRange` object.
Excel.ShapeGroup	Represents a shape group inside a worksheet. To get the corresponding `Shape` object, use `ShapeGroup.shape`.
Excel.ShapeLineFormat	Represents the line formatting for the shape object. For images and geometric shapes, line formatting represents the border of the shape.
Excel.Slicer	Represents a `Slicer` object in the workbook.
Excel.SlicerCollection	Represents a collection of all the slicer objects in the workbook or a worksheet.
Excel.SlicerItem	Represents a slicer item in a slicer.
Excel.SlicerItemCollection	Represents a collection of all the slicer item objects in the slicer.
Excel.SlicerStyle	Represents a slicer style, which defines style elements by region of the slicer.
Excel.SlicerStyleCollection	Represents a collection of `SlicerStyle` objects.
Excel.Style	An object encapsulating a style's format and other properties.
Excel.StyleCollection	Represents a collection of all the styles.
Excel.Table	Represents an Excel table. To learn more about the table object model, read Work with tables using the Excel JavaScript API.
Excel.TableCollection	Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.
Excel.TableColumn	Represents a column in a table.
Excel.TableColumnCollection	Represents a collection of all the columns that are part of the table.
Excel.TableRow	Represents a row in a table. Note that unlike ranges or columns, which will adjust if new rows or columns are added before them, a `TableRow` object represents 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.
Excel.TableRowCollection	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 or columns are added before them, a `TableRow` object represents 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.
Excel.TableScopedCollection	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.
Excel.TableSort	Manages sorting operations on `Table` objects.
Excel.TableStyle	Represents a table style, which defines the style elements by region of the table.
Excel.TableStyleCollection	Represents a collection of table styles.
Excel.TextConditionalFormat	Represents a specific text conditional format.
Excel.TextFrame	Represents the text frame of a shape object.
Excel.TextRange	Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.
Excel.TimelineStyle	Represents a `TimelineStyle`, which defines style elements by region in the timeline.
Excel.TimelineStyleCollection	Represents a collection of timeline styles.
Excel.TopBottomConditionalFormat	Represents a top/bottom conditional format.
Excel.Workbook	Workbook is the top level object which contains related workbook objects such as worksheets, tables, and ranges. To learn more about the workbook object model, read Work with workbooks using the Excel JavaScript API.
Excel.WorkbookCreated	The `WorkbookCreated` object is the top level object created by `Application.CreateWorkbook`. A `WorkbookCreated` object is a special Workbook object.
Excel.WorkbookProtection	Represents the protection of a workbook object.
Excel.WorkbookRangeAreas	Represents a collection of one or more rectangular ranges in multiple worksheets.
Excel.Worksheet	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.
Excel.WorksheetCollection	Represents a collection of worksheet objects that are part of the workbook.
Excel.WorksheetCustomProperty	Represents a worksheet-level custom property.
Excel.WorksheetCustomPropertyCollection	Contains the collection of worksheet-level custom property.
Excel.WorksheetFreezePanes
Excel.WorksheetProtection	Represents the protection of a worksheet object.

Interfaces

Excel.ArrayCellValue	Represents a 2D array of cell values.
Excel.BasicDataValidation	Represents the basic type data validation criteria.
Excel.BindingDataChangedEventArgs	Provides information about the binding that raised the data changed event.
Excel.BindingSelectionChangedEventArgs	Provides information about the selection that raised the selection changed event. Note*: If multiple, discontiguous cells are selected, `Binding.onSelectionChanged` only reports row and column information for one selection. Use `Worksheet.onSelectionChanged` for multiple selected ranges.
Excel.BlockedErrorCellValue	Represents the value of a cell containing a #BLOCKED! error.
Excel.BooleanCellValue	Represents the value of a cell containing a boolean.
Excel.BusyErrorCellValue	Represents the value of a cell containing a #BUSY! error.
Excel.CalcErrorCellValue	Represents the value of a cell containing a #CALC! error.
Excel.CardLayoutListSection	Represents a section of a card that is arranged as a list in card view.
Excel.CardLayoutPropertyReference	Represents a reference to a property used by the card layout.
Excel.CardLayoutSectionStandardProperties	Properties of a card layout relevant to most card layouts.
Excel.CardLayoutStandardProperties	Properties of a card layout relevant to most card layouts.
Excel.CardLayoutTableSection	Represents a section of a card that is arranged as a table in card view.
Excel.CellBorder	Represents the properties of a single border returned by `getCellProperties`, `getRowProperties`, and `getColumnProperties`, or the border property input parameter of `setCellProperties`, `setRowProperties`, and `setColumnProperties`.
Excel.CellBorderCollection	Represents the `format.borders` properties of `getCellProperties`, `getRowProperties`, and `getColumnProperties`, or the `format.borders` input parameter of `setCellProperties`, `setRowProperties`, and `setColumnProperties`.
Excel.CellProperties	Represents the returned properties of getCellProperties. [ API set: ExcelApi 1.9 ]
Excel.CellPropertiesBorderLoadOptions	Specifies which properties to load on the `format.borders` object.
Excel.CellPropertiesFill	Represents the `format.fill` properties of `getCellProperties`, `getRowProperties`, and `getColumnProperties` or the `format.fill` input parameter of `setCellProperties`, `setRowProperties`, and `setColumnProperties`.
Excel.CellPropertiesFillLoadOptions	Specifies which properties to load on the `format.fill` object.
Excel.CellPropertiesFont	Represents the `format.font` properties of `getCellProperties`, `getRowProperties`, and `getColumnProperties`, or the `format.font` input parameter of `setCellProperties`, `setRowProperties`, and `setColumnProperties`.
Excel.CellPropertiesFontLoadOptions	Specifies which properties to load on the `format.font` object.
Excel.CellPropertiesFormat	Represents the returned format properties of getCellProperties or format input parameter of setCellProperties. [ API set: ExcelApi 1.9 ]
Excel.CellPropertiesFormatLoadOptions	Represents which properties to load on the format object. [ API set: ExcelApi 1.9 ]
Excel.CellPropertiesLoadOptions	Represents which cell properties to load, when used as part of a "range.getCellProperties" method. [ API set: ExcelApi 1.9 ]
Excel.CellPropertiesProtection	Represents the `format.protection` properties of `getCellProperties`, `getRowProperties`, and `getColumnProperties`, or the `format.protection` input parameter of `setCellProperties`, `setRowProperties`, and `setColumnProperties`.
Excel.CellValueAttributionAttributes	The attribution attributes object represents the set of details that can be used to describe where information came from, if the information comes from a public source.
Excel.CellValueExtraProperties	These extra properties may appear on a `CellValue` and provide information about that `CellValue`, but the extra properties are not part of the value in the cell.
Excel.CellValuePropertyMetadata	Metadata about a property in `EntityCellValue.properties`.
Excel.CellValuePropertyMetadataExclusions	Represents the exclusion of a property in `EntityCellValue.properties` from features of Excel.
Excel.CellValueProviderAttributes	The provider attributes object represents the set of details used in card view to provide specified branding information for a `CellValue` type that supports provider attributes.
Excel.ChangedEventDetail	Provides information about the details of a `WorksheetChangedEvent` or `TableChangedEvent`.
Excel.ChangeDirectionState	Represents the direction that existing or remaining cells in a worksheet will shift when cells are inserted into or deleted from a worksheet.
Excel.ChartActivatedEventArgs	Provides information about the chart that raised the activated event.
Excel.ChartAddedEventArgs	Provides information about the chart that raised the added event.
Excel.ChartDeactivatedEventArgs	Provides information about the chart that raised the deactivated event.
Excel.ChartDeletedEventArgs	Provides information about the chart that raised the deleted event.
Excel.ColumnProperties	Represents the returned properties of getColumnProperties. [ API set: ExcelApi 1.9 ]
Excel.ColumnPropertiesLoadOptions	Represents which column properties to load, when used as part of a "range.getColumnProperties" method. [ API set: ExcelApi 1.9 ]
Excel.CommentAddedEventArgs	Provides information about the comments that raised the comment added event.
Excel.CommentChangedEventArgs	Occurs when existing comments are changed.
Excel.CommentDeletedEventArgs	Provides information about the comments that raised the comment deleted event.
Excel.CommentDetail	A structure for the comment ID and IDs of its related replies.
Excel.CommentMention	Represents the entity that is mentioned in comments.
Excel.CommentRichContent	Represents the content contained within a comment or comment reply. Rich content incudes the text string and any other objects contained within the comment body, such as mentions.
Excel.ConditionalCellValueRule	Represents a cell value conditional format rule.
Excel.ConditionalColorScaleCriteria	Represents the criteria of the color scale.
Excel.ConditionalColorScaleCriterion	Represents a color scale criterion which contains a type, value, and a color.
Excel.ConditionalDataBarRule	Represents a rule-type for a data bar.
Excel.ConditionalIconCriterion	Represents an icon criterion which contains a type, value, an operator, and an optional custom icon, if not using an icon set.
Excel.ConditionalPresetCriteriaRule	Represents the preset criteria conditional format rule.
Excel.ConditionalTextComparisonRule	Represents a cell value conditional format rule.
Excel.ConditionalTopBottomRule	Represents the rule of the top/bottom conditional format.
Excel.ConnectErrorCellValue	Represents the value of a cell containing a #CONNECT! error.
Excel.CustomDataValidation	Represents the custom data validation criteria.
Excel.DataValidationErrorAlert	Represents the error alert properties for the data validation.
Excel.DataValidationPrompt	Represents the user prompt properties for the data validation.
Excel.DataValidationRule	A data validation rule contains different types of data validation. You can only use one of them at a time according the `Excel.DataValidationType`.
Excel.DateTimeDataValidation	Represents the date data validation criteria.
Excel.Div0ErrorCellValue	Represents the value of a cell containing a #DIV/0! error.
Excel.DoubleCellValue	Represents the value of a cell containing a double.
Excel.EmptyCellValue	Represents the value of a cell that's empty and has no formulas or data.
Excel.EntityCardLayout	Represents a card layout that is best used for an entity.
Excel.EntityCellValue	Represents a set of properties without a schema or defined structure.
Excel.EntityCompactLayout	The compact layout properties for an entity.
Excel.EntityPropertyExtraProperties	Properties used by `CellValueAndPropertyMetadata`. These properties refer to the metadata and not to a `CellValue`.
Excel.EntityViewLayouts	Represents layout information for various views of the entity.
Excel.ExternalErrorCellValue	Represents the value of a cell containing an #EXTERNAL! error.
Excel.FieldErrorCellValue	Represents the value of a cell containing a #FIELD! error.
Excel.FilterCriteria	Represents the filtering criteria applied to a column.
Excel.FilterDatetime	Represents how to filter a date when filtering on values.
Excel.FiveArrowsGraySet	[ API set: ExcelApi 1.2 ]
Excel.FiveArrowsSet	[ API set: ExcelApi 1.2 ]
Excel.FiveBoxesSet	[ API set: ExcelApi 1.2 ]
Excel.FiveQuartersSet	[ API set: ExcelApi 1.2 ]
Excel.FiveRatingSet	[ API set: ExcelApi 1.2 ]
Excel.FormattedNumberCellValue	Represents the value of a cell containing a number with a format string. Number format strings must conform to Excel guidelines. To learn more, see Review guidelines for customizing a number format. In this scenario, the format is applied to the value and not to the cell, so the value retains its format string throughout calculation.
Excel.FormulaChangedEventDetail	Provides information about a changed formula during a formula changed event.
Excel.FourArrowsGraySet	[ API set: ExcelApi 1.2 ]
Excel.FourArrowsSet	[ API set: ExcelApi 1.2 ]
Excel.FourRatingSet	[ API set: ExcelApi 1.2 ]
Excel.FourRedToBlackSet	[ API set: ExcelApi 1.2 ]
Excel.FourTrafficLightsSet	[ API set: ExcelApi 1.2 ]
Excel.GettingDataErrorCellValue	Represents the value of a cell containing a #GETTING_DATA error.
Excel.Icon	Represents a cell icon.
Excel.IconCollections	[ API set: ExcelApi 1.2 ]
Excel.InsertWorksheetOptions	The options that define which worksheets to insert and where in the workbook the new worksheets will be inserted.
Excel.Interfaces.AllowEditRangeCollectionData	An interface describing the data returned by calling `allowEditRangeCollection.toJSON()`.
Excel.Interfaces.AllowEditRangeCollectionUpdateData	An interface for updating data on the `AllowEditRangeCollection` object, for use in `allowEditRangeCollection.set({ ... })`.
Excel.Interfaces.AllowEditRangeData	An interface describing the data returned by calling `allowEditRange.toJSON()`.
Excel.Interfaces.AllowEditRangeUpdateData	An interface for updating data on the `AllowEditRange` object, for use in `allowEditRange.set({ ... })`.
Excel.Interfaces.ApplicationData	An interface describing the data returned by calling `application.toJSON()`.
Excel.Interfaces.ApplicationLoadOptions	Represents the Excel application that manages the workbook.
Excel.Interfaces.ApplicationUpdateData	An interface for updating data on the `Application` object, for use in `application.set({ ... })`.
Excel.Interfaces.AutoFilterData	An interface describing the data returned by calling `autoFilter.toJSON()`.
Excel.Interfaces.AutoFilterLoadOptions	Represents the `AutoFilter` object. AutoFilter turns the values in Excel column into specific filters based on the cell contents.
Excel.Interfaces.BindingCollectionData	An interface describing the data returned by calling `bindingCollection.toJSON()`.
Excel.Interfaces.BindingCollectionLoadOptions	Represents the collection of all the binding objects that are part of the workbook.
Excel.Interfaces.BindingCollectionUpdateData	An interface for updating data on the `BindingCollection` object, for use in `bindingCollection.set({ ... })`.
Excel.Interfaces.BindingData	An interface describing the data returned by calling `binding.toJSON()`.
Excel.Interfaces.BindingLoadOptions	Represents an Office.js binding that is defined in the workbook.
Excel.Interfaces.CellValueConditionalFormatData	An interface describing the data returned by calling `cellValueConditionalFormat.toJSON()`.
Excel.Interfaces.CellValueConditionalFormatLoadOptions	Represents a cell value conditional format.
Excel.Interfaces.CellValueConditionalFormatUpdateData	An interface for updating data on the `CellValueConditionalFormat` object, for use in `cellValueConditionalFormat.set({ ... })`.
Excel.Interfaces.ChartAreaFormatData	An interface describing the data returned by calling `chartAreaFormat.toJSON()`.
Excel.Interfaces.ChartAreaFormatLoadOptions	Encapsulates the format properties for the overall chart area.
Excel.Interfaces.ChartAreaFormatUpdateData	An interface for updating data on the `ChartAreaFormat` object, for use in `chartAreaFormat.set({ ... })`.
Excel.Interfaces.ChartAxesData	An interface describing the data returned by calling `chartAxes.toJSON()`.
Excel.Interfaces.ChartAxesLoadOptions	Represents the chart axes.
Excel.Interfaces.ChartAxesUpdateData	An interface for updating data on the `ChartAxes` object, for use in `chartAxes.set({ ... })`.
Excel.Interfaces.ChartAxisData	An interface describing the data returned by calling `chartAxis.toJSON()`.
Excel.Interfaces.ChartAxisFormatData	An interface describing the data returned by calling `chartAxisFormat.toJSON()`.
Excel.Interfaces.ChartAxisFormatLoadOptions	Encapsulates the format properties for the chart axis.
Excel.Interfaces.ChartAxisFormatUpdateData	An interface for updating data on the `ChartAxisFormat` object, for use in `chartAxisFormat.set({ ... })`.
Excel.Interfaces.ChartAxisLoadOptions	Represents a single axis in a chart.
Excel.Interfaces.ChartAxisTitleData	An interface describing the data returned by calling `chartAxisTitle.toJSON()`.
Excel.Interfaces.ChartAxisTitleFormatData	An interface describing the data returned by calling `chartAxisTitleFormat.toJSON()`.
Excel.Interfaces.ChartAxisTitleFormatLoadOptions	Represents the chart axis title formatting.
Excel.Interfaces.ChartAxisTitleFormatUpdateData	An interface for updating data on the `ChartAxisTitleFormat` object, for use in `chartAxisTitleFormat.set({ ... })`.
Excel.Interfaces.ChartAxisTitleLoadOptions	Represents the title of a chart axis.
Excel.Interfaces.ChartAxisTitleUpdateData	An interface for updating data on the `ChartAxisTitle` object, for use in `chartAxisTitle.set({ ... })`.
Excel.Interfaces.ChartAxisUpdateData	An interface for updating data on the `ChartAxis` object, for use in `chartAxis.set({ ... })`.
Excel.Interfaces.ChartBinOptionsData	An interface describing the data returned by calling `chartBinOptions.toJSON()`.
Excel.Interfaces.ChartBinOptionsLoadOptions	Encapsulates the bin options for histogram charts and pareto charts.
Excel.Interfaces.ChartBinOptionsUpdateData	An interface for updating data on the `ChartBinOptions` object, for use in `chartBinOptions.set({ ... })`.
Excel.Interfaces.ChartBorderData	An interface describing the data returned by calling `chartBorder.toJSON()`.
Excel.Interfaces.ChartBorderLoadOptions	Represents the border formatting of a chart element.
Excel.Interfaces.ChartBorderUpdateData	An interface for updating data on the `ChartBorder` object, for use in `chartBorder.set({ ... })`.
Excel.Interfaces.ChartBoxwhiskerOptionsData	An interface describing the data returned by calling `chartBoxwhiskerOptions.toJSON()`.
Excel.Interfaces.ChartBoxwhiskerOptionsLoadOptions	Represents the properties of a box and whisker chart.
Excel.Interfaces.ChartBoxwhiskerOptionsUpdateData	An interface for updating data on the `ChartBoxwhiskerOptions` object, for use in `chartBoxwhiskerOptions.set({ ... })`.
Excel.Interfaces.ChartCollectionData	An interface describing the data returned by calling `chartCollection.toJSON()`.
Excel.Interfaces.ChartCollectionLoadOptions	A collection of all the chart objects on a worksheet.
Excel.Interfaces.ChartCollectionUpdateData	An interface for updating data on the `ChartCollection` object, for use in `chartCollection.set({ ... })`.
Excel.Interfaces.ChartData	An interface describing the data returned by calling `chart.toJSON()`.
Excel.Interfaces.ChartDataLabelData	An interface describing the data returned by calling `chartDataLabel.toJSON()`.
Excel.Interfaces.ChartDataLabelFormatData	An interface describing the data returned by calling `chartDataLabelFormat.toJSON()`.
Excel.Interfaces.ChartDataLabelFormatLoadOptions	Encapsulates the format properties for the chart data labels.
Excel.Interfaces.ChartDataLabelFormatUpdateData	An interface for updating data on the `ChartDataLabelFormat` object, for use in `chartDataLabelFormat.set({ ... })`.
Excel.Interfaces.ChartDataLabelLoadOptions	Represents the data label of a chart point.
Excel.Interfaces.ChartDataLabelsData	An interface describing the data returned by calling `chartDataLabels.toJSON()`.
Excel.Interfaces.ChartDataLabelsLoadOptions	Represents a collection of all the data labels on a chart point.
Excel.Interfaces.ChartDataLabelsUpdateData	An interface for updating data on the `ChartDataLabels` object, for use in `chartDataLabels.set({ ... })`.
Excel.Interfaces.ChartDataLabelUpdateData	An interface for updating data on the `ChartDataLabel` object, for use in `chartDataLabel.set({ ... })`.
Excel.Interfaces.ChartDataTableData	An interface describing the data returned by calling `chartDataTable.toJSON()`.
Excel.Interfaces.ChartDataTableFormatData	An interface describing the data returned by calling `chartDataTableFormat.toJSON()`.
Excel.Interfaces.ChartDataTableFormatLoadOptions	Represents the format of a chart data table.
Excel.Interfaces.ChartDataTableFormatUpdateData	An interface for updating data on the `ChartDataTableFormat` object, for use in `chartDataTableFormat.set({ ... })`.
Excel.Interfaces.ChartDataTableLoadOptions	Represents the data table object of a chart.
Excel.Interfaces.ChartDataTableUpdateData	An interface for updating data on the `ChartDataTable` object, for use in `chartDataTable.set({ ... })`.
Excel.Interfaces.ChartErrorBarsData	An interface describing the data returned by calling `chartErrorBars.toJSON()`.
Excel.Interfaces.ChartErrorBarsFormatData	An interface describing the data returned by calling `chartErrorBarsFormat.toJSON()`.
Excel.Interfaces.ChartErrorBarsFormatLoadOptions	Encapsulates the format properties for chart error bars.
Excel.Interfaces.ChartErrorBarsFormatUpdateData	An interface for updating data on the `ChartErrorBarsFormat` object, for use in `chartErrorBarsFormat.set({ ... })`.
Excel.Interfaces.ChartErrorBarsLoadOptions	This object represents the attributes for a chart's error bars.
Excel.Interfaces.ChartErrorBarsUpdateData	An interface for updating data on the `ChartErrorBars` object, for use in `chartErrorBars.set({ ... })`.
Excel.Interfaces.ChartFontData	An interface describing the data returned by calling `chartFont.toJSON()`.
Excel.Interfaces.ChartFontLoadOptions	This object represents the font attributes (such as font name, font size, and color) for a chart object.
Excel.Interfaces.ChartFontUpdateData	An interface for updating data on the `ChartFont` object, for use in `chartFont.set({ ... })`.
Excel.Interfaces.ChartFormatStringData	An interface describing the data returned by calling `chartFormatString.toJSON()`.
Excel.Interfaces.ChartFormatStringLoadOptions	Represents the substring in chart related objects that contain text, like a `ChartTitle` object or `ChartAxisTitle` object.
Excel.Interfaces.ChartFormatStringUpdateData	An interface for updating data on the `ChartFormatString` object, for use in `chartFormatString.set({ ... })`.
Excel.Interfaces.ChartGridlinesData	An interface describing the data returned by calling `chartGridlines.toJSON()`.
Excel.Interfaces.ChartGridlinesFormatData	An interface describing the data returned by calling `chartGridlinesFormat.toJSON()`.
Excel.Interfaces.ChartGridlinesFormatLoadOptions	Encapsulates the format properties for chart gridlines.
Excel.Interfaces.ChartGridlinesFormatUpdateData	An interface for updating data on the `ChartGridlinesFormat` object, for use in `chartGridlinesFormat.set({ ... })`.
Excel.Interfaces.ChartGridlinesLoadOptions	Represents major or minor gridlines on a chart axis.
Excel.Interfaces.ChartGridlinesUpdateData	An interface for updating data on the `ChartGridlines` object, for use in `chartGridlines.set({ ... })`.
Excel.Interfaces.ChartLegendData	An interface describing the data returned by calling `chartLegend.toJSON()`.
Excel.Interfaces.ChartLegendEntryCollectionData	An interface describing the data returned by calling `chartLegendEntryCollection.toJSON()`.
Excel.Interfaces.ChartLegendEntryCollectionLoadOptions	Represents a collection of legend entries.
Excel.Interfaces.ChartLegendEntryCollectionUpdateData	An interface for updating data on the `ChartLegendEntryCollection` object, for use in `chartLegendEntryCollection.set({ ... })`.
Excel.Interfaces.ChartLegendEntryData	An interface describing the data returned by calling `chartLegendEntry.toJSON()`.
Excel.Interfaces.ChartLegendEntryLoadOptions	Represents the legend entry in `legendEntryCollection`.
Excel.Interfaces.ChartLegendEntryUpdateData	An interface for updating data on the `ChartLegendEntry` object, for use in `chartLegendEntry.set({ ... })`.
Excel.Interfaces.ChartLegendFormatData	An interface describing the data returned by calling `chartLegendFormat.toJSON()`.
Excel.Interfaces.ChartLegendFormatLoadOptions	Encapsulates the format properties of a chart legend.
Excel.Interfaces.ChartLegendFormatUpdateData	An interface for updating data on the `ChartLegendFormat` object, for use in `chartLegendFormat.set({ ... })`.
Excel.Interfaces.ChartLegendLoadOptions	Represents the legend in a chart.
Excel.Interfaces.ChartLegendUpdateData	An interface for updating data on the `ChartLegend` object, for use in `chartLegend.set({ ... })`.
Excel.Interfaces.ChartLineFormatData	An interface describing the data returned by calling `chartLineFormat.toJSON()`.
Excel.Interfaces.ChartLineFormatLoadOptions	Encapsulates the formatting options for line elements.
Excel.Interfaces.ChartLineFormatUpdateData	An interface for updating data on the `ChartLineFormat` object, for use in `chartLineFormat.set({ ... })`.
Excel.Interfaces.ChartLoadOptions	Represents a chart object in a workbook. To learn more about the chart object model, see Work with charts using the Excel JavaScript API.
Excel.Interfaces.ChartMapOptionsData	An interface describing the data returned by calling `chartMapOptions.toJSON()`.
Excel.Interfaces.ChartMapOptionsLoadOptions	Encapsulates the properties for a region map chart.
Excel.Interfaces.ChartMapOptionsUpdateData	An interface for updating data on the `ChartMapOptions` object, for use in `chartMapOptions.set({ ... })`.
Excel.Interfaces.ChartPivotOptionsData	An interface describing the data returned by calling `chartPivotOptions.toJSON()`.
Excel.Interfaces.ChartPivotOptionsLoadOptions	Encapsulates the options for the pivot chart.
Excel.Interfaces.ChartPivotOptionsUpdateData	An interface for updating data on the `ChartPivotOptions` object, for use in `chartPivotOptions.set({ ... })`.
Excel.Interfaces.ChartPlotAreaData	An interface describing the data returned by calling `chartPlotArea.toJSON()`.
Excel.Interfaces.ChartPlotAreaFormatData	An interface describing the data returned by calling `chartPlotAreaFormat.toJSON()`.
Excel.Interfaces.ChartPlotAreaFormatLoadOptions	Represents the format properties for a chart plot area.
Excel.Interfaces.ChartPlotAreaFormatUpdateData	An interface for updating data on the `ChartPlotAreaFormat` object, for use in `chartPlotAreaFormat.set({ ... })`.
Excel.Interfaces.ChartPlotAreaLoadOptions	This object represents the attributes for a chart plot area.
Excel.Interfaces.ChartPlotAreaUpdateData	An interface for updating data on the `ChartPlotArea` object, for use in `chartPlotArea.set({ ... })`.
Excel.Interfaces.ChartPointData	An interface describing the data returned by calling `chartPoint.toJSON()`.
Excel.Interfaces.ChartPointFormatData	An interface describing the data returned by calling `chartPointFormat.toJSON()`.
Excel.Interfaces.ChartPointFormatLoadOptions	Represents the formatting object for chart points.
Excel.Interfaces.ChartPointFormatUpdateData	An interface for updating data on the `ChartPointFormat` object, for use in `chartPointFormat.set({ ... })`.
Excel.Interfaces.ChartPointLoadOptions	Represents a point of a series in a chart.
Excel.Interfaces.ChartPointsCollectionData	An interface describing the data returned by calling `chartPointsCollection.toJSON()`.
Excel.Interfaces.ChartPointsCollectionLoadOptions	A collection of all the chart points within a series inside a chart.
Excel.Interfaces.ChartPointsCollectionUpdateData	An interface for updating data on the `ChartPointsCollection` object, for use in `chartPointsCollection.set({ ... })`.
Excel.Interfaces.ChartPointUpdateData	An interface for updating data on the `ChartPoint` object, for use in `chartPoint.set({ ... })`.
Excel.Interfaces.ChartSeriesCollectionData	An interface describing the data returned by calling `chartSeriesCollection.toJSON()`.
Excel.Interfaces.ChartSeriesCollectionLoadOptions	Represents a collection of chart series.
Excel.Interfaces.ChartSeriesCollectionUpdateData	An interface for updating data on the `ChartSeriesCollection` object, for use in `chartSeriesCollection.set({ ... })`.
Excel.Interfaces.ChartSeriesData	An interface describing the data returned by calling `chartSeries.toJSON()`.
Excel.Interfaces.ChartSeriesFormatData	An interface describing the data returned by calling `chartSeriesFormat.toJSON()`.
Excel.Interfaces.ChartSeriesFormatLoadOptions	Encapsulates the format properties for the chart series
Excel.Interfaces.ChartSeriesFormatUpdateData	An interface for updating data on the `ChartSeriesFormat` object, for use in `chartSeriesFormat.set({ ... })`.
Excel.Interfaces.ChartSeriesLoadOptions	Represents a series in a chart.
Excel.Interfaces.ChartSeriesUpdateData	An interface for updating data on the `ChartSeries` object, for use in `chartSeries.set({ ... })`.
Excel.Interfaces.ChartTitleData	An interface describing the data returned by calling `chartTitle.toJSON()`.
Excel.Interfaces.ChartTitleFormatData	An interface describing the data returned by calling `chartTitleFormat.toJSON()`.
Excel.Interfaces.ChartTitleFormatLoadOptions	Provides access to the formatting options for a chart title.
Excel.Interfaces.ChartTitleFormatUpdateData	An interface for updating data on the `ChartTitleFormat` object, for use in `chartTitleFormat.set({ ... })`.
Excel.Interfaces.ChartTitleLoadOptions	Represents a chart title object of a chart.
Excel.Interfaces.ChartTitleUpdateData	An interface for updating data on the `ChartTitle` object, for use in `chartTitle.set({ ... })`.
Excel.Interfaces.ChartTrendlineCollectionData	An interface describing the data returned by calling `chartTrendlineCollection.toJSON()`.
Excel.Interfaces.ChartTrendlineCollectionLoadOptions	Represents a collection of chart trendlines.
Excel.Interfaces.ChartTrendlineCollectionUpdateData	An interface for updating data on the `ChartTrendlineCollection` object, for use in `chartTrendlineCollection.set({ ... })`.
Excel.Interfaces.ChartTrendlineData	An interface describing the data returned by calling `chartTrendline.toJSON()`.
Excel.Interfaces.ChartTrendlineFormatData	An interface describing the data returned by calling `chartTrendlineFormat.toJSON()`.
Excel.Interfaces.ChartTrendlineFormatLoadOptions	Represents the format properties for the chart trendline.
Excel.Interfaces.ChartTrendlineFormatUpdateData	An interface for updating data on the `ChartTrendlineFormat` object, for use in `chartTrendlineFormat.set({ ... })`.
Excel.Interfaces.ChartTrendlineLabelData	An interface describing the data returned by calling `chartTrendlineLabel.toJSON()`.
Excel.Interfaces.ChartTrendlineLabelFormatData	An interface describing the data returned by calling `chartTrendlineLabelFormat.toJSON()`.
Excel.Interfaces.ChartTrendlineLabelFormatLoadOptions	Encapsulates the format properties for the chart trendline label.
Excel.Interfaces.ChartTrendlineLabelFormatUpdateData	An interface for updating data on the `ChartTrendlineLabelFormat` object, for use in `chartTrendlineLabelFormat.set({ ... })`.
Excel.Interfaces.ChartTrendlineLabelLoadOptions	This object represents the attributes for a chart trendline label object.
Excel.Interfaces.ChartTrendlineLabelUpdateData	An interface for updating data on the `ChartTrendlineLabel` object, for use in `chartTrendlineLabel.set({ ... })`.
Excel.Interfaces.ChartTrendlineLoadOptions	This object represents the attributes for a chart trendline object.
Excel.Interfaces.ChartTrendlineUpdateData	An interface for updating data on the `ChartTrendline` object, for use in `chartTrendline.set({ ... })`.
Excel.Interfaces.ChartUpdateData	An interface for updating data on the `Chart` object, for use in `chart.set({ ... })`.
Excel.Interfaces.CollectionLoadOptions	Provides ways to load properties of only a subset of members of a collection.
Excel.Interfaces.ColorScaleConditionalFormatData	An interface describing the data returned by calling `colorScaleConditionalFormat.toJSON()`.
Excel.Interfaces.ColorScaleConditionalFormatLoadOptions	Represents the color scale criteria for conditional formatting.
Excel.Interfaces.ColorScaleConditionalFormatUpdateData	An interface for updating data on the `ColorScaleConditionalFormat` object, for use in `colorScaleConditionalFormat.set({ ... })`.
Excel.Interfaces.CommentCollectionData	An interface describing the data returned by calling `commentCollection.toJSON()`.
Excel.Interfaces.CommentCollectionLoadOptions	Represents a collection of comment objects that are part of the workbook.
Excel.Interfaces.CommentCollectionUpdateData	An interface for updating data on the `CommentCollection` object, for use in `commentCollection.set({ ... })`.
Excel.Interfaces.CommentData	An interface describing the data returned by calling `comment.toJSON()`.
Excel.Interfaces.CommentLoadOptions	Represents a comment in the workbook.
Excel.Interfaces.CommentReplyCollectionData	An interface describing the data returned by calling `commentReplyCollection.toJSON()`.
Excel.Interfaces.CommentReplyCollectionLoadOptions	Represents a collection of comment reply objects that are part of the comment.
Excel.Interfaces.CommentReplyCollectionUpdateData	An interface for updating data on the `CommentReplyCollection` object, for use in `commentReplyCollection.set({ ... })`.
Excel.Interfaces.CommentReplyData	An interface describing the data returned by calling `commentReply.toJSON()`.
Excel.Interfaces.CommentReplyLoadOptions	Represents a comment reply in the workbook.
Excel.Interfaces.CommentReplyUpdateData	An interface for updating data on the `CommentReply` object, for use in `commentReply.set({ ... })`.
Excel.Interfaces.CommentUpdateData	An interface for updating data on the `Comment` object, for use in `comment.set({ ... })`.
Excel.Interfaces.ConditionalDataBarNegativeFormatData	An interface describing the data returned by calling `conditionalDataBarNegativeFormat.toJSON()`.
Excel.Interfaces.ConditionalDataBarNegativeFormatLoadOptions	Represents a conditional format for the negative side of the data bar.
Excel.Interfaces.ConditionalDataBarNegativeFormatUpdateData	An interface for updating data on the `ConditionalDataBarNegativeFormat` object, for use in `conditionalDataBarNegativeFormat.set({ ... })`.
Excel.Interfaces.ConditionalDataBarPositiveFormatData	An interface describing the data returned by calling `conditionalDataBarPositiveFormat.toJSON()`.
Excel.Interfaces.ConditionalDataBarPositiveFormatLoadOptions	Represents a conditional format for the positive side of the data bar.
Excel.Interfaces.ConditionalDataBarPositiveFormatUpdateData	An interface for updating data on the `ConditionalDataBarPositiveFormat` object, for use in `conditionalDataBarPositiveFormat.set({ ... })`.
Excel.Interfaces.ConditionalFormatCollectionData	An interface describing the data returned by calling `conditionalFormatCollection.toJSON()`.
Excel.Interfaces.ConditionalFormatCollectionLoadOptions	Represents a collection of all the conditional formats that are overlap the range.
Excel.Interfaces.ConditionalFormatCollectionUpdateData	An interface for updating data on the `ConditionalFormatCollection` object, for use in `conditionalFormatCollection.set({ ... })`.
Excel.Interfaces.ConditionalFormatData	An interface describing the data returned by calling `conditionalFormat.toJSON()`.
Excel.Interfaces.ConditionalFormatLoadOptions	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.
Excel.Interfaces.ConditionalFormatRuleData	An interface describing the data returned by calling `conditionalFormatRule.toJSON()`.
Excel.Interfaces.ConditionalFormatRuleLoadOptions	Represents a rule, for all traditional rule/format pairings.
Excel.Interfaces.ConditionalFormatRuleUpdateData	An interface for updating data on the `ConditionalFormatRule` object, for use in `conditionalFormatRule.set({ ... })`.
Excel.Interfaces.ConditionalFormatUpdateData	An interface for updating data on the `ConditionalFormat` object, for use in `conditionalFormat.set({ ... })`.
Excel.Interfaces.ConditionalRangeBorderCollectionData	An interface describing the data returned by calling `conditionalRangeBorderCollection.toJSON()`.
Excel.Interfaces.ConditionalRangeBorderCollectionLoadOptions	Represents the border objects that make up range border.
Excel.Interfaces.ConditionalRangeBorderCollectionUpdateData	An interface for updating data on the `ConditionalRangeBorderCollection` object, for use in `conditionalRangeBorderCollection.set({ ... })`.
Excel.Interfaces.ConditionalRangeBorderData	An interface describing the data returned by calling `conditionalRangeBorder.toJSON()`.
Excel.Interfaces.ConditionalRangeBorderLoadOptions	Represents the border of an object.
Excel.Interfaces.ConditionalRangeBorderUpdateData	An interface for updating data on the `ConditionalRangeBorder` object, for use in `conditionalRangeBorder.set({ ... })`.
Excel.Interfaces.ConditionalRangeFillData	An interface describing the data returned by calling `conditionalRangeFill.toJSON()`.
Excel.Interfaces.ConditionalRangeFillLoadOptions	Represents the background of a conditional range object.
Excel.Interfaces.ConditionalRangeFillUpdateData	An interface for updating data on the `ConditionalRangeFill` object, for use in `conditionalRangeFill.set({ ... })`.
Excel.Interfaces.ConditionalRangeFontData	An interface describing the data returned by calling `conditionalRangeFont.toJSON()`.
Excel.Interfaces.ConditionalRangeFontLoadOptions	This object represents the font attributes (font style, color, etc.) for an object.
Excel.Interfaces.ConditionalRangeFontUpdateData	An interface for updating data on the `ConditionalRangeFont` object, for use in `conditionalRangeFont.set({ ... })`.
Excel.Interfaces.ConditionalRangeFormatData	An interface describing the data returned by calling `conditionalRangeFormat.toJSON()`.
Excel.Interfaces.ConditionalRangeFormatLoadOptions	A format object encapsulating the conditional formats range's font, fill, borders, and other properties.
Excel.Interfaces.ConditionalRangeFormatUpdateData	An interface for updating data on the `ConditionalRangeFormat` object, for use in `conditionalRangeFormat.set({ ... })`.
Excel.Interfaces.CultureInfoData	An interface describing the data returned by calling `cultureInfo.toJSON()`.
Excel.Interfaces.CultureInfoLoadOptions	Provides information based on current system culture settings. This includes the culture names, number formatting, and other culturally dependent settings.
Excel.Interfaces.CustomConditionalFormatData	An interface describing the data returned by calling `customConditionalFormat.toJSON()`.
Excel.Interfaces.CustomConditionalFormatLoadOptions	Represents a custom conditional format type.
Excel.Interfaces.CustomConditionalFormatUpdateData	An interface for updating data on the `CustomConditionalFormat` object, for use in `customConditionalFormat.set({ ... })`.
Excel.Interfaces.CustomPropertyCollectionData	An interface describing the data returned by calling `customPropertyCollection.toJSON()`.
Excel.Interfaces.CustomPropertyCollectionLoadOptions	Contains the collection of custom properties.
Excel.Interfaces.CustomPropertyCollectionUpdateData	An interface for updating data on the `CustomPropertyCollection` object, for use in `customPropertyCollection.set({ ... })`.
Excel.Interfaces.CustomPropertyData	An interface describing the data returned by calling `customProperty.toJSON()`.
Excel.Interfaces.CustomPropertyLoadOptions	Represents a custom property.
Excel.Interfaces.CustomPropertyUpdateData	An interface for updating data on the `CustomProperty` object, for use in `customProperty.set({ ... })`.
Excel.Interfaces.CustomXmlPartCollectionData	An interface describing the data returned by calling `customXmlPartCollection.toJSON()`.
Excel.Interfaces.CustomXmlPartCollectionLoadOptions	A collection of custom XML parts.
Excel.Interfaces.CustomXmlPartCollectionUpdateData	An interface for updating data on the `CustomXmlPartCollection` object, for use in `customXmlPartCollection.set({ ... })`.
Excel.Interfaces.CustomXmlPartData	An interface describing the data returned by calling `customXmlPart.toJSON()`.
Excel.Interfaces.CustomXmlPartLoadOptions	Represents a custom XML part object in a workbook.
Excel.Interfaces.CustomXmlPartScopedCollectionData	An interface describing the data returned by calling `customXmlPartScopedCollection.toJSON()`.
Excel.Interfaces.CustomXmlPartScopedCollectionLoadOptions	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.
Excel.Interfaces.CustomXmlPartScopedCollectionUpdateData	An interface for updating data on the `CustomXmlPartScopedCollection` object, for use in `customXmlPartScopedCollection.set({ ... })`.
Excel.Interfaces.DataBarConditionalFormatData	An interface describing the data returned by calling `dataBarConditionalFormat.toJSON()`.
Excel.Interfaces.DataBarConditionalFormatLoadOptions	Represents an Excel conditional data bar type.
Excel.Interfaces.DataBarConditionalFormatUpdateData	An interface for updating data on the `DataBarConditionalFormat` object, for use in `dataBarConditionalFormat.set({ ... })`.
Excel.Interfaces.DataPivotHierarchyCollectionData	An interface describing the data returned by calling `dataPivotHierarchyCollection.toJSON()`.
Excel.Interfaces.DataPivotHierarchyCollectionLoadOptions	Represents a collection of DataPivotHierarchy items associated with the PivotTable.
Excel.Interfaces.DataPivotHierarchyCollectionUpdateData	An interface for updating data on the `DataPivotHierarchyCollection` object, for use in `dataPivotHierarchyCollection.set({ ... })`.
Excel.Interfaces.DataPivotHierarchyData	An interface describing the data returned by calling `dataPivotHierarchy.toJSON()`.
Excel.Interfaces.DataPivotHierarchyLoadOptions	Represents the Excel DataPivotHierarchy.
Excel.Interfaces.DataPivotHierarchyUpdateData	An interface for updating data on the `DataPivotHierarchy` object, for use in `dataPivotHierarchy.set({ ... })`.
Excel.Interfaces.DataValidationData	An interface describing the data returned by calling `dataValidation.toJSON()`.
Excel.Interfaces.DataValidationLoadOptions	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.
Excel.Interfaces.DataValidationUpdateData	An interface for updating data on the `DataValidation` object, for use in `dataValidation.set({ ... })`.
Excel.Interfaces.DatetimeFormatInfoData	An interface describing the data returned by calling `datetimeFormatInfo.toJSON()`.
Excel.Interfaces.DatetimeFormatInfoLoadOptions	Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.
Excel.Interfaces.DocumentPropertiesData	An interface describing the data returned by calling `documentProperties.toJSON()`.
Excel.Interfaces.DocumentPropertiesLoadOptions	Represents workbook properties.
Excel.Interfaces.DocumentPropertiesUpdateData	An interface for updating data on the `DocumentProperties` object, for use in `documentProperties.set({ ... })`.
Excel.Interfaces.FilterData	An interface describing the data returned by calling `filter.toJSON()`.
Excel.Interfaces.FilterLoadOptions	Manages the filtering of a table's column.
Excel.Interfaces.FilterPivotHierarchyCollectionData	An interface describing the data returned by calling `filterPivotHierarchyCollection.toJSON()`.
Excel.Interfaces.FilterPivotHierarchyCollectionLoadOptions	Represents a collection of FilterPivotHierarchy items associated with the PivotTable.
Excel.Interfaces.FilterPivotHierarchyCollectionUpdateData	An interface for updating data on the `FilterPivotHierarchyCollection` object, for use in `filterPivotHierarchyCollection.set({ ... })`.
Excel.Interfaces.FilterPivotHierarchyData	An interface describing the data returned by calling `filterPivotHierarchy.toJSON()`.
Excel.Interfaces.FilterPivotHierarchyLoadOptions	Represents the Excel FilterPivotHierarchy.
Excel.Interfaces.FilterPivotHierarchyUpdateData	An interface for updating data on the `FilterPivotHierarchy` object, for use in `filterPivotHierarchy.set({ ... })`.
Excel.Interfaces.FormatProtectionData	An interface describing the data returned by calling `formatProtection.toJSON()`.
Excel.Interfaces.FormatProtectionLoadOptions	Represents the format protection of a range object.
Excel.Interfaces.FormatProtectionUpdateData	An interface for updating data on the `FormatProtection` object, for use in `formatProtection.set({ ... })`.
Excel.Interfaces.FunctionResultData	An interface describing the data returned by calling `functionResult.toJSON()`.
Excel.Interfaces.FunctionResultLoadOptions	An object containing the result of a function-evaluation operation
Excel.Interfaces.GeometricShapeData	An interface describing the data returned by calling `geometricShape.toJSON()`.
Excel.Interfaces.GeometricShapeLoadOptions	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.
Excel.Interfaces.GroupShapeCollectionData	An interface describing the data returned by calling `groupShapeCollection.toJSON()`.
Excel.Interfaces.GroupShapeCollectionLoadOptions	Represents the shape collection inside a shape group.
Excel.Interfaces.GroupShapeCollectionUpdateData	An interface for updating data on the `GroupShapeCollection` object, for use in `groupShapeCollection.set({ ... })`.
Excel.Interfaces.HeaderFooterData	An interface describing the data returned by calling `headerFooter.toJSON()`.
Excel.Interfaces.HeaderFooterGroupData	An interface describing the data returned by calling `headerFooterGroup.toJSON()`.
Excel.Interfaces.HeaderFooterGroupLoadOptions
Excel.Interfaces.HeaderFooterGroupUpdateData	An interface for updating data on the `HeaderFooterGroup` object, for use in `headerFooterGroup.set({ ... })`.
Excel.Interfaces.HeaderFooterLoadOptions
Excel.Interfaces.HeaderFooterUpdateData	An interface for updating data on the `HeaderFooter` object, for use in `headerFooter.set({ ... })`.
Excel.Interfaces.IconSetConditionalFormatData	An interface describing the data returned by calling `iconSetConditionalFormat.toJSON()`.
Excel.Interfaces.IconSetConditionalFormatLoadOptions	Represents an icon set criteria for conditional formatting.
Excel.Interfaces.IconSetConditionalFormatUpdateData	An interface for updating data on the `IconSetConditionalFormat` object, for use in `iconSetConditionalFormat.set({ ... })`.
Excel.Interfaces.ImageData	An interface describing the data returned by calling `image.toJSON()`.
Excel.Interfaces.ImageLoadOptions	Represents an image in the worksheet. To get the corresponding `Shape` object, use `Image.shape`.
Excel.Interfaces.IterativeCalculationData	An interface describing the data returned by calling `iterativeCalculation.toJSON()`.
Excel.Interfaces.IterativeCalculationLoadOptions	Represents the iterative calculation settings.
Excel.Interfaces.IterativeCalculationUpdateData	An interface for updating data on the `IterativeCalculation` object, for use in `iterativeCalculation.set({ ... })`.
Excel.Interfaces.LineData	An interface describing the data returned by calling `line.toJSON()`.
Excel.Interfaces.LineLoadOptions	Represents a line inside a worksheet. To get the corresponding `Shape` object, use `Line.shape`.
Excel.Interfaces.LineUpdateData	An interface for updating data on the `Line` object, for use in `line.set({ ... })`.
Excel.Interfaces.LinkedWorkbookCollectionData	An interface describing the data returned by calling `linkedWorkbookCollection.toJSON()`.
Excel.Interfaces.LinkedWorkbookCollectionUpdateData	An interface for updating data on the `LinkedWorkbookCollection` object, for use in `linkedWorkbookCollection.set({ ... })`.
Excel.Interfaces.LinkedWorkbookData	An interface describing the data returned by calling `linkedWorkbook.toJSON()`.
Excel.Interfaces.NamedItemArrayValuesData	An interface describing the data returned by calling `namedItemArrayValues.toJSON()`.
Excel.Interfaces.NamedItemArrayValuesLoadOptions	Represents an object containing values and types of a named item.
Excel.Interfaces.NamedItemCollectionData	An interface describing the data returned by calling `namedItemCollection.toJSON()`.
Excel.Interfaces.NamedItemCollectionLoadOptions	A collection of all the `NamedItem` objects that are part of the workbook or worksheet, depending on how it was reached.
Excel.Interfaces.NamedItemCollectionUpdateData	An interface for updating data on the `NamedItemCollection` object, for use in `namedItemCollection.set({ ... })`.
Excel.Interfaces.NamedItemData	An interface describing the data returned by calling `namedItem.toJSON()`.
Excel.Interfaces.NamedItemLoadOptions	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.
Excel.Interfaces.NamedItemUpdateData	An interface for updating data on the `NamedItem` object, for use in `namedItem.set({ ... })`.
Excel.Interfaces.NamedSheetViewCollectionData	An interface describing the data returned by calling `namedSheetViewCollection.toJSON()`.
Excel.Interfaces.NamedSheetViewCollectionUpdateData	An interface for updating data on the `NamedSheetViewCollection` object, for use in `namedSheetViewCollection.set({ ... })`.
Excel.Interfaces.NamedSheetViewData	An interface describing the data returned by calling `namedSheetView.toJSON()`.
Excel.Interfaces.NamedSheetViewUpdateData	An interface for updating data on the `NamedSheetView` object, for use in `namedSheetView.set({ ... })`.
Excel.Interfaces.NumberFormatInfoData	An interface describing the data returned by calling `numberFormatInfo.toJSON()`.
Excel.Interfaces.NumberFormatInfoLoadOptions	Defines the culturally appropriate format of displaying numbers. This is based on current system culture settings.
Excel.Interfaces.PageBreakCollectionData	An interface describing the data returned by calling `pageBreakCollection.toJSON()`.
Excel.Interfaces.PageBreakCollectionLoadOptions
Excel.Interfaces.PageBreakCollectionUpdateData	An interface for updating data on the `PageBreakCollection` object, for use in `pageBreakCollection.set({ ... })`.
Excel.Interfaces.PageBreakData	An interface describing the data returned by calling `pageBreak.toJSON()`.
Excel.Interfaces.PageBreakLoadOptions
Excel.Interfaces.PageLayoutData	An interface describing the data returned by calling `pageLayout.toJSON()`.
Excel.Interfaces.PageLayoutLoadOptions	Represents layout and print settings that are not dependent on any printer-specific implementation. These settings include margins, orientation, page numbering, title rows, and print area.
Excel.Interfaces.PageLayoutUpdateData	An interface for updating data on the `PageLayout` object, for use in `pageLayout.set({ ... })`.
Excel.Interfaces.PivotFieldCollectionData	An interface describing the data returned by calling `pivotFieldCollection.toJSON()`.
Excel.Interfaces.PivotFieldCollectionLoadOptions	Represents a collection of all the PivotFields that are part of a PivotTable's hierarchy.
Excel.Interfaces.PivotFieldCollectionUpdateData	An interface for updating data on the `PivotFieldCollection` object, for use in `pivotFieldCollection.set({ ... })`.
Excel.Interfaces.PivotFieldData	An interface describing the data returned by calling `pivotField.toJSON()`.
Excel.Interfaces.PivotFieldLoadOptions	Represents the Excel PivotField.
Excel.Interfaces.PivotFieldUpdateData	An interface for updating data on the `PivotField` object, for use in `pivotField.set({ ... })`.
Excel.Interfaces.PivotHierarchyCollectionData	An interface describing the data returned by calling `pivotHierarchyCollection.toJSON()`.
Excel.Interfaces.PivotHierarchyCollectionLoadOptions	Represents a collection of all the PivotHierarchies that are part of the PivotTable.
Excel.Interfaces.PivotHierarchyCollectionUpdateData	An interface for updating data on the `PivotHierarchyCollection` object, for use in `pivotHierarchyCollection.set({ ... })`.
Excel.Interfaces.PivotHierarchyData	An interface describing the data returned by calling `pivotHierarchy.toJSON()`.
Excel.Interfaces.PivotHierarchyLoadOptions	Represents the Excel PivotHierarchy.
Excel.Interfaces.PivotHierarchyUpdateData	An interface for updating data on the `PivotHierarchy` object, for use in `pivotHierarchy.set({ ... })`.
Excel.Interfaces.PivotItemCollectionData	An interface describing the data returned by calling `pivotItemCollection.toJSON()`.
Excel.Interfaces.PivotItemCollectionLoadOptions	Represents a collection of all the PivotItems related to their parent PivotField.
Excel.Interfaces.PivotItemCollectionUpdateData	An interface for updating data on the `PivotItemCollection` object, for use in `pivotItemCollection.set({ ... })`.
Excel.Interfaces.PivotItemData	An interface describing the data returned by calling `pivotItem.toJSON()`.
Excel.Interfaces.PivotItemLoadOptions	Represents the Excel PivotItem.
Excel.Interfaces.PivotItemUpdateData	An interface for updating data on the `PivotItem` object, for use in `pivotItem.set({ ... })`.
Excel.Interfaces.PivotLayoutData	An interface describing the data returned by calling `pivotLayout.toJSON()`.
Excel.Interfaces.PivotLayoutLoadOptions	Represents the visual layout of the PivotTable.
Excel.Interfaces.PivotLayoutUpdateData	An interface for updating data on the `PivotLayout` object, for use in `pivotLayout.set({ ... })`.
Excel.Interfaces.PivotTableCollectionData	An interface describing the data returned by calling `pivotTableCollection.toJSON()`.
Excel.Interfaces.PivotTableCollectionLoadOptions	Represents a collection of all the PivotTables that are part of the workbook or worksheet.
Excel.Interfaces.PivotTableCollectionUpdateData	An interface for updating data on the `PivotTableCollection` object, for use in `pivotTableCollection.set({ ... })`.
Excel.Interfaces.PivotTableData	An interface describing the data returned by calling `pivotTable.toJSON()`.
Excel.Interfaces.PivotTableLoadOptions	Represents an Excel PivotTable. To learn more about the PivotTable object model, read Work with PivotTables using the Excel JavaScript API.
Excel.Interfaces.PivotTableScopedCollectionData	An interface describing the data returned by calling `pivotTableScopedCollection.toJSON()`.
Excel.Interfaces.PivotTableScopedCollectionLoadOptions	Represents a scoped collection of PivotTables. The PivotTables are sorted based on the location of the PivotTable's top-left corner. They are ordered top-to-bottom and then left-to-right.
Excel.Interfaces.PivotTableScopedCollectionUpdateData	An interface for updating data on the `PivotTableScopedCollection` object, for use in `pivotTableScopedCollection.set({ ... })`.
Excel.Interfaces.PivotTableStyleCollectionData	An interface describing the data returned by calling `pivotTableStyleCollection.toJSON()`.
Excel.Interfaces.PivotTableStyleCollectionLoadOptions	Represents a collection of PivotTable styles.
Excel.Interfaces.PivotTableStyleCollectionUpdateData	An interface for updating data on the `PivotTableStyleCollection` object, for use in `pivotTableStyleCollection.set({ ... })`.
Excel.Interfaces.PivotTableStyleData	An interface describing the data returned by calling `pivotTableStyle.toJSON()`.
Excel.Interfaces.PivotTableStyleLoadOptions	Represents a PivotTable style, which defines style elements by PivotTable region.
Excel.Interfaces.PivotTableStyleUpdateData	An interface for updating data on the `PivotTableStyle` object, for use in `pivotTableStyle.set({ ... })`.
Excel.Interfaces.PivotTableUpdateData	An interface for updating data on the `PivotTable` object, for use in `pivotTable.set({ ... })`.
Excel.Interfaces.PresetCriteriaConditionalFormatData	An interface describing the data returned by calling `presetCriteriaConditionalFormat.toJSON()`.
Excel.Interfaces.PresetCriteriaConditionalFormatLoadOptions	Represents the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror.
Excel.Interfaces.PresetCriteriaConditionalFormatUpdateData	An interface for updating data on the `PresetCriteriaConditionalFormat` object, for use in `presetCriteriaConditionalFormat.set({ ... })`.
Excel.Interfaces.QueryCollectionData	An interface describing the data returned by calling `queryCollection.toJSON()`.
Excel.Interfaces.QueryCollectionLoadOptions	Represents the collection of queries in the workbook.
Excel.Interfaces.QueryCollectionUpdateData	An interface for updating data on the `QueryCollection` object, for use in `queryCollection.set({ ... })`.
Excel.Interfaces.QueryData	An interface describing the data returned by calling `query.toJSON()`.
Excel.Interfaces.QueryLoadOptions	Represents a Power Query query.
Excel.Interfaces.RangeAreasCollectionData	An interface describing the data returned by calling `rangeAreasCollection.toJSON()`.
Excel.Interfaces.RangeAreasCollectionLoadOptions	Contains the collection of cross-workbook level ranges.
Excel.Interfaces.RangeAreasCollectionUpdateData	An interface for updating data on the `RangeAreasCollection` object, for use in `rangeAreasCollection.set({ ... })`.
Excel.Interfaces.RangeAreasData	An interface describing the data returned by calling `rangeAreas.toJSON()`.
Excel.Interfaces.RangeAreasLoadOptions	`RangeAreas` represents a collection of one or more rectangular ranges in the same worksheet. To learn how to use discontiguous ranges, read Work with multiple ranges simultaneously in Excel add-ins.
Excel.Interfaces.RangeAreasUpdateData	An interface for updating data on the `RangeAreas` object, for use in `rangeAreas.set({ ... })`.
Excel.Interfaces.RangeBorderCollectionData	An interface describing the data returned by calling `rangeBorderCollection.toJSON()`.
Excel.Interfaces.RangeBorderCollectionLoadOptions	Represents the border objects that make up the range border.
Excel.Interfaces.RangeBorderCollectionUpdateData	An interface for updating data on the `RangeBorderCollection` object, for use in `rangeBorderCollection.set({ ... })`.
Excel.Interfaces.RangeBorderData	An interface describing the data returned by calling `rangeBorder.toJSON()`.
Excel.Interfaces.RangeBorderLoadOptions	Represents the border of an object.
Excel.Interfaces.RangeBorderUpdateData	An interface for updating data on the `RangeBorder` object, for use in `rangeBorder.set({ ... })`.
Excel.Interfaces.RangeCollectionData	An interface describing the data returned by calling `rangeCollection.toJSON()`.
Excel.Interfaces.RangeCollectionLoadOptions
Excel.Interfaces.RangeCollectionUpdateData	An interface for updating data on the `RangeCollection` object, for use in `rangeCollection.set({ ... })`.
Excel.Interfaces.RangeData	An interface describing the data returned by calling `range.toJSON()`.
Excel.Interfaces.RangeFillData	An interface describing the data returned by calling `rangeFill.toJSON()`.
Excel.Interfaces.RangeFillLoadOptions	Represents the background of a range object.
Excel.Interfaces.RangeFillUpdateData	An interface for updating data on the `RangeFill` object, for use in `rangeFill.set({ ... })`.
Excel.Interfaces.RangeFontData	An interface describing the data returned by calling `rangeFont.toJSON()`.
Excel.Interfaces.RangeFontLoadOptions	This object represents the font attributes (font name, font size, color, etc.) for an object.
Excel.Interfaces.RangeFontUpdateData	An interface for updating data on the `RangeFont` object, for use in `rangeFont.set({ ... })`.
Excel.Interfaces.RangeFormatData	An interface describing the data returned by calling `rangeFormat.toJSON()`.
Excel.Interfaces.RangeFormatLoadOptions	A format object encapsulating the range's font, fill, borders, alignment, and other properties.
Excel.Interfaces.RangeFormatUpdateData	An interface for updating data on the `RangeFormat` object, for use in `rangeFormat.set({ ... })`.
Excel.Interfaces.RangeLoadOptions	Range represents a set of one or more contiguous cells such as a cell, a row, a column, or a block of cells. To learn more about how ranges are used throughout the API, start with Ranges in the Excel JavaScript API.
Excel.Interfaces.RangeUpdateData	An interface for updating data on the `Range` object, for use in `range.set({ ... })`.
Excel.Interfaces.RangeViewCollectionData	An interface describing the data returned by calling `rangeViewCollection.toJSON()`.
Excel.Interfaces.RangeViewCollectionLoadOptions	Represents a collection of `RangeView` objects.
Excel.Interfaces.RangeViewCollectionUpdateData	An interface for updating data on the `RangeViewCollection` object, for use in `rangeViewCollection.set({ ... })`.
Excel.Interfaces.RangeViewData	An interface describing the data returned by calling `rangeView.toJSON()`.
Excel.Interfaces.RangeViewLoadOptions	RangeView represents a set of visible cells of the parent range.
Excel.Interfaces.RangeViewUpdateData	An interface for updating data on the `RangeView` object, for use in `rangeView.set({ ... })`.
Excel.Interfaces.RemoveDuplicatesResultData	An interface describing the data returned by calling `removeDuplicatesResult.toJSON()`.
Excel.Interfaces.RemoveDuplicatesResultLoadOptions	Represents the results from `Range.removeDuplicates`.
Excel.Interfaces.RowColumnPivotHierarchyCollectionData	An interface describing the data returned by calling `rowColumnPivotHierarchyCollection.toJSON()`.
Excel.Interfaces.RowColumnPivotHierarchyCollectionLoadOptions	Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable.
Excel.Interfaces.RowColumnPivotHierarchyCollectionUpdateData	An interface for updating data on the `RowColumnPivotHierarchyCollection` object, for use in `rowColumnPivotHierarchyCollection.set({ ... })`.
Excel.Interfaces.RowColumnPivotHierarchyData	An interface describing the data returned by calling `rowColumnPivotHierarchy.toJSON()`.
Excel.Interfaces.RowColumnPivotHierarchyLoadOptions	Represents the Excel RowColumnPivotHierarchy.
Excel.Interfaces.RowColumnPivotHierarchyUpdateData	An interface for updating data on the `RowColumnPivotHierarchy` object, for use in `rowColumnPivotHierarchy.set({ ... })`.
Excel.Interfaces.RuntimeData	An interface describing the data returned by calling `runtime.toJSON()`.
Excel.Interfaces.RuntimeLoadOptions	Represents the Excel Runtime class.
Excel.Interfaces.RuntimeUpdateData	An interface for updating data on the `Runtime` object, for use in `runtime.set({ ... })`.
Excel.Interfaces.SettingCollectionData	An interface describing the data returned by calling `settingCollection.toJSON()`.
Excel.Interfaces.SettingCollectionLoadOptions	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.
Excel.Interfaces.SettingCollectionUpdateData	An interface for updating data on the `SettingCollection` object, for use in `settingCollection.set({ ... })`.
Excel.Interfaces.SettingData	An interface describing the data returned by calling `setting.toJSON()`.
Excel.Interfaces.SettingLoadOptions	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.
Excel.Interfaces.SettingUpdateData	An interface for updating data on the `Setting` object, for use in `setting.set({ ... })`.
Excel.Interfaces.ShapeCollectionData	An interface describing the data returned by calling `shapeCollection.toJSON()`.
Excel.Interfaces.ShapeCollectionLoadOptions	Represents a collection of all the shapes in the worksheet.
Excel.Interfaces.ShapeCollectionUpdateData	An interface for updating data on the `ShapeCollection` object, for use in `shapeCollection.set({ ... })`.
Excel.Interfaces.ShapeData	An interface describing the data returned by calling `shape.toJSON()`.
Excel.Interfaces.ShapeFillData	An interface describing the data returned by calling `shapeFill.toJSON()`.
Excel.Interfaces.ShapeFillLoadOptions	Represents the fill formatting of a shape object.
Excel.Interfaces.ShapeFillUpdateData	An interface for updating data on the `ShapeFill` object, for use in `shapeFill.set({ ... })`.
Excel.Interfaces.ShapeFontData	An interface describing the data returned by calling `shapeFont.toJSON()`.
Excel.Interfaces.ShapeFontLoadOptions	Represents the font attributes, such as font name, font size, and color, for a shape's `TextRange` object.
Excel.Interfaces.ShapeFontUpdateData	An interface for updating data on the `ShapeFont` object, for use in `shapeFont.set({ ... })`.
Excel.Interfaces.ShapeGroupData	An interface describing the data returned by calling `shapeGroup.toJSON()`.
Excel.Interfaces.ShapeGroupLoadOptions	Represents a shape group inside a worksheet. To get the corresponding `Shape` object, use `ShapeGroup.shape`.
Excel.Interfaces.ShapeLineFormatData	An interface describing the data returned by calling `shapeLineFormat.toJSON()`.
Excel.Interfaces.ShapeLineFormatLoadOptions	Represents the line formatting for the shape object. For images and geometric shapes, line formatting represents the border of the shape.
Excel.Interfaces.ShapeLineFormatUpdateData	An interface for updating data on the `ShapeLineFormat` object, for use in `shapeLineFormat.set({ ... })`.
Excel.Interfaces.ShapeLoadOptions	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.
Excel.Interfaces.ShapeUpdateData	An interface for updating data on the `Shape` object, for use in `shape.set({ ... })`.
Excel.Interfaces.SlicerCollectionData	An interface describing the data returned by calling `slicerCollection.toJSON()`.
Excel.Interfaces.SlicerCollectionLoadOptions	Represents a collection of all the slicer objects in the workbook or a worksheet.
Excel.Interfaces.SlicerCollectionUpdateData	An interface for updating data on the `SlicerCollection` object, for use in `slicerCollection.set({ ... })`.
Excel.Interfaces.SlicerData	An interface describing the data returned by calling `slicer.toJSON()`.
Excel.Interfaces.SlicerItemCollectionData	An interface describing the data returned by calling `slicerItemCollection.toJSON()`.
Excel.Interfaces.SlicerItemCollectionLoadOptions	Represents a collection of all the slicer item objects in the slicer.
Excel.Interfaces.SlicerItemCollectionUpdateData	An interface for updating data on the `SlicerItemCollection` object, for use in `slicerItemCollection.set({ ... })`.
Excel.Interfaces.SlicerItemData	An interface describing the data returned by calling `slicerItem.toJSON()`.
Excel.Interfaces.SlicerItemLoadOptions	Represents a slicer item in a slicer.
Excel.Interfaces.SlicerItemUpdateData	An interface for updating data on the `SlicerItem` object, for use in `slicerItem.set({ ... })`.
Excel.Interfaces.SlicerLoadOptions	Represents a `Slicer` object in the workbook.
Excel.Interfaces.SlicerStyleCollectionData	An interface describing the data returned by calling `slicerStyleCollection.toJSON()`.
Excel.Interfaces.SlicerStyleCollectionLoadOptions	Represents a collection of `SlicerStyle` objects.
Excel.Interfaces.SlicerStyleCollectionUpdateData	An interface for updating data on the `SlicerStyleCollection` object, for use in `slicerStyleCollection.set({ ... })`.
Excel.Interfaces.SlicerStyleData	An interface describing the data returned by calling `slicerStyle.toJSON()`.
Excel.Interfaces.SlicerStyleLoadOptions	Represents a slicer style, which defines style elements by region of the slicer.
Excel.Interfaces.SlicerStyleUpdateData	An interface for updating data on the `SlicerStyle` object, for use in `slicerStyle.set({ ... })`.
Excel.Interfaces.SlicerUpdateData	An interface for updating data on the `Slicer` object, for use in `slicer.set({ ... })`.
Excel.Interfaces.StyleCollectionData	An interface describing the data returned by calling `styleCollection.toJSON()`.
Excel.Interfaces.StyleCollectionLoadOptions	Represents a collection of all the styles.
Excel.Interfaces.StyleCollectionUpdateData	An interface for updating data on the `StyleCollection` object, for use in `styleCollection.set({ ... })`.
Excel.Interfaces.StyleData	An interface describing the data returned by calling `style.toJSON()`.
Excel.Interfaces.StyleLoadOptions	An object encapsulating a style's format and other properties.
Excel.Interfaces.StyleUpdateData	An interface for updating data on the `Style` object, for use in `style.set({ ... })`.
Excel.Interfaces.TableCollectionData	An interface describing the data returned by calling `tableCollection.toJSON()`.
Excel.Interfaces.TableCollectionLoadOptions	Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached.
Excel.Interfaces.TableCollectionUpdateData	An interface for updating data on the `TableCollection` object, for use in `tableCollection.set({ ... })`.
Excel.Interfaces.TableColumnCollectionData	An interface describing the data returned by calling `tableColumnCollection.toJSON()`.
Excel.Interfaces.TableColumnCollectionLoadOptions	Represents a collection of all the columns that are part of the table.
Excel.Interfaces.TableColumnCollectionUpdateData	An interface for updating data on the `TableColumnCollection` object, for use in `tableColumnCollection.set({ ... })`.
Excel.Interfaces.TableColumnData	An interface describing the data returned by calling `tableColumn.toJSON()`.
Excel.Interfaces.TableColumnLoadOptions	Represents a column in a table.
Excel.Interfaces.TableColumnUpdateData	An interface for updating data on the `TableColumn` object, for use in `tableColumn.set({ ... })`.
Excel.Interfaces.TableData	An interface describing the data returned by calling `table.toJSON()`.
Excel.Interfaces.TableLoadOptions	Represents an Excel table. To learn more about the table object model, read Work with tables using the Excel JavaScript API.
Excel.Interfaces.TableRowCollectionData	An interface describing the data returned by calling `tableRowCollection.toJSON()`.
Excel.Interfaces.TableRowCollectionLoadOptions	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 or columns are added before them, a `TableRow` object represents 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.
Excel.Interfaces.TableRowCollectionUpdateData	An interface for updating data on the `TableRowCollection` object, for use in `tableRowCollection.set({ ... })`.
Excel.Interfaces.TableRowData	An interface describing the data returned by calling `tableRow.toJSON()`.
Excel.Interfaces.TableRowLoadOptions	Represents a row in a table. Note that unlike ranges or columns, which will adjust if new rows or columns are added before them, a `TableRow` object represents 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.
Excel.Interfaces.TableRowUpdateData	An interface for updating data on the `TableRow` object, for use in `tableRow.set({ ... })`.
Excel.Interfaces.TableScopedCollectionData	An interface describing the data returned by calling `tableScopedCollection.toJSON()`.
Excel.Interfaces.TableScopedCollectionLoadOptions	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.
Excel.Interfaces.TableScopedCollectionUpdateData	An interface for updating data on the `TableScopedCollection` object, for use in `tableScopedCollection.set({ ... })`.
Excel.Interfaces.TableSortData	An interface describing the data returned by calling `tableSort.toJSON()`.
Excel.Interfaces.TableSortLoadOptions	Manages sorting operations on `Table` objects.
Excel.Interfaces.TableStyleCollectionData	An interface describing the data returned by calling `tableStyleCollection.toJSON()`.
Excel.Interfaces.TableStyleCollectionLoadOptions	Represents a collection of table styles.
Excel.Interfaces.TableStyleCollectionUpdateData	An interface for updating data on the `TableStyleCollection` object, for use in `tableStyleCollection.set({ ... })`.
Excel.Interfaces.TableStyleData	An interface describing the data returned by calling `tableStyle.toJSON()`.
Excel.Interfaces.TableStyleLoadOptions	Represents a table style, which defines the style elements by region of the table.
Excel.Interfaces.TableStyleUpdateData	An interface for updating data on the `TableStyle` object, for use in `tableStyle.set({ ... })`.
Excel.Interfaces.TableUpdateData	An interface for updating data on the `Table` object, for use in `table.set({ ... })`.
Excel.Interfaces.TextConditionalFormatData	An interface describing the data returned by calling `textConditionalFormat.toJSON()`.
Excel.Interfaces.TextConditionalFormatLoadOptions	Represents a specific text conditional format.
Excel.Interfaces.TextConditionalFormatUpdateData	An interface for updating data on the `TextConditionalFormat` object, for use in `textConditionalFormat.set({ ... })`.
Excel.Interfaces.TextFrameData	An interface describing the data returned by calling `textFrame.toJSON()`.
Excel.Interfaces.TextFrameLoadOptions	Represents the text frame of a shape object.
Excel.Interfaces.TextFrameUpdateData	An interface for updating data on the `TextFrame` object, for use in `textFrame.set({ ... })`.
Excel.Interfaces.TextRangeData	An interface describing the data returned by calling `textRange.toJSON()`.
Excel.Interfaces.TextRangeLoadOptions	Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text.
Excel.Interfaces.TextRangeUpdateData	An interface for updating data on the `TextRange` object, for use in `textRange.set({ ... })`.
Excel.Interfaces.TimelineStyleCollectionData	An interface describing the data returned by calling `timelineStyleCollection.toJSON()`.
Excel.Interfaces.TimelineStyleCollectionLoadOptions	Represents a collection of timeline styles.
Excel.Interfaces.TimelineStyleCollectionUpdateData	An interface for updating data on the `TimelineStyleCollection` object, for use in `timelineStyleCollection.set({ ... })`.
Excel.Interfaces.TimelineStyleData	An interface describing the data returned by calling `timelineStyle.toJSON()`.
Excel.Interfaces.TimelineStyleLoadOptions	Represents a `TimelineStyle`, which defines style elements by region in the timeline.
Excel.Interfaces.TimelineStyleUpdateData	An interface for updating data on the `TimelineStyle` object, for use in `timelineStyle.set({ ... })`.
Excel.Interfaces.TopBottomConditionalFormatData	An interface describing the data returned by calling `topBottomConditionalFormat.toJSON()`.
Excel.Interfaces.TopBottomConditionalFormatLoadOptions	Represents a top/bottom conditional format.
Excel.Interfaces.TopBottomConditionalFormatUpdateData	An interface for updating data on the `TopBottomConditionalFormat` object, for use in `topBottomConditionalFormat.set({ ... })`.
Excel.Interfaces.WorkbookCreatedData	An interface describing the data returned by calling `workbookCreated.toJSON()`.
Excel.Interfaces.WorkbookData	An interface describing the data returned by calling `workbook.toJSON()`.
Excel.Interfaces.WorkbookLoadOptions	Workbook is the top level object which contains related workbook objects such as worksheets, tables, and ranges. To learn more about the workbook object model, read Work with workbooks using the Excel JavaScript API.
Excel.Interfaces.WorkbookProtectionData	An interface describing the data returned by calling `workbookProtection.toJSON()`.
Excel.Interfaces.WorkbookProtectionLoadOptions	Represents the protection of a workbook object.
Excel.Interfaces.WorkbookRangeAreasData	An interface describing the data returned by calling `workbookRangeAreas.toJSON()`.
Excel.Interfaces.WorkbookRangeAreasLoadOptions	Represents a collection of one or more rectangular ranges in multiple worksheets.
Excel.Interfaces.WorkbookUpdateData	An interface for updating data on the `Workbook` object, for use in `workbook.set({ ... })`.
Excel.Interfaces.WorksheetCollectionData	An interface describing the data returned by calling `worksheetCollection.toJSON()`.
Excel.Interfaces.WorksheetCollectionLoadOptions	Represents a collection of worksheet objects that are part of the workbook.
Excel.Interfaces.WorksheetCollectionUpdateData	An interface for updating data on the `WorksheetCollection` object, for use in `worksheetCollection.set({ ... })`.
Excel.Interfaces.WorksheetCustomPropertyCollectionData	An interface describing the data returned by calling `worksheetCustomPropertyCollection.toJSON()`.
Excel.Interfaces.WorksheetCustomPropertyCollectionLoadOptions	Contains the collection of worksheet-level custom property.
Excel.Interfaces.WorksheetCustomPropertyCollectionUpdateData	An interface for updating data on the `WorksheetCustomPropertyCollection` object, for use in `worksheetCustomPropertyCollection.set({ ... })`.
Excel.Interfaces.WorksheetCustomPropertyData	An interface describing the data returned by calling `worksheetCustomProperty.toJSON()`.
Excel.Interfaces.WorksheetCustomPropertyLoadOptions	Represents a worksheet-level custom property.
Excel.Interfaces.WorksheetCustomPropertyUpdateData	An interface for updating data on the `WorksheetCustomProperty` object, for use in `worksheetCustomProperty.set({ ... })`.
Excel.Interfaces.WorksheetData	An interface describing the data returned by calling `worksheet.toJSON()`.
Excel.Interfaces.WorksheetLoadOptions	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.
Excel.Interfaces.WorksheetProtectionData	An interface describing the data returned by calling `worksheetProtection.toJSON()`.
Excel.Interfaces.WorksheetProtectionLoadOptions	Represents the protection of a worksheet object.
Excel.Interfaces.WorksheetUpdateData	An interface for updating data on the `Worksheet` object, for use in `worksheet.set({ ... })`.
Excel.LinkedEntityCellValue	Represents a value whose properties derive from a service.
Excel.LinkedEntityId	The linked entity ID object represents a set of properties that describes a service and culture for locating this service defined value.
Excel.ListDataValidation	Represents the List data validation criteria.
Excel.NameErrorCellValue	Represents the value of a cell containing a #NAME? error.
Excel.NotAvailableErrorCellValue	Represents the value of a cell containing a #N/A! error.
Excel.NullErrorCellValue	Represents the value of a cell containing a #NULL! error.
Excel.NumErrorCellValue	Represents the value of a cell containing a #NUM! error.
Excel.PageLayoutMarginOptions	Represents the options in page layout margins.
Excel.PageLayoutZoomOptions	Represents page zoom properties.
Excel.PivotDateFilter	Configurable template for a date filter to apply to a PivotField. The `condition` defines what criteria need to be set in order for the filter to operate.
Excel.PivotFilters	An interface representing all PivotFilters currently applied to a given PivotField.
Excel.PivotLabelFilter	Configurable template for a label filter to apply to a PivotField. The `condition` defines what criteria need to be set in order for the filter to operate.
Excel.PivotManualFilter	Configurable template for a manual filter to apply to a PivotField. The `condition` defines what criteria need to be set in order for the filter to operate.
Excel.PivotValueFilter	Configurable template for a value filter to apply to a PivotField. The `condition` defines what criteria need to be set in order for the filter to operate.
Excel.PlaceholderErrorCellValue	Represents the value of a cell containing a #BUSY! error. This type of error is used as a placeholder while the value of a cell is downloaded.
Excel.RangeHyperlink	Represents the necessary strings to get/set a hyperlink (XHL) object.
Excel.RangeReference	Represents a string reference of the form "SheetName!A1:B5", or a global or local named range.
Excel.ReferenceCellValue	Represents a reference into `referencedValues`. One scenario for using this reference is to avoid duplicating cell value objects (such as an `EntityCellValue`). Define a cell value object once in `referencedValues`, and then refer to that cell value from many places by using a `ReferenceCellValue` where the duplicated value would have appeared.
Excel.RefErrorCellValue	Represents the value of a cell containing a #REF! error.
Excel.ReplaceCriteria	Represents the replace criteria to be used.
Excel.RootReferenceCellValue	Represents a reference to the value which contains `referencedValues`.
Excel.RowProperties	Represents the returned properties of getRowProperties. [ API set: ExcelApi 1.9 ]
Excel.RowPropertiesLoadOptions	Represents which row properties to load, when used as part of a "range.getRowProperties" method. [ API set: ExcelApi 1.9 ]
Excel.RunOptions
Excel.SearchCriteria	Represents the search criteria to be used.
Excel.SelectionChangedEventArgs	Provides information about the document that raised the selection changed event.
Excel.Session
Excel.SettableCellProperties	Represents the input parameter of setCellProperties. [ API set: ExcelApi 1.9 ]
Excel.SettableColumnProperties	Represents the input parameter of setColumnProperties. [ API set: ExcelApi 1.9 ]
Excel.SettableRowProperties	Represents the input parameter of setRowProperties. [ API set: ExcelApi 1.9 ]
Excel.SettingsChangedEventArgs	Provides information about the setting that raised the settings changed event
Excel.ShapeActivatedEventArgs	Provides information about the shape that raised the activated event.
Excel.ShapeDeactivatedEventArgs	Provides information about the shape that raised the deactivated event.
Excel.ShowAsRule
Excel.SortField	Represents a condition in a sorting operation.
Excel.SpillErrorCellValue	Represents the value of a cell containing a #SPILL! error.
Excel.StringCellValue	Represents the value of a cell containing a string.
Excel.Subtotals	Subtotals for the Pivot Field.
Excel.TableAddedEventArgs	Provides information about the table that raised the added event.
Excel.TableChangedEventArgs	Provides information about the table that raised the changed event.
Excel.TableDeletedEventArgs	Provides information about the table that raised the deleted event.
Excel.TableSelectionChangedEventArgs	Provides information about the table that raised the selection changed event.
Excel.ThreeArrowsGraySet	[ API set: ExcelApi 1.2 ]
Excel.ThreeArrowsSet	[ API set: ExcelApi 1.2 ]
Excel.ThreeFlagsSet	[ API set: ExcelApi 1.2 ]
Excel.ThreeSignsSet	[ API set: ExcelApi 1.2 ]
Excel.ThreeStarsSet	[ API set: ExcelApi 1.2 ]
Excel.ThreeSymbols2Set	[ API set: ExcelApi 1.2 ]
Excel.ThreeSymbolsSet	[ API set: ExcelApi 1.2 ]
Excel.ThreeTrafficLights1Set	[ API set: ExcelApi 1.2 ]
Excel.ThreeTrafficLights2Set	[ API set: ExcelApi 1.2 ]
Excel.ThreeTrianglesSet	[ API set: ExcelApi 1.2 ]
Excel.ValueErrorCellValue	Represents the value of a cell containing a #VALUE! error.
Excel.ValueTypeNotAvailableCellValue	Represents the value of a cell containing a type of value which cannot be serialized. For example, an #UNKNOWN! error which represents a type of rich value not known to this version of Excel.
Excel.WebImageCellValue	Represents the value of a cell containing an image downloaded from the internet.
Excel.WorkbookActivatedEventArgs	Provides information about the workbook that raised the activated event.
Excel.WorkbookAutoSaveSettingChangedEventArgs	Provides information about the workbook's `onAutoSaveSettingChanged` event.
Excel.WorksheetActivatedEventArgs	Provides information about the worksheet that raised the activated event.
Excel.WorksheetAddedEventArgs	Provides information about the worksheet that raised the added event.
Excel.WorksheetCalculatedEventArgs	Provides information about the worksheet that raised the calculated event.
Excel.WorksheetChangedEventArgs	Provides information about the worksheet that raised the changed event.
Excel.WorksheetColumnSortedEventArgs	Provides information about the column-sorted event and its related worksheet.
Excel.WorksheetDeactivatedEventArgs	Provides information about the worksheet that raised the deactivated event.
Excel.WorksheetDeletedEventArgs	Provides information about the worksheet that raised the deleted event.
Excel.WorksheetFormatChangedEventArgs	Provides information about the worksheet format change event.
Excel.WorksheetFormulaChangedEventArgs	Provides information about the worksheet and formulas that raised the formula changed event.
Excel.WorksheetMovedEventArgs	Notifies when a worksheet is moved within a workbook. If a worksheet is moved from one position within the workbook to another via the Excel UI, then this API will trigger an event. Note that if the position of a worksheet changes as a result of moving a different worksheet, then this event won't trigger for both position changes. This event only triggers for the primary worksheet move, and not any worksheet position changes that occur as a result of that primary move.
Excel.WorksheetNameChangedEventArgs	Provides information about the worksheet whose name has changed.
Excel.WorksheetProtectionChangedEventArgs	Provides information about the worksheet that raised the protection status changed event, which fires when the protection status is updated in a worksheet.
Excel.WorksheetProtectionOptions	Represents the options in sheet protection.
Excel.WorksheetRowHiddenChangedEventArgs	Provides information about the worksheet's row hidden change event.
Excel.WorksheetRowSortedEventArgs	Provides information about the row-sorted event and its related worksheet.
Excel.WorksheetSearchCriteria	Represents the worksheet search criteria to be used.
Excel.WorksheetSelectionChangedEventArgs	Provides information about the worksheet that raised the selection changed event.
Excel.WorksheetSingleClickedEventArgs	Provides information about the left-clicked/tapped event and its related worksheet.
Excel.WorksheetVisibilityChangedEventArgs	Provides information about the worksheet whose visibility has changed.

Type Aliases

Excel.CardLayout	Represents the layout of a card in card view.
Excel.CardLayoutSection	Represents the layout of a section of a card in card view.
Excel.CellValue	Represents the value in a cell.
Excel.CellValueAndPropertyMetadata	Represents the value and metadata of a property. The metadata applies to the property (and not the value), but it is combined with the value in this type.
Excel.CompactLayout	Represents the layout used when there is limited space to represent the entity.
Excel.EntityPropertyType	Represents the value of a property.
Excel.ErrorCellValue	Represents a cell value which contains an error.
Excel.ReferencedValue	Represents the value in a cell.

Enums

Excel.AggregationFunction	Aggregation function for the `DataPivotHierarchy`.
Excel.ArrowheadLength
Excel.ArrowheadStyle
Excel.ArrowheadWidth
Excel.AutoFillType	The behavior types when AutoFill is used on a range in the workbook.
Excel.BindingType
Excel.BlockedErrorCellValueSubType	Represents types of #BLOCKED! errors.
Excel.BorderIndex
Excel.BorderLineStyle
Excel.BorderWeight
Excel.BuiltInStyle
Excel.BusyErrorCellValueSubType	Represents types of #BUSY! errors.
Excel.CalcErrorCellValueSubType	Represents types of #CALC! errors.
Excel.CalculationMode
Excel.CalculationState	Represents the state of calculation across the entire Excel application.
Excel.CalculationType
Excel.CellValueType	Represents the types of the `CellValue` object.
Excel.ChartAxisCategoryType	Specifies the type of the category axis.
Excel.ChartAxisDisplayUnit
Excel.ChartAxisGroup
Excel.ChartAxisPosition
Excel.ChartAxisScaleType
Excel.ChartAxisTickLabelPosition
Excel.ChartAxisTickMark
Excel.ChartAxisTimeUnit	Specifies the unit of time for chart axes and data series.
Excel.ChartAxisType
Excel.ChartBinType	Specifies the bin type of a histogram chart or pareto chart series.
Excel.ChartBoxQuartileCalculation	Represents the quartile calculation type of chart series layout. Only applies to a box and whisker chart.
Excel.ChartColorScheme
Excel.ChartDataLabelPosition
Excel.ChartDataSourceType	Specifies the data source type of the chart series.
Excel.ChartDisplayBlanksAs
Excel.ChartErrorBarsInclude	Represents which parts of the error bar to include.
Excel.ChartErrorBarsType	Represents the range type for error bars.
Excel.ChartGradientStyle	Represents the gradient style of a chart series. This is only applicable for region map charts.
Excel.ChartGradientStyleType	Represents the gradient style type of a chart series. This is only applicable for region map charts.
Excel.ChartLegendPosition
Excel.ChartLineStyle
Excel.ChartMapAreaLevel	Represents the mapping level of a chart series. This only applies to region map charts.
Excel.ChartMapLabelStrategy	Represents the region level of a chart series layout. This only applies to region map charts.
Excel.ChartMapProjectionType	Represents the region projection type of a chart series layout. This only applies to region map charts.
Excel.ChartMarkerStyle
Excel.ChartParentLabelStrategy	Represents the parent label strategy of the chart series layout. This only applies to treemap charts
Excel.ChartPlotAreaPosition
Excel.ChartPlotBy
Excel.ChartSeriesBy	Specifies whether the series are by rows or by columns. In Excel 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".
Excel.ChartSeriesDimension	Represents the dimensions when getting values from chart series.
Excel.ChartSplitType
Excel.ChartTextHorizontalAlignment	Represents the horizontal alignment for the specified object.
Excel.ChartTextVerticalAlignment	Represents the vertical alignment for the specified object.
Excel.ChartTickLabelAlignment
Excel.ChartTitlePosition	Represents the position of the chart title.
Excel.ChartTrendlineType
Excel.ChartType
Excel.ChartUnderlineStyle
Excel.ClearApplyTo
Excel.CloseBehavior	Specifies the close behavior for `Workbook.close`.
Excel.CommentChangeType	Represents how the comments in the event were changed.
Excel.ConditionalCellValueOperator	Represents the operator of the text conditional format type.
Excel.ConditionalDataBarAxisFormat	Represents the format options for a data bar axis.
Excel.ConditionalDataBarDirection	Represents the data bar direction within a cell.
Excel.ConditionalFormatColorCriterionType	Represents the types of color criterion for conditional formatting.
Excel.ConditionalFormatDirection	Represents the direction for a selection.
Excel.ConditionalFormatIconRuleType	Represents the types of icon conditional format.
Excel.ConditionalFormatPresetCriterion	Represents the criteria of the preset criteria conditional format type.
Excel.ConditionalFormatRuleType	Represents the types of conditional format values.
Excel.ConditionalFormatType
Excel.ConditionalIconCriterionOperator	Represents the operator for each icon criteria.
Excel.ConditionalRangeBorderIndex
Excel.ConditionalRangeBorderLineStyle
Excel.ConditionalRangeFontUnderlineStyle
Excel.ConditionalTextOperator	Represents the operator of the text conditional format type.
Excel.ConditionalTopBottomCriterionType	Represents the criteria for the above/below average conditional format type.
Excel.ConnectErrorCellValueSubType	Represents types of #CONNECT! errors.
Excel.ConnectorType
Excel.ContentType
Excel.DataChangeType
Excel.DataSourceType	Represents a command type of `DataConnection`.
Excel.DataValidationAlertStyle	Represents the data validation error alert style. The default is `Stop`.
Excel.DataValidationOperator	Represents the data validation operator enum.
Excel.DataValidationType	Represents the data validation type enum.
Excel.DateFilterCondition	Enum representing all accepted conditions by which a date filter can be applied. Used to configure the type of PivotFilter that is applied to the field.
Excel.DeleteShiftDirection
Excel.DocumentPropertyItem
Excel.DocumentPropertyType
Excel.DynamicFilterCriteria
Excel.EntityCompactLayoutIcons	The list of icons available for `EntityCompactLayout`. An icon displays in the Excel UI, either to the left of the title in a cell that contains an entity card, or to the left of the title of a referenced entity inside an entity card. Selecting the icon opens the entity card.
Excel.ErrorCellValueType	Represents the types of the `ErrorCellValue` object.
Excel.ErrorCodes
Excel.EventSource
Excel.EventTriggerSource
Excel.EventType
Excel.ExternalErrorCellValueSubType	Represents types of #EXTERNAL! errors.
Excel.FieldErrorCellValueSubType	Represents types of #FIELD! errors.
Excel.FillPattern
Excel.FilterDatetimeSpecificity
Excel.FilterOn
Excel.FilterOperator
Excel.GeometricShapeType	Specifies the shape type for a `GeometricShape` object.
Excel.GroupOption
Excel.HeaderFooterState
Excel.HorizontalAlignment
Excel.IconSet
Excel.ImageFittingMode
Excel.InsertShiftDirection	Determines the direction in which existing cells will be shifted to accommodate what is being inserted.
Excel.KeyboardDirection
Excel.LabelFilterCondition	Enum representing all accepted conditions by which a label filter can be applied. Used to configure the type of PivotFilter that is applied to the field. `PivotFilter.criteria.exclusive` can be set to `true` to invert many of these conditions.
Excel.LinkedDataTypeState
Excel.LoadToType	An enum that specifies the query load to destination.
Excel.NamedItemScope
Excel.NamedItemType
Excel.NumberFormatCategory	Represents a category of number formats.
Excel.NumErrorCellValueSubType	Represents types of #NUM! errors.
Excel.PageOrientation
Excel.PaperType
Excel.PictureFormat	The format of the image.
Excel.PivotAxis	Represents the axis from which to get the PivotItems.
Excel.PivotFilterTopBottomCriterion	Represents the criteria for the top/bottom values filter.
Excel.PivotFilterType	A simple enum that represents a type of filter for a PivotField.
Excel.PivotLayoutType
Excel.Placement	Specifies the way that an object is attached to its underlying cells.
Excel.PrintComments
Excel.PrintErrorType
Excel.PrintMarginUnit
Excel.PrintOrder
Excel.ProtectionSelectionMode
Excel.QueryError	An enum that specifies the query load error message.
Excel.RangeCopyType
Excel.RangeUnderlineStyle
Excel.RangeValueType
Excel.ReadingOrder
Excel.ReferenceValueType	Represents the types of the `ReferenceValue` object.
Excel.RefErrorCellValueSubType	Represents types of #REF! errors.
Excel.RibbonTab
Excel.RowHiddenChangeType
Excel.SaveBehavior	Specifies the save behavior for `Workbook.save`.
Excel.SearchDirection	Specifies the search direction.
Excel.ShapeAutoSize	Determines the type of automatic sizing allowed.
Excel.ShapeFillType	Specifies a shape's fill type.
Excel.ShapeFontUnderlineStyle	The type of underline applied to a font.
Excel.ShapeLineDashStyle	The dash style for a line.
Excel.ShapeLineStyle	The style for a line.
Excel.ShapeScaleFrom	Specifies which part of the shape retains its position when the shape is scaled.
Excel.ShapeScaleType	Specifies whether the shape is scaled relative to its original or current size.
Excel.ShapeTextHorizontalAlignment	Specifies the horizontal alignment for the text frame in a shape.
Excel.ShapeTextHorizontalOverflow	Specifies the horizontal overflow for the text frame in a shape.
Excel.ShapeTextOrientation	Specifies the orientation for the text frame in a shape.
Excel.ShapeTextReadingOrder	Specifies the reading order for the text frame in a shape.
Excel.ShapeTextVerticalAlignment	Specifies the vertical alignment for the text frame in a shape.
Excel.ShapeTextVerticalOverflow	Specifies the vertical overflow for the text frame in a shape.
Excel.ShapeType	Specifies the type of a shape.
Excel.ShapeZOrder	Specifies where in the z-order a shape should be moved relative to other shapes.
Excel.SheetVisibility
Excel.ShowAsCalculation	The ShowAs calculation function for the DataPivotField.
Excel.SlicerSortType	Specifies the slicer sort behavior for `Slicer.sortBy`.
Excel.SortBy	Represents the sort direction.
Excel.SortDataOption
Excel.SortMethod	Represents the ordering method to be used when sorting Chinese characters.
Excel.SortOn	Represents the part of the cell used as the sorting criteria.
Excel.SortOrientation
Excel.SpecialCellType
Excel.SpecialCellValueType
Excel.SpillErrorCellValueSubType	Represents types of #SPILL! errors.
Excel.SubtotalLocationType
Excel.TopBottomSelectionType	A simple enum for top/bottom filters to select whether to filter by the top N or bottom N percent, number, or sum of values.
Excel.ValueErrorCellValueSubType	Represents types of #VALUE! errors.
Excel.ValueFilterCondition	Enum representing all accepted conditions by which a value filter can be applied. Used to configure the type of PivotFilter that is applied to the field. `PivotFilter.exclusive` can be set to `true` to invert many of these conditions.
Excel.VerticalAlignment
Excel.WorksheetPositionType	The position of a worksheet relative to another worksheet or the entire worksheet collection.

Functions

Excel.createWorkbook(base64)	Creates and opens a new workbook. Optionally, the workbook can be pre-populated with a Base64-encoded .xlsx file. Note: Macros can be a security risk. If this API is used to create a workbook that includes a macro, the add-in user will be prompted with a "Trust this add-in?" dialog in the Excel UI. The user must select the "Trust add-in" button to proceed. [ API set: ExcelApi 1.8 ]
Excel.getDataCommonPostprocess(response, callArgs)
Excel.postprocessBindingDescriptor(response)
Excel.run(batch)	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.
Excel.run(object, batch)	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.
Excel.run(objects, batch)	Executes a batch script that performs actions on the Excel object model, using the RequestContext of previously-created API objects.
Excel.run(options, batch)	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.
Excel.run(context, batch)	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.

Function Details

Excel.createWorkbook(base64)

Creates and opens a new workbook. Optionally, the workbook can be pre-populated with a Base64-encoded .xlsx file. Note: Macros can be a security risk. If this API is used to create a workbook that includes a macro, the add-in user will be prompted with a "Trust this add-in?" dialog in the Excel UI. The user must select the "Trust add-in" button to proceed.

[ API set: ExcelApi 1.8 ]

export function createWorkbook(base64?: string): Promise<void>;

Parameters

base64: string

Returns

Promise<void>

Examples

const myFile = <HTMLInputElement>document.getElementById("file");
const reader = new FileReader();

reader.onload = (event) => {
    Excel.run((context) => {
    // Remove the metadata before the base64-encoded string.
    const startIndex = reader.result.toString().indexOf("base64,");
    const mybase64 = reader.result.toString().substr(startIndex + 7);

    Excel.createWorkbook(mybase64);
    return context.sync();
    });
};

// Read in the file as a data URL so we can parse the base64-encoded string.
reader.readAsDataURL(myFile.files[0]);

Excel.getDataCommonPostprocess(response, callArgs)

export function getDataCommonPostprocess(response: any, callArgs: any): any;

Parameters

response: any

callArgs: any

Returns

any

Excel.postprocessBindingDescriptor(response)

export function postprocessBindingDescriptor(response: any): any;

Parameters

response: any

Returns

any

Excel.run(batch)

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.

export function run<T>(batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

Parameters

batch: (context: Excel.RequestContext) => Promise<T>

A function that takes in a RequestContext and returns a promise (typically, just the result of "context.sync()"). The context parameter facilitates requests to the Excel application. Since the Office add-in and the Excel application run in two different processes, the RequestContext is required to get access to the Excel object model from the add-in.

Returns

Promise<T>

Excel.run(object, batch)

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.

export function run<T>(object: OfficeExtension.ClientObject, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

Parameters

object: OfficeExtension.ClientObject

A previously-created API object. The batch will use the same RequestContext as the passed-in object, which means that any changes applied to the object will be picked up by "context.sync()".

batch: (context: Excel.RequestContext) => Promise<T>

Returns

Promise<T>

Excel.run(objects, batch)

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

export function run<T>(objects: OfficeExtension.ClientObject[], batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

Parameters

objects: OfficeExtension.ClientObject[]

An array of previously-created API objects. The array will be validated to make sure that all of the objects share the same context. The batch will use this shared RequestContext, which means that any changes applied to these objects will be picked up by "context.sync()".

batch: (context: Excel.RequestContext) => Promise<T>

Returns

Promise<T>

Excel.run(options, batch)

export function run<T>(options: Excel.RunOptions, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

Parameters

options: Excel.RunOptions

The additional options for this Excel.run which specify previous objects, whether to delay the request for cell edit, session info, etc.

batch: (context: Excel.RequestContext) => Promise<T>

Returns

Promise<T>

Excel.run(context, batch)

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.

export function run<T>(context: OfficeExtension.ClientRequestContext, batch: (context: Excel.RequestContext) => Promise<T>): Promise<T>;

Parameters

context: OfficeExtension.ClientRequestContext

A previously-created object. The batch will use the same RequestContext as the passed-in object, which means that any changes applied to the object will be picked up by "context.sync()".

batch: (context: Excel.RequestContext) => Promise<T>

Returns

Promise<T>

Share via

excel package

Classes

Interfaces

Type Aliases

Enums

Functions

Function Details

Excel.createWorkbook(base64)

Parameters

Returns

Examples

Excel.getDataCommonPostprocess(response, callArgs)

Parameters

Returns

Excel.postprocessBindingDescriptor(response)

Parameters

Returns

Excel.run(batch)

Parameters

Returns

Excel.run(object, batch)

Parameters

Returns

Excel.run(objects, batch)

Parameters

Returns

Excel.run(options, batch)

Parameters

Returns

Excel.run(context, batch)

Parameters

Returns

Additional resources