Partager via


Slicer Interface

Represents a slicer in a workbook.

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

Syntax

'Declaration
<GuidAttribute("000244C8-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface Slicer
'Usage
Dim instance As Slicer
[GuidAttribute("000244C8-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface Slicer

Remarks

Each Slicer object represents a slicer in a workbook. Slicers are used to filter data in PivotTable reports or OLAP data sources.

Use the Add() method to add a Slicer object to the Slicers collection. To access the SlicerItem object that represents the currently selected button in a slicer, use the ActiveItem() property of the Slicer object.

See Also

Reference

Slicer Members

Microsoft.Office.Interop.Excel Namespace