Slicer Properties

The Slicer type exposes the following members.

Properties
  NameDescription
Public propertyAlternativeText
Returns or sets the descriptive (alternative) text string of the Slicer object.
Public propertyCaption
Returns or sets the caption of the specified slicer.
Public propertyCaptionVisible
Returns or sets whether the header that displays the slicer Caption is visible the default value is true
Public propertyColumnWidth
Returns or sets the width, in points, of each column in the slicer.
Public propertyColumnWidthPixel
Gets or sets the width in unit of pixels for each column of the slicer. 
Public propertyHeight
Returns or sets the height of the specified slicer, in points.
Public propertyHeightPixel
Returns or sets the height of the specified slicer, in pixels.
Public propertyIsLocked
Indicates whether the slicer shape is locked.
Public propertyIsPrintable
Indicates whether the slicer object is printable.
Public propertyLeftPixel
Returns or sets the horizontal offset of slicer shape from its left column, in pixels.
Public propertyLockedAspectRatio
Indicates whether locking aspect ratio.
Public propertyLockedPosition
Indicates whether the specified slicer can be moved or resized by using the user interface.
Public propertyName
Returns or sets the name of the specified slicer
Public propertyNumberOfColumns
Returns or sets the number of columns in the specified slicer.
Public propertyParent
Returns the Worksheet object that represents the sheet that contains the slicer. Read-only.
Public propertyPlacement
Represents the way the drawing object is attached to the cells below it. The property controls the placement of an object on a worksheet.
Public propertyRowHeight
Returns or sets the height, in points, of each row in the specified slicer.
Public propertyRowHeightPixel
Returns or sets the height, in pixels, of each row in the specified slicer.
Public propertySlicerCache
Returns the SlicerCache object associated with the slicer. Read-only.
Public propertyStyleType
Specify the type of Built-in slicer style the default type is SlicerStyleLight1
Public propertyTitle
Specifies the title of the current Slicer object.
Public propertyTopPixel
Returns or sets the vertical offset of slicer shape from its top row, in pixels.
Public propertyWidth
Returns or sets the width of the specified slicer, in points.
Public propertyWidthPixel
Returns or sets the width of the specified slicer, in pixels.
See Also