SlicerItem Interface
Represents an item in a slicer.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<GuidAttribute("000244C9-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface SlicerItem
'Usage
Dim instance As SlicerItem
[GuidAttribute("000244C9-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface SlicerItem
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.