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. |