SlicerItem Interface

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

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

Attributes: GuidAttribute InterfaceTypeAttribute

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	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	Gets the label text for the slicer item.
Creator	Gets a 32-bit integer that indicates the application in which this object was created.
HasData	Gets whether the slicer item contains data that matches the current manual filter state.
Name	Gets the name of the slicer item.
Parent	Gets the parent SlicerCache object for the slicer item.
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	Gets the source name of the slicer item.
SourceNameStandard	Gets the slicer item's source name in standard English (United States) format settings.
Value	Gets the value of the slicer item.

Applies to