Slicer Slicer Slicer Interface

Definition

Represents a slicer in a workbook.

public interface class Slicer
[System.Runtime.InteropServices.Guid("000244C8-0000-0000-C000-000000000046")]
[System.Runtime.InteropServices.InterfaceType(2)]
public interface Slicer
Public Interface Slicer
Attributes

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 Microsoft.Office.Interop.Excel.Slicers.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.

Properties

ActiveItem ActiveItem ActiveItem

Returns a SlicerItem object that represents the slicer button that is currently in focus for the specified slicer. Read-only.

Application Application Application

When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object.

Caption Caption Caption

Gets or sets the caption of the specified slicer.

ColumnWidth ColumnWidth ColumnWidth

Gets or sets the width, in points, of each column in the slicer.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

DisableMoveResizeUI DisableMoveResizeUI DisableMoveResizeUI

Gets or sets whether the specified slicer can be moved or resized by using the user interface.

DisplayHeader DisplayHeader DisplayHeader

Gets or sets whether the header that displays the slicer Caption is visible.

Height Height Height

Gets or sets the height of the specified slicer, in points.

Left Left Left

Gets or sets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

Locked Locked Locked

Gets or sets whether the specified slicer can be modified when the sheet that contains it is protected.

Name Name Name

Gets or sets the name of the specified slicer.

NumberOfColumns NumberOfColumns NumberOfColumns

Gets or sets the number of columns in the specified slicer.

Parent Parent Parent

Gets the Worksheet object that represents the sheet that contains the slicer.

RowHeight RowHeight RowHeight

Gets or sets the height, in points, of each row in the specified slicer.

Shape Shape Shape

Gets the Shape object associated with the specified slicer.

SlicerCache SlicerCache SlicerCache

Gets the SlicerCache object associated with the slicer.

SlicerCacheLevel SlicerCacheLevel SlicerCacheLevel

Gets the SlicerCacheLevel object associated with the slicer.

SlicerCacheType SlicerCacheType SlicerCacheType

Returns the type of the slicer cache – slicer or timeline. XlSlicerCacheType Read-only

Style Style Style

Gets or sets the style currently applied to the specified slicer.

TimelineViewState TimelineViewState TimelineViewState

The timeline-specific state of the Slicer. TimelineViewState Read-only

Top Top Top

Gets or sets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

Width Width Width

Gets or sets the width of the specified slicer, in points.

Methods

Copy() Copy() Copy()

Copies the specified slicer to the clipboard.

Cut() Cut() Cut()

Cuts the specified slicer and copies it to the clipboard.

Delete() Delete() Delete()

Deletes the slicer and removes it from the associated Slicers collection.

Applies to