Slicer Class
Contents
[
Hide
]Slicer class
summary description of Slicer View
type Slicer struct {
ptr unsafe.Pointer
}
Constructors
| Method | Description |
|---|
Methods
| Method | Description |
|---|---|
| IsNull | Checks whether the implementation object is nullptr. |
| AddPivotConnection | Adds PivotTable connection. |
| RemovePivotConnection | Removes PivotTable connection. |
| GetTitle | Specifies the title of the current Slicer object. |
| SetTitle | Specifies the title of the current Slicer object. |
| GetAlternativeText | Returns or sets the descriptive (alternative) text string of the Slicer object. |
| SetAlternativeText | Returns or sets the descriptive (alternative) text string of the Slicer object. |
| IsPrintable | Indicates whether the slicer object is printable. |
| SetIsPrintable | Indicates whether the slicer object is printable. |
| IsLocked | Indicates whether the slicer shape is locked. |
| SetIsLocked | Indicates whether the slicer shape is locked. |
| GetPlacement | Represents the way the drawing object is attached to the cells below it.The property controls the placement of an object on a worksheet. |
| SetPlacement | Represents the way the drawing object is attached to the cells below it.The property controls the placement of an object on a worksheet. |
| GetLockedAspectRatio | Indicates whether locking aspect ratio. |
| SetLockedAspectRatio | Indicates whether locking aspect ratio. |
| GetLockedPosition | Indicates whether the specified slicer can be moved or resized by using the user interface. |
| SetLockedPosition | Indicates whether the specified slicer can be moved or resized by using the user interface. |
| Refresh | Refreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables. |
| GetShape | Returns the Shape object associated with the specified slicer. Read-only. |
| GetSlicerCache | Returns the SlicerCache object associated with the slicer. Read-only. |
| GetParent | Returns the Worksheet object which contains this slicer. Read-only. |
| GetStyleType | Specify the type of Built-in slicer stylethe default type is SlicerStyleLight1 |
| SetStyleType | Specify the type of Built-in slicer stylethe default type is SlicerStyleLight1 |
| GetName | Returns or sets the name of the specified slicer |
| SetName | Returns or sets the name of the specified slicer |
| GetCaption | Returns or sets the caption of the specified slicer. |
| SetCaption | Returns or sets the caption of the specified slicer. |
| GetCaptionVisible | Returns or sets whether the header that displays the slicer Caption is visiblethe default value is true |
| SetCaptionVisible | Returns or sets whether the header that displays the slicer Caption is visiblethe default value is true |
| GetNumberOfColumns | Returns or sets the number of columns in the specified slicer. |
| SetNumberOfColumns | Returns or sets the number of columns in the specified slicer. |
| GetColumnWidthPixel | Gets or sets the width of each column in the slicer, in unit of pixels. |
| SetColumnWidthPixel | Gets or sets the width of each column in the slicer, in unit of pixels. |
| GetColumnWidth | Returns or sets the width, in points, of each column in the slicer. |
| SetColumnWidth | Returns or sets the width, in points, of each column in the slicer. |
| GetRowHeightPixel | Returns or sets the height, in pixels, of each row in the specified slicer. |
| SetRowHeightPixel | Returns or sets the height, in pixels, of each row in the specified slicer. |
| GetRowHeight | Returns or sets the height, in points, of each row in the specified slicer. |
| SetRowHeight | Returns or sets the height, in points, of each row in the specified slicer. |