Compartilhar via


SlicerCache.SlicerItems Property

Gets a SlicerItems collection that contains the collection of all items in the slicer cache.

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

Syntax

'Declaration
ReadOnly Property SlicerItems As SlicerItems
    Get
'Usage
Dim instance As SlicerCache
Dim value As SlicerItems

value = instance.SlicerItems
SlicerItems SlicerItems { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.SlicerItems
A SlicerItems collection that contains the collection of all items in the slicer cache.

Remarks

Read-only.

The SlicerItems property of the SlicerCache object is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase), or for slicers that are based on PivotTables based on relational data sources (SlicerCache.SourceType = xlExternal and SlicerCache.OLAP = false). Attempting to access the SlicerItems property for slicers that are connected to an external OLAP data source (SlicerCache.OLAP = true) generates a run-time error. For OLAP data sources, use the SlicerItems property of the SlicerCacheLevel object instead.

See Also

Reference

SlicerCache Interface

SlicerCache Members

Microsoft.Office.Interop.Excel Namespace