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.