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.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top