Share via


SlicerItems Interface

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<GuidAttribute("000244CA-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface SlicerItems _
    Inherits IEnumerable
'Usage
Dim instance As SlicerItems
[GuidAttribute("000244CA-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface SlicerItems : IEnumerable

Remarks

To access the SlicerItems collection that represents the items in a slicer based on data in the workbook or non-OLAP external data, use the SlicerItems property of the SlicerCache object that is associated with the slicer.

To access the SlicerItems collection that represents the items in a slicer based on OLAP data connection, use the SlicerItems property of the SlicerCacheLevel object that represents a level of the hierarchy.

See Also

Reference

SlicerItems Members

Microsoft.Office.Interop.Excel Namespace