Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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. |