Slicer Class

Slicer class

summary description of Slicer View


type Slicer struct  {
	ptr unsafe.Pointer
}

Constructors

MethodDescription

Methods

MethodDescription
IsNullChecks whether the implementation object is nullptr.
AddPivotConnectionAdds PivotTable connection.
RemovePivotConnectionRemoves PivotTable connection.
GetTitleSpecifies the title of the current Slicer object.
SetTitleSpecifies the title of the current Slicer object.
GetAlternativeTextReturns or sets the descriptive (alternative) text string of the Slicer object.
SetAlternativeTextReturns or sets the descriptive (alternative) text string of the Slicer object.
IsPrintableIndicates whether the slicer object is printable.
SetIsPrintableIndicates whether the slicer object is printable.
IsLockedIndicates whether the slicer shape is locked.
SetIsLockedIndicates whether the slicer shape is locked.
GetPlacementRepresents the way the drawing object is attached to the cells below it.The property controls the placement of an object on a worksheet.
SetPlacementRepresents the way the drawing object is attached to the cells below it.The property controls the placement of an object on a worksheet.
GetLockedAspectRatioIndicates whether locking aspect ratio.
SetLockedAspectRatioIndicates whether locking aspect ratio.
GetLockedPositionIndicates whether the specified slicer can be moved or resized by using the user interface.
SetLockedPositionIndicates whether the specified slicer can be moved or resized by using the user interface.
RefreshRefreshing the slicer.Meanwhile, Refreshing and Calculating relative PivotTables.
GetShapeReturns the Shape object associated with the specified slicer. Read-only.
GetSlicerCacheReturns the SlicerCache object associated with the slicer. Read-only.
GetParentReturns the Worksheet object which contains this slicer. Read-only.
GetStyleTypeSpecify the type of Built-in slicer stylethe default type is SlicerStyleLight1
SetStyleTypeSpecify the type of Built-in slicer stylethe default type is SlicerStyleLight1
GetNameReturns or sets the name of the specified slicer
SetNameReturns or sets the name of the specified slicer
GetCaptionReturns or sets the caption of the specified slicer.
SetCaptionReturns or sets the caption of the specified slicer.
GetCaptionVisibleReturns or sets whether the header that displays the slicer Caption is visiblethe default value is true
SetCaptionVisibleReturns or sets whether the header that displays the slicer Caption is visiblethe default value is true
GetNumberOfColumnsReturns or sets the number of columns in the specified slicer.
SetNumberOfColumnsReturns or sets the number of columns in the specified slicer.
GetColumnWidthPixelGets or sets the width of each column in the slicer, in unit of pixels.
SetColumnWidthPixelGets or sets the width of each column in the slicer, in unit of pixels.
GetColumnWidthReturns or sets the width, in points, of each column in the slicer.
SetColumnWidthReturns or sets the width, in points, of each column in the slicer.
GetRowHeightPixelReturns or sets the height, in pixels, of each row in the specified slicer.
SetRowHeightPixelReturns or sets the height, in pixels, of each row in the specified slicer.
GetRowHeightReturns or sets the height, in points, of each row in the specified slicer.
SetRowHeightReturns or sets the height, in points, of each row in the specified slicer.