## Slicer class

summary description of Slicer View

## Properties

| Name | Type | Description |
| --- | --- | --- |
| [SortOrderType](#sortordertype) | int | The value of the property is SortOrder integer constant. |
| [ShowMissing](#showmissing) | boolean |  |
| [ShowTypeOfItemsWithNoData](#showtypeofitemswithnodata) | int | The value of the property is ItemsWithNoDataShowMode integer constant. |
| [ShowAllItems](#showallitems) | boolean |  |
| [Title](#title) | String | Specifies the title of the current Slicer object. |
| [AlternativeText](#alternativetext) | String | Returns or sets the descriptive (alternative) text string of the Slicer object. |
| [IsPrintable](#isprintable) | boolean | Indicates whether the slicer object is printable. |
| [IsLocked](#islocked) | boolean | Indicates whether the slicer shape is locked. |
| [Placement](#placement) | int | Represents the way the drawing object is attached to the cells below it. The property controls the placement of an objec |
| [LockedAspectRatio](#lockedaspectratio) | boolean | Indicates whether locking aspect ratio. |
| [LockedPosition](#lockedposition) | boolean | Indicates whether the specified slicer can be moved or resized by using the user interface. |
| [Shape](#shape) | SlicerShape | Returns the Shape object associated with the specified slicer. Read-only. |
| [SlicerCache](#slicercache) | SlicerCache | Returns the SlicerCache object associated with the slicer. Read-only. |
| [Parent](#parent) | Worksheet | Returns the Worksheet object which contains this slicer. Read-only. |
| [Worksheet](#worksheet) | Worksheet |  |
| [StyleType](#styletype) | int | Specify the type of Built-in slicer style the default type is SlicerStyleLight1 The value of the property is SlicerStyle |
| [Name](#name) | String | Returns or sets the name of the specified slicer |
| [Caption](#caption) | String | Returns or sets the caption of the specified slicer. |
| [FirstItemIndex](#firstitemindex) | int |  |
| [CaptionVisible](#captionvisible) | boolean | Returns or sets whether the header that displays the slicer Caption is visible the default value is true |
| [ShowCaption](#showcaption) | boolean |  |
| [NumberOfColumns](#numberofcolumns) | int | Returns or sets the number of columns in the specified slicer. |
| [LeftPixel](#leftpixel) | int | Returns or sets the horizontal offset of slicer shape from its left column, in pixels. |
| [TopPixel](#toppixel) | int | Returns or sets the vertical offset of slicer shape from its top row, in pixels. |
| [Width](#width) | float | Returns or sets the width of the specified slicer, in points. |
| [WidthPixel](#widthpixel) | int | Returns or sets the width of the specified slicer, in pixels. |
| [Height](#height) | float | Returns or sets the height of the specified slicer, in points. |
| [HeightPixel](#heightpixel) | int | Returns or sets the height of the specified slicer, in pixels. |
| [ColumnWidthPixel](#columnwidthpixel) | int | Gets or sets the width in unit of pixels for each column of the slicer. |
| [ColumnWidth](#columnwidth) | float | Returns or sets the width, in points, of each column in the slicer. |
| [RowHeightPixel](#rowheightpixel) | int | Returns or sets the height, in pixels, of each row in the specified slicer. |
| [RowHeight](#rowheight) | float | Returns or sets the height, in points, of each row in the specified slicer. |

## Methods

| Name | Description |
| --- | --- |
| [addPivotConnection](#addpivotconnection) | Adds PivotTable connection. |
| [removePivotConnection](#removepivotconnection) | Removes PivotTable connection. |
| [refresh](#refresh) | Refreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables. |
| [selectItems](#selectitems) |  |
| [unselectItems](#unselectitems) |  |
| [clearFilter](#clearfilter) |  |

### Slicer.SortOrderType property {#sortordertype}

The value of the property is SortOrder integer constant.

**Type:** int

### Slicer.ShowMissing property {#showmissing}

**Type:** boolean

### Slicer.ShowTypeOfItemsWithNoData property {#showtypeofitemswithnodata}

The value of the property is ItemsWithNoDataShowMode integer constant.

**Type:** int

### Slicer.ShowAllItems property {#showallitems}

**Type:** boolean

### Slicer.Title property {#title}

Specifies the title of the current Slicer object.

**Type:** String

### Slicer.AlternativeText property {#alternativetext}

Returns or sets the descriptive (alternative) text string of the Slicer object.

**Type:** String

### Slicer.IsPrintable property {#isprintable}

Indicates whether the slicer object is printable.

**Type:** boolean

### Slicer.IsLocked property {#islocked}

Indicates whether the slicer shape is locked.

**Type:** boolean

### Slicer.Placement property {#placement}

Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet. The value of the property is PlacementType integer constant.

**Type:** int

### Slicer.LockedAspectRatio property {#lockedaspectratio}

Indicates whether locking aspect ratio.

**Type:** boolean

### Slicer.LockedPosition property {#lockedposition}

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

**Type:** boolean

### Slicer.Shape property {#shape}

Returns the Shape object associated with the specified slicer. Read-only.

**Type:** SlicerShape

### Slicer.SlicerCache property {#slicercache}

Returns the SlicerCache object associated with the slicer. Read-only.

**Type:** SlicerCache

### Slicer.Parent property {#parent}

Returns the Worksheet object which contains this slicer. Read-only.

**Type:** Worksheet

### Slicer.Worksheet property {#worksheet}

**Type:** Worksheet

### Slicer.StyleType property {#styletype}

Specify the type of Built-in slicer style the default type is SlicerStyleLight1 The value of the property is SlicerStyleType integer constant.

**Type:** int

### Slicer.Name property {#name}

Returns or sets the name of the specified slicer

**Type:** String

### Slicer.Caption property {#caption}

Returns or sets the caption of the specified slicer.

**Type:** String

### Slicer.FirstItemIndex property {#firstitemindex}

**Type:** int

### Slicer.CaptionVisible property {#captionvisible}

Returns or sets whether the header that displays the slicer Caption is visible the default value is true

**Type:** boolean

### Slicer.ShowCaption property {#showcaption}

**Type:** boolean

### Slicer.NumberOfColumns property {#numberofcolumns}

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

**Type:** int

### Slicer.LeftPixel property {#leftpixel}

Returns or sets the horizontal offset of slicer shape from its left column, in pixels.

**Type:** int

### Slicer.TopPixel property {#toppixel}

Returns or sets the vertical offset of slicer shape from its top row, in pixels.

**Type:** int

### Slicer.Width property {#width}

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

**Type:** float

### Slicer.WidthPixel property {#widthpixel}

Returns or sets the width of the specified slicer, in pixels.

**Type:** int

### Slicer.Height property {#height}

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

**Type:** float

### Slicer.HeightPixel property {#heightpixel}

Returns or sets the height of the specified slicer, in pixels.

**Type:** int

### Slicer.ColumnWidthPixel property {#columnwidthpixel}

Gets or sets the width in unit of pixels for each column of the slicer.

**Type:** int

### Slicer.ColumnWidth property {#columnwidth}

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

**Type:** float

### Slicer.RowHeightPixel property {#rowheightpixel}

Returns or sets the height, in pixels, of each row in the specified slicer.

**Type:** int

### Slicer.RowHeight property {#rowheight}

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

**Type:** float

### addPivotConnection(pivot) {#addpivotconnection}

Adds PivotTable connection.

| Parameter | Type | Description |
| --- | --- | --- |
| pivot | PivotTable | The PivotTable object |

### removePivotConnection(pivot) {#removepivotconnection}

Removes PivotTable connection.

| Parameter | Type | Description |
| --- | --- | --- |
| pivot | PivotTable | The PivotTable object |

### refresh() {#refresh}

Refreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables.

### selectItems(labels, append) {#selectitems}

### unselectItems(labels) {#unselectitems}

### clearFilter() {#clearfilter}