Method Details

• getCaption

  String getCaption()

  Gets the caption of the specified slicer.

• setCaption

  void setCaption(String value)

  Sets the caption of the specified slicer.

• getDisplayHeader

  boolean getDisplayHeader()

  Gets whether the header that displays the slicer's caption is visible.

• setDisplayHeader

  void setDisplayHeader(boolean value)

  Sets whether the header that displays the slicer's caption is visible.

• getHeight

  double getHeight()

  Gets the height of the specified slicer, in points.

• setHeight

  void setHeight(double value)

  Sets the height of the specified slicer, in points.

• getLeft

  double getLeft()

  Gets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

• setLeft

  void setLeft(double value)

  Sets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

• getName

  String getName()

  Gets the name of the specified slicer.

• setName

  void setName(String value)

  Sets the name of the specified slicer.

• getNumberOfColumns

  int getNumberOfColumns()

  Gets the number of columns in the specified slicer.

• setNumberOfColumns

  void setNumberOfColumns(int value)

  Sets the number of columns in the specified slicer.

• getRowHeight

  double getRowHeight()

  Gets the height, in points, of each row in the specified slicer.

• setRowHeight

  void setRowHeight(double value)

  Sets the height, in points, of each row in the specified slicer.

• getSlicerCache

  ISlicerCache getSlicerCache()

  Gets the ISlicerCache object associated with the slicer.

• getShape

  IShape getShape()

  Gets the IShape object associated with the specified slicer.

• getTop

  double getTop()

  Gets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

• setTop

  void setTop(double value)

  Sets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.

• getWidth

  double getWidth()

  Gets the width of the specified slicer, in points.

• setWidth

  void setWidth(double value)

  Sets the width of the specified slicer, in points.

• delete

  void delete()

  Deletes the slicer and removes it from the associated ISlicerscollection.

• getStyle

  ITableStyle getStyle()

  Gets the style currently applied to the specified slicer.

• setStyle

  void setStyle(ITableStyle value)

  Sets the style currently applied to the specified slicer.

• fromJson

  void fromJson(String json)

  Updates the slicer settings from the json string.

  Parameters:

  json - the json string contains a slicer

• toJson

  String toJson()

  Generates a json string from slicer.

  Returns:

  the json string contains a slicer