Complete List
| Application | (1.1) Represents the Excel application that manages the workbook. |
| AutoFilter | (1.9) Represents the AutoFilter object and turns column values into specific filters based on the cell contents. |
| BasicDataValidation | (1.8) (Interface) Represents the Basic Type data validation criteria. |
| Binding | (1.1) Represents an Office.js binding that is defined in the workbook. |
| BindingCollection | (1.1) Represents the collection of all the binding objects in the workbook. |
| CellBorder | (1.9) (Interface) Represents the properties of a single border. |
| CellBorderCollection | (1.9) (Interface) Represents the format.borders properties. |
| CellProperties | (1.9) (Interface) Represents the returned properties of getCellProperties. |
| CellPropertiesBorderLoadOptions | (1.9) (Interface) Specifies which properties to load on the format.borders object. |
| CellPropertiesFill | (1.9) (Interface) Represents the format.fill properties. |
| CellPropertiesFillLoadOptions | (1.9) (Interface) Specifies which properties to load on the format.fill object. |
| CellPropertiesFont | (1.9) (Interface) Represents the format.font properties. |
| CellPropertiesFontLoadOptions | (1.9) (Interface) Specifies which properties to load on the format.font object. |
| CellPropertiesFormat | (1.9) (Interface) Represents the returned format properties of getCellProperties or format input parameter of setCellProperties. |
| CellPropertiesFormatLoadOptions | (1.9) (Interface) Represents which properties to load on the format object. |
| CellPropertiesLoadOptions | (1.9) (Interface) Represents which cell properties to load, when used as part of a "range.getCellProperties" method. |
| CellPropertiesProtection | (1.9) (Interface) Represents the format.protection properties. |
| CellValueConditionalFormat | (1.6) Represents a cell value conditional format. |
| Chart | (1.1) Represents a chart object on a worksheet. |
| ChartAreaFormat | (1.1) Represents all the format properties of the chart area. |
| ChartAxes | (1.1) Represents the chart axes |
| ChartAxis | (1.1) Represents a single chart axis. |
| ChartAxisFormat | (1.1) Represents all the format properties of a single chart axis. |
| ChartAxisTitle | (1.1) Represents the title of a single chart axis. |
| ChartAxisTitleFormat | (1.1) Represents all the format properties of a single chart axis title. |
| ChartBinOptions | (1.9) Represents the bin options for histogram and pareto charts. |
| ChartBorder | (1.7) Represents the border formatting of a chart element. |
| ChartBoxwhiskerOptions | (1.9) Represents all the properties of a box whisker chart. |
| ChartCollection | (1.1) Represents the collection of all the charts on a worksheet (or in workbook ?) |
| ChartDataLabel | (1.7) Represents the data label of a chart point. |
| ChartDataLabelFormat | (1.1) Represents all the format properties of a data label of a chart point. |
| ChartDataLabels | (1.1) Represents the collection of all the data labels on a chart point. |
| ChartErrorBars | (1.9) Represents the error bars of a chart. |
| ChartErrorBarsFormat | (1.9) Represents all the format properties of the error bars of a chart. |
| ChartFill | (1.1) Represents the fill formatting of a chart element. |
| ChartFont | (1.1) Represents the font attributes for a chart element. |
| ChartFormatString | (1.7) Represents the substring in any chart related objects (ChartTitle, ChartAxisTitle) |
| ChartGridlines | (1.1) Represents the major and minor gridlines of a chart. |
| ChartGridlinesFormat | (1.1) Represents all the formatting properties for the gridlines. |
| ChartLegend | (1.1) Represents the chart legend. |
| ChartLegendEntry | (1.7) Represents the legend entry for the chart legend. |
| ChartLegendEntryCollection | (1.7) Represents the collection of all the legend entries. |
| ChartLegendFormat | (1.1) Represents all the formatting properties for the legend. |
| ChartLineFormat | (1.1) Represents all the formatting properties for a line. |
| ChartMapOptions | (1.9) Represents the options for a region map chart. |
| ChartPivotOptions | (1.9) Represents the options for a pivot chart. |
| ChartPlotArea | (1.8) Represents the chart plot area. |
| ChartPlotAreaFormat | (1.8) Represents all the formatting properties for the plot area. |
| ChartPoint | (1.1) Represents a single point on a series. |
| ChartPointFormat | (1.1) Represents all the formatting properties for a single point on a series. |
| ChartPointsCollection | (1.1) Represents a collection of all the points on a series. |
| ChartSeries | (1.1) Represents a chart series. |
| ChartSeriesCollection | (1.1) Represents the collection of all the chart series on a chart. |
| ChartSeriesFormat | (1.1) Represents all the formatting properties for all the chart series on a chart. |
| ChartTitle | (1.1) Represents a chart title. |
| ChartTitleFormat | (1.1) Represents all the formatting properties for a chart title. |
| ChartTrendLine | (1.7) Represents a chart trend line. |
| ChartTrendLineCollection | (1.7) Represents the collection of all the chart trend lines on a chart. |
| ChartTrendLineFormat | (1.7) Represents all the formatting properties for a trend line. |
| ChartTrendLineLabel | (1.8) Represents a label on a chart trend line. |
| ChartTrendLineLabelFormat | (1.8) Represents all the formatting properties for the label on a chart trend line. |
| ColorScaleConditionalFormat | (1.6) Represents ColorScale criteria for conditional formatting. |
| ColumnProperties | (1.9) (Interface) Represents the returned properties of getColumnProperties. |
| ColumnPropertiesLoadOptions | (1.9) (Interface) Represents which column properties to load, when used as part of a "range.getColumnProperties" method. |
| Comment | (1.10) Represents a comment in the workbook. |
| CommentCollection | (1.10) Represents a collection of comment objects that are part of the workbook. |
| CommentDetail | (1.12) Represents a structure for the comment ID and IDs of its related replies. |
| CommentMention | (1.12) Represents the entity that is mentioned in comments. |
| CommentReply | (1.10) Represents a comment reply in the workbook. |
| CommentReplyCollection | (1.10) Represents a collection of comment reply objects that are part of the comment. |
| CommentRichContent | (1.11) Represents the content contained within a comment or comment reply. |
| ConditionalCellValueRule | (1.6) (Interface) Represents a cell value conditional format rule. |
| ConditionalColorScaleCriteria | (1.6) (Interface) Represents the criteria of the color scale. |
| ConditionalColorScaleCriterion | (1.6) (Interface) Represents a Color Scale Criterion which contains a type, value, and a color. |
| ConditionalDatabarNegativeFormat | (1.6) Represents a conditional format DataBar Format for the negative side of the data bar. |
| ConditionalDatabarPositiveFormat | (1.6) Represents a conditional format DataBar Format for the positive side of the data bar. |
| ConditionalDatabarRule | (1.6) (Interface) Represents a rule-type for a Data Bar. |
| ConditionalFormat | (1.6) Represents all the properties associated with a conditional format's range, format, rule, and other properties. |
| ConditionalFormatCollection | (1.6) Represents a collection of all the conditional formats that are overlap the range. |
| ConditionalFormatRule | (1.6) Represents a rule, for all traditional rule/format pairings. |
| ConditionalIconCriterion | (1.6) (Interface) Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset. |
| ConditionalPresetCriteriaRule | (1.6) (Interface) Represents the Preset Criteria Conditional Format Rule. |
| ConditionalRangeBorder | (1.6) Represents the border of an object. |
| ConditionalRangeBorderCollection | (1.6) Represents the border objects that make up range border. |
| ConditionalRangeFill | (1.6) Represents the background of a conditional range object. |
| ConditionalRangeFont | (1.6) Represents the font attributes (font style, color, etc.) for an object. |
| ConditionalRangeFormat | (1.6) Represents all the formatting properties range's font, fill, borders, and other properties. |
| ConditionalTextComparisonRule | (1.6) (Interface) Represents a Cell Value Conditional Format Rule. |
| ConditionalTopBottomRule | (1.6) (Interface) Represents the rule of the top/bottom conditional format. |
| CultureInfo | (1.11) Provides information based on current system culture settings. |
| CustomConditionalFormat | (1.6) Represents a custom conditional format type. |
| CustomDataValidation | (1.8) (Interface) Represents the Custom data validation criteria. |
| CustomProperty | (1.7) Represents a custom property. |
| CustomPropertyCollection | (1.7) Represents the collection of all the custom properties. |
| CustomXmlPart | (1.5) Represents a custom XML part object in a workbook. |
| CustomXmlPartCollection | (1.5) Represents the collection of custom XML parts. |
| CustomXmlPartScopedCollection | (1.5) Represents a scoped collection of custom XML parts. |
| DatabarConditionalFormat | (1.6) Represents a conditional formatting data bar. |
| DataConnectionCollection | (1.7) Represents a collection of all the Data Connections that are part of the workbook or worksheet. |
| DataPivotHierarchy | (1.8) Represents the Excel DataPivotHierarchy. |
| DataPivotHierarchyCollection | (1.8) Represents a collection of DataPivotHierarchy items associated with the PivotTable. |
| DataValidation | (1.8) Represents the data validation applied to the current range. |
| DataValidationErrorAlert | (1.8) (Interface) Represents the error alert properties for the data validation. |
| DataValidationPrompt | (1.8) (Interface) Represents the user prompt properties for the data validation. |
| DataValidationRule | (1.8) (Interface) Represents the Data validation rule that contains different types of data validation. |
| DateTimeDataValidation | (1.8) Represents the Date data validation criteria. |
| DateTimeFormatInfo | (1.12) Defines the culturally appropriate format of displaying numbers. |
| DocumentProperties | (1.7) Represents workbook properties. |
| Filter | (1.2) Represents the filtering of a table's column. |
| FilterCriteria | (1.2) (Interface) Represents the filtering criteria applied to a column. |
| FilterDatetime | (1.2) (Interface) Represents how to filter a date when filtering on values. |
| FilterPivotHierarchy | (1.8) Represents the Excel FilterPivotHierarchy. |
| FilterPivotHierarchyCollection | (1.8) Represents a collection of FilterPivotHierarchy items associated with the PivotTable. |
| FormatProtection | (1.2) Represents the format protection of a range object. |
| FunctionResult | (1.2) Represents the result of a function-evaluation operation |
| Functions | (1.2) Represents an object for evaluating Excel functions. |
| GeometricShape | (1.9) Represents a geometric shape inside a worksheet. |
| GroupShapeCollection | (1.9) Represents the shape collection inside a shape group. |
| HeaderFooter | (1.9) Represents the Excel HeaderFooter. |
| HeaderFooterGroup | (1.9) Represents the Excel HeaderFooterGroup. |
| Icon | (1.2) (Interface) Represents a cell icon. |
| IconSetConditionalFormat | (1.6) Represents an IconSet criteria for conditional formatting. |
| Image | (1.9) Represents an image in the worksheet. |
| IterativeCalculation | (1.9) Represents the Iterative Calculation settings. |
| Line | (1.9) Represents a line inside a worksheet. |
| LinkedDataType | (beta) Represents a linked data type. |
| LinkedDataTypeCollection | (beta) Represents a collection of linked data types. |
| ListDataValidation | (1.8) (Interface) Represents the List data validation criteria. |
| LoadOption | (1.2) (Interface) |
| NamedItem | (1.1) Represents a defined name for a range of cells or value. |
| NamedItemArrayValues | (1.7) Represents an object containing values and types of a named item. |
| NamedItemCollection | (1.1) Represents a collection of all the NamedItem objects that are part of the workbook or worksheet. |
| NamedSheetView | (beta) Represents a named sheet view of a worksheet. |
| NamedSheetViewCollection | (beta) Represents the collection of sheet views in the worksheet. |
| NumberFormatInfo | (1.11) Defines the culturally appropriate format of displaying numbers. |
| PageBreak | (1.9) Represents the Excel PageBreak. |
| PageBreakCollection | (1.9) Represents the Excel PageBreakCollection. |
| PageLayout | (1.9) Represents layout and print settings that are not dependent any printer-specific implementation. |
| PageLayoutMarginOptions | (1.9) (Interface) Represents the options in page layout margins. |
| PageLayoutZoomOptions | (1.9) (Interface) Represents page zoom properties. |
| PivotDateFilter | (1.12) Configurable template for a date filter to apply to a PivotField. |
| PivotField | (1.8) Represents a pivot field. |
| PivotFieldCollection | (1.8) Represents the collection of all the pivot fields in the pivot table. |
| PivotFilters | (1.12) (Interface) Represents all PivotFilters currently applied to a given PivotField. |
| PivotHierarchy | (1.8) Represents the Excel PivotHierarchy. |
| PivotHierarchyCollection | (1.8) Represents a collection of all the PivotHierarchies that are part of the PivotTable. |
| PivotItem | (1.8) Represents a pivot item. |
| PivotItemCollection | (1.8) Represents a collection of all the PivotItems related to their parent PivotField. |
| PivotLabelFilter | (1.12) Configurable template for a label filter to apply to a PivotField. |
| PivotLayout | (1.8) Represents the visual layout of the PivotTable. |
| PivotManualFilter | (1.12) Configurable template for a manual filter to apply to a PivotField. |
| PivotTable | (1.3) Represents a pivot table |
| PivotTableCollection | (1.3) Represents the collection of all the pivot tables in the workbook. |
| PivotTableScopedCollection | (1.12) Represents a scoped collection of PivotTables. |
| PivotTableStyle | (1.10) Represents a PivotTable Style, which defines style elements by PivotTable region. |
| PivotTableStyleCollection | (1.10) Represents a collection of PivotTable styles. |
| PivotValueFilter | (1.12) (Interface) Configurable template for a value filter to apply to a PivotField. |
| PresetCriteriaConditionalFormat | (1.6) Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror. |
| Range | (1.1) Represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc. |
| RangeAreas | (1.9) Represents a collection of one or more rectangular ranges in the same worksheet. |
| RangeAreasCollection | (1.12) Contains the collection of cross-worksheets level Ranges. |
| RangeBorder | (1.1) Represents the border of an object. |
| RangeBorderCollection | (1.1) Represents the border objects that make up the range border. |
| RangeCollection | (1.9) Represents the Excel RangeCollection. |
| RangeFill | (1.1) Represents the background of a range object. |
| RangeFont | (1.1) Represents the font attributes (font name, font size, color, etc.) for an object. |
| RangeFormat | (1.1) A format object encapsulating the range's font, fill, borders, alignment, and other properties. |
| RangeHyperlink | (1.7) (Interface) Represents the necessary strings to get/set a hyperlink (XHL) object. |
| RangeReference | (1.2) (Interface) Represents a string reference of the form SheetName!A1:B5, or a global or local named range. |
| RangeSort | (1.2) Manages sorting operations on Range objects. |
| RangeView | (1.3) Represents a set of visible cells of the parent range. |
| RangeViewCollection | (1.3) Represents a collection of RangeView objects. |
| RemoveDuplicatesResult | (1.9) Represents the results from the removeDuplicates method on range. |
| ReplaceCriteria | (Interface) Represents the replace criteria to be used. |
| RequestContext | (1.1) The RequestContext object facilitates requests to the Excel application. |
| RowColumnPivotHierarchy | (1.8) Represents the Excel RowColumnPivotHierarchy. |
| RowColumnPivotHierarchyCollection | (1.8) Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable. |
| RowProperties | (1.9) (Interface) Represents the returned properties of getRowProperties. |
| RowPropertiesLoadOptions | (1.9) (Interface) Represents which row properties to load, when used as part of a "range.getRowProperties" method. |
| RunOptions | (?) (Interface) |
| Runtime | (1.5) Represents the Excel Runtime class. |
| SearchCriteria | (1.9) (Interface) Represents the search criteria to be used. |
| Session | (?) Represents a connection session for a remote workbook |
| SettableCellProperties | (1.9) (Interface) Represents the input parameter of setCellProperties. |
| SettableColumnProperties | (1.9) (Interface) Represents the input parameter of setColumnProperties. |
| SettableRowProperties | (1.9) (Interface) Represents the input parameter of setRowProperties. |
| Setting | (1.4) Represents a key-value pair of a setting persisted to the document (per file per add-in). |
| SettingCollection | (1.4) Represents a collection of key-value pair setting objects that are part of the workbook. |
| Shape | (1.9) Represents a generic shape object in the worksheet. |
| ShapeCollection | (1.9) Represents a collection of all the shapes in the worksheet. |
| ShapeFill | (1.9) Represents the fill formatting of a shape object. |
| ShapeFont | (1.9) Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object. |
| ShapeGroup | (1.9) Represents a shape group inside a worksheet. |
| ShapeLineFormat | (1.9) Represents the line formatting for the shape object. |
| ShowAsRule | (1.8) (Interface) |
| Slicer | (1.10) Represents a slicer object in the workbook. |
| SlicerCollection | (1.10) Represents a collection of all the slicer objects on the workbook or a worksheet. |
| SlicerItem | (1.10) Represents a slicer item in a slicer. |
| SlicerItemCollection | (1.10) Represents a collection of all the slicer item objects on the slicer. |
| SlicerStyle | (1.10) Represents a Slicer Style, which defines style elements by region of the slicer. |
| SlicerStyleCollection | (1.10) Represents a collection of SlicerStyle objects. |
| SortField | (1.2) Represents a condition in a sorting operation. |
| Style | (1.7) An object encapsulating a style's format and other properties. |
| StyleCollection | (1.7) Represents a collection of all the styles. |
| Subtotals | (1.8) (Interface) Subtotals for the Pivot Field. |
| Table | (1.1) Represents an Excel table. |
| TableCollection | (1.1) Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached. |
| TableColumn | (1.1) Represents a column in a table. |
| TableColumnCollection | (1.1) Represents a collection of all the columns that are part of the table. |
| TableRow | (1.1) Represents a row in a table. |
| TableRowCollection | (1.1) Represents a collection of all the rows that are part of the table. |
| TableScopedCollection | (1.9) Represents a scoped collection of tables. |
| TableSort | (1.2) Manages sorting operations on Table objects. |
| TableStyle | (1.10) Represents a TableStyle, which defines the style elements by region of the Table. |
| TableStyleCollection | (1.10) Represents a collection of TableStyles. |
| Task | (beta) Represents a task. |
| TaskChanges | (beta) Represents a set of intended changes for a task. |
| TaskCollection | (beta) Represents a collection of tasks. |
| TaskHistoryRecord | (beta) Represents a recorded change to the task. |
| TaskHistoryRecordCollection | (beta) Represents a collection of history records for a task. |
| TextConditionalFormat | (1.6) Represents a specific text conditional format. |
| TextFrame | (1.9) Represents the text frame of a shape object. |
| TextRange | (1.9) Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text. |
| TimelineStyle | (1.10) Represents a Timeline style, which defines style elements by region in the Timeline. |
| TimelineStyleCollection | (1.10) Represents a collection of TimelineStyles. |
| TopBottomConditionalFormat | (1.6) Represents a Top/Bottom conditional format. |
| TrackedObjectsCollection | (1.1) no longer available |
| User | (beta) Represents information about an Excel user. |
| Workbook | (1.1) Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc. |
| WorkbookCreated | (1.8) The WorkbookCreated object is the top level object created by Application.CreateWorkbook. |
| WorkbookProtection | (1.7) Represents the protection of a workbook object. |
| WorkbookRangeAreas | (1.12) Represents a collection of one or more rectangular ranges in multiple worksheets. |
| Worksheet | (1.1) An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc. |
| WorksheetCollection | (1.1) Represents a collection of worksheet objects that are part of the workbook. |
| WorksheetFreezePanes | (1.7) Represents the Excel FreezePane. |
| WorksheetFunctions | (1.2) no longer available |
| WorksheetProtection | (1.2) Represents the protection of a sheet object. |
| WorksheetProtectionOptions | (1.2) (Interface) Represents the options in sheet protection. |
| WorksheetSearchCriteria | (Interface) Represents the worksheet search criteria to be used. |
| Application (1.1) Represents the Excel application that manages the workbook. |
| AutoFilter (1.9) Represents the AutoFilter object and turns column values into specific filters based on the cell contents. |
| BasicDataValidation (1.8) (Interface) Represents the Basic Type data validation criteria. |
| Binding (1.1) Represents an Office.js binding that is defined in the workbook. |
| BindingCollection (1.1) Represents the collection of all the binding objects in the workbook. |
| CellBorder (1.9) (Interface) Represents the properties of a single border. |
| CellBorderCollection (1.9) (Interface) Represents the format.borders properties. |
| CellProperties (1.9) (Interface) Represents the returned properties of getCellProperties. |
| CellPropertiesBorderLoadOptions (1.9) (Interface) Specifies which properties to load on the format.borders object. |
| CellPropertiesFill (1.9) (Interface) Represents the format.fill properties. |
| CellPropertiesFillLoadOptions (1.9) (Interface) Specifies which properties to load on the format.fill object. |
| CellPropertiesFont (1.9) (Interface) Represents the format.font properties. |
| CellPropertiesFontLoadOptions (1.9) (Interface) Specifies which properties to load on the format.font object. |
| CellPropertiesFormat (1.9) (Interface) Represents the returned format properties of getCellProperties or format input parameter of setCellProperties. |
| CellPropertiesFormatLoadOptions (1.9) (Interface) Represents which properties to load on the format object. |
| CellPropertiesLoadOptions (1.9) (Interface) Represents which cell properties to load, when used as part of a "range.getCellProperties" method. |
| CellPropertiesProtection (1.9) (Interface) Represents the format.protection properties. |
| CellValueConditionalFormat (1.6) Represents a cell value conditional format. |
| Chart (1.1) Represents a chart object on a worksheet. |
| ChartAreaFormat (1.1) Represents all the format properties of the chart area. |
| ChartAxes (1.1) Represents the chart axes |
| ChartAxis (1.1) Represents a single chart axis. |
| ChartAxisFormat (1.1) Represents all the format properties of a single chart axis. |
| ChartAxisTitle (1.1) Represents the title of a single chart axis. |
| ChartAxisTitleFormat (1.1) Represents all the format properties of a single chart axis title. |
| ChartBinOptions (1.9) Represents the bin options for histogram and pareto charts. |
| ChartBorder (1.7) Represents the border formatting of a chart element. |
| ChartBoxwhiskerOptions (1.9) Represents all the properties of a box whisker chart. |
| ChartCollection (1.1) Represents the collection of all the charts on a worksheet (or in workbook ?) |
| ChartDataLabel (1.7) Represents the data label of a chart point. |
| ChartDataLabelFormat (1.1) Represents all the format properties of a data label of a chart point. |
| ChartDataLabels (1.1) Represents the collection of all the data labels on a chart point. |
| ChartErrorBars (1.9) Represents the error bars of a chart. |
| ChartErrorBarsFormat (1.9) Represents all the format properties of the error bars of a chart. |
| ChartFill (1.1) Represents the fill formatting of a chart element. |
| ChartFont (1.1) Represents the font attributes for a chart element. |
| ChartFormatString (1.7) Represents the substring in any chart related objects (ChartTitle, ChartAxisTitle) |
| ChartGridlines (1.1) Represents the major and minor gridlines of a chart. |
| ChartGridlinesFormat (1.1) Represents all the formatting properties for the gridlines. |
| ChartLegend (1.1) Represents the chart legend. |
| ChartLegendEntry (1.7) Represents the legend entry for the chart legend. |
| ChartLegendEntryCollection (1.7) Represents the collection of all the legend entries. |
| ChartLegendFormat (1.1) Represents all the formatting properties for the legend. |
| ChartLineFormat (1.1) Represents all the formatting properties for a line. |
| ChartMapOptions (1.9) Represents the options for a region map chart. |
| ChartPivotOptions (1.9) Represents the options for a pivot chart. |
| ChartPlotArea (1.8) Represents the chart plot area. |
| ChartPlotAreaFormat (1.8) Represents all the formatting properties for the plot area. |
| ChartPoint (1.1) Represents a single point on a series. |
| ChartPointFormat (1.1) Represents all the formatting properties for a single point on a series. |
| ChartPointsCollection (1.1) Represents a collection of all the points on a series. |
| ChartSeries (1.1) Represents a chart series. |
| ChartSeriesCollection (1.1) Represents the collection of all the chart series on a chart. |
| ChartSeriesFormat (1.1) Represents all the formatting properties for all the chart series on a chart. |
| ChartTitle (1.1) Represents a chart title. |
| ChartTitleFormat (1.1) Represents all the formatting properties for a chart title. |
| ChartTrendLine (1.7) Represents a chart trend line. |
| ChartTrendLineCollection (1.7) Represents the collection of all the chart trend lines on a chart. |
| ChartTrendLineFormat (1.7) Represents all the formatting properties for a trend line. |
| ChartTrendLineLabel (1.8) Represents a label on a chart trend line. |
| ChartTrendLineLabelFormat (1.8) Represents all the formatting properties for the label on a chart trend line. |
| ColorScaleConditionalFormat (1.6) Represents ColorScale criteria for conditional formatting. |
| ColumnProperties (1.9) (Interface) Represents the returned properties of getColumnProperties. |
| ColumnPropertiesLoadOptions (1.9) (Interface) Represents which column properties to load, when used as part of a "range.getColumnProperties" method. |
| Comment (1.10) Represents a comment in the workbook. |
| CommentCollection (1.10) Represents a collection of comment objects that are part of the workbook. |
| CommentDetail (1.12) Represents a structure for the comment ID and IDs of its related replies. |
| CommentMention (1.12) Represents the entity that is mentioned in comments. |
| CommentReply (1.10) Represents a comment reply in the workbook. |
| CommentReplyCollection (1.10) Represents a collection of comment reply objects that are part of the comment. |
| CommentRichContent (1.11) Represents the content contained within a comment or comment reply. |
| ConditionalCellValueRule (1.6) (Interface) Represents a cell value conditional format rule. |
| ConditionalColorScaleCriteria (1.6) (Interface) Represents the criteria of the color scale. |
| ConditionalColorScaleCriterion (1.6) (Interface) Represents a Color Scale Criterion which contains a type, value, and a color. |
| ConditionalDatabarNegativeFormat (1.6) Represents a conditional format DataBar Format for the negative side of the data bar. |
| ConditionalDatabarPositiveFormat (1.6) Represents a conditional format DataBar Format for the positive side of the data bar. |
| ConditionalDatabarRule (1.6) (Interface) Represents a rule-type for a Data Bar. |
| ConditionalFormat (1.6) Represents all the properties associated with a conditional format's range, format, rule, and other properties. |
| ConditionalFormatCollection (1.6) Represents a collection of all the conditional formats that are overlap the range. |
| ConditionalFormatRule (1.6) Represents a rule, for all traditional rule/format pairings. |
| ConditionalIconCriterion (1.6) (Interface) Represents an Icon Criterion which contains a type, value, an Operator, and an optional custom icon, if not using an iconset. |
| ConditionalPresetCriteriaRule (1.6) (Interface) Represents the Preset Criteria Conditional Format Rule. |
| ConditionalRangeBorder (1.6) Represents the border of an object. |
| ConditionalRangeBorderCollection (1.6) Represents the border objects that make up range border. |
| ConditionalRangeFill (1.6) Represents the background of a conditional range object. |
| ConditionalRangeFont (1.6) Represents the font attributes (font style, color, etc.) for an object. |
| ConditionalRangeFormat (1.6) Represents all the formatting properties range's font, fill, borders, and other properties. |
| ConditionalTextComparisonRule (1.6) (Interface) Represents a Cell Value Conditional Format Rule. |
| ConditionalTopBottomRule (1.6) (Interface) Represents the rule of the top/bottom conditional format. |
| CultureInfo (1.11) Provides information based on current system culture settings. |
| CustomConditionalFormat (1.6) Represents a custom conditional format type. |
| CustomDataValidation (1.8) (Interface) Represents the Custom data validation criteria. |
| CustomProperty (1.7) Represents a custom property. |
| CustomPropertyCollection (1.7) Represents the collection of all the custom properties. |
| CustomXmlPart (1.5) Represents a custom XML part object in a workbook. |
| CustomXmlPartCollection (1.5) Represents the collection of custom XML parts. |
| CustomXmlPartScopedCollection (1.5) Represents a scoped collection of custom XML parts. |
| DatabarConditionalFormat (1.6) Represents a conditional formatting data bar. |
| DataConnectionCollection (1.7) Represents a collection of all the Data Connections that are part of the workbook or worksheet. |
| DataPivotHierarchy (1.8) Represents the Excel DataPivotHierarchy. |
| DataPivotHierarchyCollection (1.8) Represents a collection of DataPivotHierarchy items associated with the PivotTable. |
| DataValidation (1.8) Represents the data validation applied to the current range. |
| DataValidationErrorAlert (1.8) (Interface) Represents the error alert properties for the data validation. |
| DataValidationPrompt (1.8) (Interface) Represents the user prompt properties for the data validation. |
| DataValidationRule (1.8) (Interface) Represents the Data validation rule that contains different types of data validation. |
| DateTimeDataValidation (1.8) Represents the Date data validation criteria. |
| DateTimeFormatInfo (1.12) Defines the culturally appropriate format of displaying numbers. |
| DocumentProperties (1.7) Represents workbook properties. |
| Filter (1.2) Represents the filtering of a table's column. |
| FilterCriteria (1.2) (Interface) Represents the filtering criteria applied to a column. |
| FilterDatetime (1.2) (Interface) Represents how to filter a date when filtering on values. |
| FilterPivotHierarchy (1.8) Represents the Excel FilterPivotHierarchy. |
| FilterPivotHierarchyCollection (1.8) Represents a collection of FilterPivotHierarchy items associated with the PivotTable. |
| FormatProtection (1.2) Represents the format protection of a range object. |
| FunctionResult (1.2) Represents the result of a function-evaluation operation |
| Functions (1.2) Represents an object for evaluating Excel functions. |
| GeometricShape (1.9) Represents a geometric shape inside a worksheet. |
| GroupShapeCollection (1.9) Represents the shape collection inside a shape group. |
| HeaderFooter (1.9) Represents the Excel HeaderFooter. |
| HeaderFooterGroup (1.9) Represents the Excel HeaderFooterGroup. |
| Icon (1.2) (Interface) Represents a cell icon. |
| IconSetConditionalFormat (1.6) Represents an IconSet criteria for conditional formatting. |
| Image (1.9) Represents an image in the worksheet. |
| IterativeCalculation (1.9) Represents the Iterative Calculation settings. |
| Line (1.9) Represents a line inside a worksheet. |
| LinkedDataType (beta) Represents a linked data type. |
| LinkedDataTypeCollection (beta) Represents a collection of linked data types. |
| ListDataValidation (1.8) (Interface) Represents the List data validation criteria. |
| LoadOption (1.2) (Interface) |
| NamedItem (1.1) Represents a defined name for a range of cells or value. |
| NamedItemArrayValues (1.7) Represents an object containing values and types of a named item. |
| NamedItemCollection (1.1) Represents a collection of all the NamedItem objects that are part of the workbook or worksheet. |
| NamedSheetView (beta) Represents a named sheet view of a worksheet. |
| NamedSheetViewCollection (beta) Represents the collection of sheet views in the worksheet. |
| NumberFormatInfo (1.11) Defines the culturally appropriate format of displaying numbers. |
| PageBreak (1.9) Represents the Excel PageBreak. |
| PageBreakCollection (1.9) Represents the Excel PageBreakCollection. |
| PageLayout (1.9) Represents layout and print settings that are not dependent any printer-specific implementation. |
| PageLayoutMarginOptions (1.9) (Interface) Represents the options in page layout margins. |
| PageLayoutZoomOptions (1.9) (Interface) Represents page zoom properties. |
| PivotDateFilter (1.12) Configurable template for a date filter to apply to a PivotField. |
| PivotField (1.8) Represents a pivot field. |
| PivotFieldCollection (1.8) Represents the collection of all the pivot fields in the pivot table. |
| PivotFilters (1.12) (Interface) Represents all PivotFilters currently applied to a given PivotField. |
| PivotHierarchy (1.8) Represents the Excel PivotHierarchy. |
| PivotHierarchyCollection (1.8) Represents a collection of all the PivotHierarchies that are part of the PivotTable. |
| PivotItem (1.8) Represents a pivot item. |
| PivotItemCollection (1.8) Represents a collection of all the PivotItems related to their parent PivotField. |
| PivotLabelFilter (1.12) Configurable template for a label filter to apply to a PivotField. |
| PivotLayout (1.8) Represents the visual layout of the PivotTable. |
| PivotManualFilter (1.12) Configurable template for a manual filter to apply to a PivotField. |
| PivotTable (1.3) Represents a pivot table |
| PivotTableCollection (1.3) Represents the collection of all the pivot tables in the workbook. |
| PivotTableScopedCollection (1.12) Represents a scoped collection of PivotTables. |
| PivotTableStyle (1.10) Represents a PivotTable Style, which defines style elements by PivotTable region. |
| PivotTableStyleCollection (1.10) Represents a collection of PivotTable styles. |
| PivotValueFilter (1.12) (Interface) Configurable template for a value filter to apply to a PivotField. |
| PresetCriteriaConditionalFormat (1.6) Represents the the preset criteria conditional format such as above average, below average, unique values, contains blank, nonblank, error, and noerror. |
| Range (1.1) Represents a set of one or more contiguous cells such as a cell, a row, a column, block of cells, etc. |
| RangeAreas (1.9) Represents a collection of one or more rectangular ranges in the same worksheet. |
| RangeAreasCollection (1.12) Contains the collection of cross-worksheets level Ranges. |
| RangeBorder (1.1) Represents the border of an object. |
| RangeBorderCollection (1.1) Represents the border objects that make up the range border. |
| RangeCollection (1.9) Represents the Excel RangeCollection. |
| RangeFill (1.1) Represents the background of a range object. |
| RangeFont (1.1) Represents the font attributes (font name, font size, color, etc.) for an object. |
| RangeFormat (1.1) A format object encapsulating the range's font, fill, borders, alignment, and other properties. |
| RangeHyperlink (1.7) (Interface) Represents the necessary strings to get/set a hyperlink (XHL) object. |
| RangeReference (1.2) (Interface) Represents a string reference of the form SheetName!A1:B5, or a global or local named range. |
| RangeSort (1.2) Manages sorting operations on Range objects. |
| RangeView (1.3) Represents a set of visible cells of the parent range. |
| RangeViewCollection (1.3) Represents a collection of RangeView objects. |
| RemoveDuplicatesResult (1.9) Represents the results from the removeDuplicates method on range. |
| ReplaceCriteria (Interface) Represents the replace criteria to be used. |
| RequestContext (1.1) The RequestContext object facilitates requests to the Excel application. |
| RowColumnPivotHierarchy (1.8) Represents the Excel RowColumnPivotHierarchy. |
| RowColumnPivotHierarchyCollection (1.8) Represents a collection of RowColumnPivotHierarchy items associated with the PivotTable. |
| RowProperties (1.9) (Interface) Represents the returned properties of getRowProperties. |
| RowPropertiesLoadOptions (1.9) (Interface) Represents which row properties to load, when used as part of a "range.getRowProperties" method. |
| RunOptions (?) (Interface) |
| Runtime (1.5) Represents the Excel Runtime class. |
| SearchCriteria (1.9) (Interface) Represents the search criteria to be used. |
| Session (?) Represents a connection session for a remote workbook |
| SettableCellProperties (1.9) (Interface) Represents the input parameter of setCellProperties. |
| SettableColumnProperties (1.9) (Interface) Represents the input parameter of setColumnProperties. |
| SettableRowProperties (1.9) (Interface) Represents the input parameter of setRowProperties. |
| Setting (1.4) Represents a key-value pair of a setting persisted to the document (per file per add-in). |
| SettingCollection (1.4) Represents a collection of key-value pair setting objects that are part of the workbook. |
| Shape (1.9) Represents a generic shape object in the worksheet. |
| ShapeCollection (1.9) Represents a collection of all the shapes in the worksheet. |
| ShapeFill (1.9) Represents the fill formatting of a shape object. |
| ShapeFont (1.9) Represents the font attributes, such as font name, font size, and color, for a shape's TextRange object. |
| ShapeGroup (1.9) Represents a shape group inside a worksheet. |
| ShapeLineFormat (1.9) Represents the line formatting for the shape object. |
| ShowAsRule (1.8) (Interface) |
| Slicer (1.10) Represents a slicer object in the workbook. |
| SlicerCollection (1.10) Represents a collection of all the slicer objects on the workbook or a worksheet. |
| SlicerItem (1.10) Represents a slicer item in a slicer. |
| SlicerItemCollection (1.10) Represents a collection of all the slicer item objects on the slicer. |
| SlicerStyle (1.10) Represents a Slicer Style, which defines style elements by region of the slicer. |
| SlicerStyleCollection (1.10) Represents a collection of SlicerStyle objects. |
| SortField (1.2) Represents a condition in a sorting operation. |
| Style (1.7) An object encapsulating a style's format and other properties. |
| StyleCollection (1.7) Represents a collection of all the styles. |
| Subtotals (1.8) (Interface) Subtotals for the Pivot Field. |
| Table (1.1) Represents an Excel table. |
| TableCollection (1.1) Represents a collection of all the tables that are part of the workbook or worksheet, depending on how it was reached. |
| TableColumn (1.1) Represents a column in a table. |
| TableColumnCollection (1.1) Represents a collection of all the columns that are part of the table. |
| TableRow (1.1) Represents a row in a table. |
| TableRowCollection (1.1) Represents a collection of all the rows that are part of the table. |
| TableScopedCollection (1.9) Represents a scoped collection of tables. |
| TableSort (1.2) Manages sorting operations on Table objects. |
| TableStyle (1.10) Represents a TableStyle, which defines the style elements by region of the Table. |
| TableStyleCollection (1.10) Represents a collection of TableStyles. |
| Task (beta) Represents a task. |
| TaskChanges (beta) Represents a set of intended changes for a task. |
| TaskCollection (beta) Represents a collection of tasks. |
| TaskHistoryRecord (beta) Represents a recorded change to the task. |
| TaskHistoryRecordCollection (beta) Represents a collection of history records for a task. |
| TextConditionalFormat (1.6) Represents a specific text conditional format. |
| TextFrame (1.9) Represents the text frame of a shape object. |
| TextRange (1.9) Contains the text that is attached to a shape, in addition to properties and methods for manipulating the text. |
| TimelineStyle (1.10) Represents a Timeline style, which defines style elements by region in the Timeline. |
| TimelineStyleCollection (1.10) Represents a collection of TimelineStyles. |
| TopBottomConditionalFormat (1.6) Represents a Top/Bottom conditional format. |
| TrackedObjectsCollection (1.1) no longer available |
| User (beta) Represents information about an Excel user. |
| Workbook (1.1) Workbook is the top level object which contains related workbook objects such as worksheets, tables, ranges, etc. |
| WorkbookCreated (1.8) The WorkbookCreated object is the top level object created by Application.CreateWorkbook. |
| WorkbookProtection (1.7) Represents the protection of a workbook object. |
| WorkbookRangeAreas (1.12) Represents a collection of one or more rectangular ranges in multiple worksheets. |
| Worksheet (1.1) An Excel worksheet is a grid of cells. It can contain data, tables, charts, etc. |
| WorksheetCollection (1.1) Represents a collection of worksheet objects that are part of the workbook. |
| WorksheetFreezePanes (1.7) Represents the Excel FreezePane. |
| WorksheetFunctions (1.2) no longer available |
| WorksheetProtection (1.2) Represents the protection of a sheet object. |
| WorksheetProtectionOptions (1.2) (Interface) Represents the options in sheet protection. |
| WorksheetSearchCriteria (Interface) Represents the worksheet search criteria to be used. |
© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited Top