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 |
|---|---|
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. |
|
Represents the border of the data bars specified by a conditional formatting rule. |
|
Represents the display settings for an associated Range object. Read only. |
|
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule. |
|
Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source. |
|
Represents a Protected View window. |
|
A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application. |
|
Represents a slicer in a workbook. |
|
Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to. |
|
Represents a level of a hierarchy in an OLAP data source being filtered by a slicer. |
|
Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer. |
|
Represents the collection of slicer caches associated with the specified workbook. |
|
Represents an item in a slicer. |
|
Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object. |
|
Represents information about the collection of PivotTables associated with the specified SlicerCache. object |
|
A collection of Slicer objects. |
|
Represents the settings for the horizontal and vertical axes of a group of sparklines. |
|
Represents the color of the markers for points in a sparkline. |
|
Represents the settings for the horizontal axes of a group of sparklines. |
|
Represents a single sparkline. |
|
Represents a group of sparklines. |
|
Represents a collection of sparkline groups. |
|
Represents the settings of the markers for points of data on a sparkline. |
|
Represents the settings for the vertical axes of a group of sparklines. |
|
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 |
|---|---|
Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. |
|
Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
|
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. |
|
Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. |
|
Specifies the axis position for a range of cells with conditional formatting as data bars. |
|
Specifies the border of a data bar. |
|
Specifies how a data bar is filled with color. |
|
Specifies whether to use the same border and fill color as postive data bars. |
|
Specifies how to validate the data caches for PivotTable reports. |
|
Specifies the icon for a criterion in an icon set conditional formatting rule. |
|
Specifies the horizontal overflow setting for a text frame. |
|
Specifies the vertical overflow setting for a text frame. |
|
Specifies which position on the slice to return the coordinate of. |
|
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. |
|
Specifies whether to repeat all field item labels in a PivotTable report. |
|
Specifies the mode for checking the spelling of Portuguese. |
|
Specifies how the Protected View window was closed. |
|
Specifies the state of the Protected View window. |
|
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
|
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. |
|
Specifies the mode for checking the spelling of Spanish. |
|
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
|
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
|
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 |
|---|---|
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. |
|
Represents the border of the data bars specified by a conditional formatting rule. |
|
Represents the display settings for an associated Range object. Read only. |
|
Represents a file converter that is used to save files. |
|
A collection of FileExportConverter objects that represent all the file converters available for saving files. |
|
Represents the color settings of the data bars for negative values that are defined by a data bar conditional formating rule. |
|
Represents the list of changes a user has made to value cells in a PivotTable report based on an OLAP data source. |
|
Represents a Protected View window. |
|
A collection of the ProtectedViewWindow objects that represent all the Protected View windows that are currently open in the application. |
|
Represents a slicer in a workbook. |
|
Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to. |
|
Represents a level of a hierarchy in an OLAP data source being filtered by a slicer. |
|
Represents the collection of hierarchy levels for the OLAP data source that is filtered by a slicer. |
|
Represents the collection of slicer caches associated with the specified workbook. |
|
Represents an item in a slicer. |
|
Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object. |
|
Represents information about the collection of PivotTables associated with the specified SlicerCache. object |
|
A collection of Slicer objects. |
|
Represents the settings for the horizontal and vertical axes of a group of sparklines. |
|
Represents the color of the markers for points in a sparkline. |
|
Represents the settings for the horizontal axes of a group of sparklines. |
|
Represents a single sparkline. |
|
Represents a group of sparklines. |
|
Represents a collection of sparkline groups. |
|
Represents the settings of the markers for points of data on a sparkline. |
|
Represents the settings for the vertical axes of a group of sparklines. |
|
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 |
|---|---|
Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. |
|
Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
|
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. |
|
Specifies whether a PivotTable value cell has been edited or recalculated since the PivotTable report was created or the last commit operation was performed. |
|
Specifies the axis position for a range of cells with conditional formatting as data bars. |
|
Specifies the border of a data bar. |
|
Specifies how a data bar is filled with color. |
|
Specifies whether to use the same border and fill color as postive data bars. |
|
Specifies how to validate the data caches for PivotTable reports. |
|
Specifies the icon for a criterion in an icon set conditional formatting rule. |
|
Specifies the horizontal overflow setting for a text frame. |
|
Specifies the vertical overflow setting for a text frame. |
|
Specifies which position on the slice to return the coordinate of. |
|
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. |
|
Specifies whether to repeat all field item labels in a PivotTable report. |
|
Specifies the mode for checking the spelling of Portuguese. |
|
Specifies how the Protected View window was closed. |
|
Specifies the state of the Protected View window. |
|
Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
|
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. |
|
Specifies the mode for checking the spelling of Spanish. |
|
Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
|
Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
|
Specifies the type of sparkline. |