AboveAverage |
Represents an above average visual of a conditional formatting rule. Applying a color or fill to a range or selection to help you see the value of a cells relative to other cells. |
Action |
This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
Actions |
This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
ChartFormat |
Provides access to the Office Art formatting for chart elements. |
ChartView |
Represents a view of a chart. |
ColorScale |
Represents a color scale conditional formatting rule. |
ColorScaleCriteria |
A collection of ColorScaleCriterion objects that represents all of the criteria for a color scale conditional format. Each criterion specifies the minimum, midpoint, or maximum threshold for the color scale. |
ColorScaleCriterion |
Represents the criteria for the minimum, midpoint, or maximum thresholds for a color format conditional format. |
ColorStop |
|
ColorStops |
|
ConditionValue |
Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule. |
Connections |
A collection of Connection objects for the specified workbook. |
Databar |
Represents a data bar conditional formating rule. Applying a data bar to a range helps you see the value of a cell relative to other cells. |
DialogSheetView |
Represents the current Dialog sheet view in a workbook. |
FileExportConverter |
Represents a file converter that is used to save files. |
FileExportConverters |
A collection of FileExportConverter objects that represent all the file converters available for saving files. |
FormatColor |
Represents the fill color specified for a threshold of a color scale conditional format or the color of the bar in a data bar conditional format. |
HeaderFooter |
Represents a single header or footer. The HeaderFooter object is a member of the HeadersFooters collection. The HeadersFooters collection includes all headers and footers in the specified workbook section. |
Icon |
Represents a single icon in an icon set used in a conditional formatting rule. |
IconCriteria |
Represents the collection of IconCriterion objects. Each IconCriterion represents the values and threshold type for each icon in an icon set conditional formatting rule. |
IconCriterion |
Represents the criterion for an individual icon in an icon set. The criterion specifies the range of values and the threshold type associated with the icon in an icon set conditional formatting rule. |
IconSet |
Represents a single set of icons that are used in an icon set conditional formatting rule. |
IconSetCondition |
Represents an icon set conditional formatting rule. |
IconSets |
Represents a collection of icon sets used in an icon set conditional formatting rule. |
LinearGradient |
The LinearGradient object transitions through a series of colors in a linear manner along a specific angle. |
MultiThreadedCalculation |
Returns or sets the concurrent calculation mode. |
ODBCConnection |
Represents the ODBC connection. |
OLEDBConnection |
Represents the OLE DB connection. |
Page |
Represents a page in a workbook. Use the PageSetup object and the related methods and properties for programmatically defining page layout in a workbook. |
Pages |
A collection of pages in a document. Use the Pages collection and the related objects and properties for programmatically defining page layout in a workbook. |
PivotAxis |
The PivotAxis object is used for asymmetric drilling in a PivotTable. |
PivotFilter |
A PivotFilter is applied to a PivotField object. |
PivotFilters |
The PivotFilters object is a collection of PivotFilter objects. |
PivotLine |
A PivotLine object is a line of rows or columns in an Excel PivotTable. |
PivotLineCells |
Collection of PivotCell objects for a specific PivotLine. |
PivotLines |
The PivotLines object is a collection of lines in a PivotTable, containing all lines on rows or columns of the pivot. Each line is a set of PivotCells. |
Ranges |
A collection of Range objects that represent worksheets in a workbook. |
RectangularGradient |
The RectangularGradient object transitions through a series of colors in a linear manner along a specific angle. |
Research |
This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
ServerViewableItems |
A collection of objects that have been marked as viewable on the server. |
SheetViews |
A collection of all the sheet views in the specified or active workbook window. |
Sort |
Represents a sort of a range of data. |
SortField |
The SortField object contains all the sort information for the Worksheet, Lists, and AutoFilter objects. |
SortFields |
The SortFields collection is a collection of SortField objects. It allows developers to store a sort state on workbooks, lists, and autofilters. |
TableStyle |
Represents a single style that can be applied to a table. |
TableStyleElement |
Represents a single table style element. |
TableStyleElements |
Represents table style elements. |
TableStyles |
Represents styles that can be applied to a table. |
TextFrame2 |
Represents the text frame in a Shape, ShapeRange, or ChartFormat object. |
Top10 |
This topic is a placeholder for future content. It is included in this preliminary documentation to illustrate the proposed structure of the final content. |
UniqueValues |
The UniqueValues object uses the DupeUnique property to returns or sets an enum that determines whether the rule should look for duplicate or unique values in the range. |
WorkbookConnection |
A connection is a set of information needed to obtain data from an external data source other than an Microsoft Office Excel 2007 workbook. |
WorksheetView |
A collection of all the WorksheetView objects in the specified or active workbook. |