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. |
© 2023 Better Solutions Limited. All Rights Reserved. © 2023 Better Solutions Limited Top