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.