PivotTable.Slicers Property

Gets the Slicers collection for the specified PivotTable.

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

Syntax

'Declaration
ReadOnly Property Slicers As Slicers
    Get
'Usage
Dim instance As PivotTable
Dim value As Slicers

value = instance.Slicers
Slicers Slicers { get; }

Property Value

Type: Microsoft.Office.Interop.Excel.Slicers
The Slicers collection for the specified PivotTable.

Remarks

Read-only.

Slicers can be used to filter data in PivotTable reports. The Slicers collection contains Slicer objects that represent the slicers that are associated with the specified PivotTable.

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace