PivotTable.Slicers property

Office 2013 and later

Gets the Slicers collection for the specified PivotTable.

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

Slicers Slicers { get; }

Property value

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

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.

Show: