Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Represents an item in a slicer.
public interface class SlicerItem
[System.Runtime.InteropServices.Guid("000244C9-0000-0000-C000-000000000046")] [System.Runtime.InteropServices.InterfaceType(2)] public interface SlicerItem
Public Interface SlicerItem
To access the SlicerItem object that represents the currently selected button in the slicer, use the ActiveItem property of the Slicer object. To access the SlicerItems collection that represents all the items in a slicer filtering a PivotTable, use the SlicerItems property of the SlicerCache object that is associated with the Slicer object. To access the SlicerItems collection that represent the items in a slicer filtering a level of an OLAP hierarchy, use the SlicerItems property of the SlicerCacheLevel object that represents that level of the hierarchy.
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object.
Gets the label text for the slicer item.
Gets a 32-bit integer that indicates the application in which this object was created.
Gets whether the slicer item contains data that matches the current manual filter state.
Gets the name of the slicer item.
Gets the parent SlicerCache object for the slicer item.
Gets or sets whether the slicer item is selected. Read/write for slicers connected to non-OLAP data sources. Read-only for slicers connected to OLAP data sources.
Gets the source name of the slicer item.
Gets the slicer item's source name in standard English (United States) format settings.
Gets the value of the slicer item.