SlicerItem SlicerItem SlicerItem Interface

Definition

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
Attributes

Remarks

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.

Properties

Application Application Application

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.

Caption Caption Caption

Gets the label text for the slicer item.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

HasData HasData HasData

Gets whether the slicer item contains data that matches the current manual filter state.

Name Name Name

Gets the name of the slicer item.

Parent Parent Parent

Gets the parent SlicerCache object for the slicer item.

Selected Selected Selected

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.

SourceName SourceName SourceName

Gets the source name of the slicer item.

SourceNameStandard SourceNameStandard SourceNameStandard

Gets the slicer item's source name in standard English (United States) format settings.

Value Value Value

Gets the value of the slicer item.

Applies to