Share via


New Objects, Collections, and Enumerations_Excel.Dev

New Objects and Collections

The following objects and collections have been added to the object model in Microsoft Excel 2010.

Object or Collection

Description

AddIns2

A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.

DataBarBorder

Represents the border of the data bars specified by a conditional formatting rule.

DisplayFormat

Represents the display settings for an associated Range object. Read only.

NegativeBarFormat

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

PivotTableChangeList

Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.

ProtectedViewWindow

Represents a Protected View window.

ProtectedViewWindows

A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.

Slicer

Represents a slicer in a workbook.

SlicerCache

Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.

SlicerCacheLevel

Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.

SlicerCacheLevels

Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.

SlicerCaches

Represents the collection of slicer caches associated with the specified workbook.

SlicerItem

Represents an item in a slicer.

SlicerItems

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

SlicerPivotTables

Represents information about the collection of PivotTables associated with the specified SlicerCache. object

Slicers

A collection of Slicer objects.

SparkAxes

Represents the settings for the horizontal and vertical axes of a group of sparklines.

SparkColor

Represents the color of the markers for points in a sparkline.

SparkHorizontalAxis

Represents the settings for the horizontal axes of a group of sparklines.

Sparkline

Represents a single sparkline.

SparklineGroup

Represents a group of sparklines.

SparklineGroups

Represents a collection of sparkline groups.

SparkPoints

Represents the settings of the markers for points of data on a sparkline.

SparkVerticalAxis

Represents the settings for the vertical axes of a group of sparklines.

ValueChange

Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.

New Enumerations

The following enumerations have been added to the object model in Microsoft Excel 2010.

Enumerations

Description

XlAllocation

Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.

XlAllocationMethod

Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlAllocationValue

Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlCellChangedState

Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.

XlDataBarAxisPosition

Specifies the axis position for a range of cells with conditional formatting as data bars.

XlDataBarBorderType

Specifies the border of a data bar.

XlDataBarFillType

Specifies how a data bar is filled with color.

XlDataBarNegativeColorType

Specifies whether to use the same border and fill color as postive data bars.

XlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

XlIcon

Specifies the icon for a criterion in an icon set conditional formatting rule.

XlOartHorizontalOverflow

Specifies the horizontal overflow setting for a text frame.

XlOartVerticalOverflow

Specifies the vertical overflow setting for a text frame.

XlPieSliceIndex

Specifies which position on the slice to return the coordinate of.

XlPieSliceLocation

Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.

XlPivotFieldRepeatLabels

Specifies whether to repeat all field item labels in a PivotTable report.

XlPortugueseReform

Specifies the mode for checking the spelling of Portuguese.

XlProtectedViewCloseReason

Specifies how the Protected View window was closed.

XlProtectedViewWindowState

Specifies the state of the Protected View window.

XlSlicerCrossFilterType

Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.

XlSlicerSort

Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.

XlSpanishModes

Specifies the mode for checking the spelling of Spanish.

XlSparklineRowCol

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

XlSparkScale

Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

XlSparkType

Specifies the type of sparkline.

New Objects and Collections

The following objects and collections have been added to the object model in Microsoft Excel 2010.

Object or Collection

Description

AddIns2

A collection of AddIn objects that represent all the add-ins that are currently available or open in Microsoft Excel, regardless of whether they are installed.

DataBarBorder

Represents the border of the data bars specified by a conditional formatting rule.

DisplayFormat

Represents the display settings for an associated Range object. Read only.

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.

NegativeBarFormat

Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule.

PivotTableChangeList

Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source.

ProtectedViewWindow

Represents a Protected View window.

ProtectedViewWindows

A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application.

Slicer

Represents a slicer in a workbook.

SlicerCache

Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.

SlicerCacheLevel

Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.

SlicerCacheLevels

Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer.

SlicerCaches

Represents the collection of slicer caches associated with the specified workbook.

SlicerItem

Represents an item in a slicer.

SlicerItems

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

SlicerPivotTables

Represents information about the collection of PivotTables associated with the specified SlicerCache. object

Slicers

A collection of Slicer objects.

SparkAxes

Represents the settings for the horizontal and vertical axes of a group of sparklines.

SparkColor

Represents the color of the markers for points in a sparkline.

SparkHorizontalAxis

Represents the settings for the horizontal axes of a group of sparklines.

Sparkline

Represents a single sparkline.

SparklineGroup

Represents a group of sparklines.

SparklineGroups

Represents a collection of sparkline groups.

SparkPoints

Represents the settings of the markers for points of data on a sparkline.

SparkVerticalAxis

Represents the settings for the vertical axes of a group of sparklines.

ValueChange

Represents a value that has been changed in a PivotTable report that is based on an OLAP data source.

New Enumerations

The following enumerations have been added to the object model in Microsoft Excel 2010.

Enumerations

Description

XlAllocation

Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.

XlAllocationMethod

Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlAllocationValue

Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.

XlCellChangedState

Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed.

XlDataBarAxisPosition

Specifies the axis position for a range of cells with conditional formatting as data bars.

XlDataBarBorderType

Specifies the border of a data bar.

XlDataBarFillType

Specifies how a data bar is filled with color.

XlDataBarNegativeColorType

Specifies whether to use the same border and fill color as postive data bars.

XlFileValidationPivotMode

Specifies how to validate the data caches for PivotTable reports.

XlIcon

Specifies the icon for a criterion in an icon set conditional formatting rule.

XlOartHorizontalOverflow

Specifies the horizontal overflow setting for a text frame.

XlOartVerticalOverflow

Specifies the vertical overflow setting for a text frame.

XlPieSliceIndex

Specifies which position on the slice to return the coordinate of.

XlPieSliceLocation

Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area.

XlPivotFieldRepeatLabels

Specifies whether to repeat all field item labels in a PivotTable report.

XlPortugueseReform

Specifies the mode for checking the spelling of Portuguese.

XlProtectedViewCloseReason

Specifies how the Protected View window was closed.

XlProtectedViewWindowState

Specifies the state of the Protected View window.

XlSlicerCrossFilterType

Specifies the type of cross filtering used by the specified slicer cache and how it is visualized.

XlSlicerSort

Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions.

XlSpanishModes

Specifies the mode for checking the spelling of Spanish.

XlSparklineRowCol

Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range.

XlSparkScale

Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group.

XlSparkType

Specifies the type of sparkline.