[]
Represents a slicer in a IWorkbook.
public interface ISlicer
Public Interface ISlicer
Name | Description |
---|---|
Caption | Gets or sets the caption of the specified slicer. |
DisplayHeader | Gets or sets whether the header that displays the slicer ISlicer.Caption is visible. |
Height | Gets or sets the height of the specified slicer, in points. |
Left | Gets or sets the horizontal position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. |
Name | Gets or sets the name of the specified slicer. |
NumberOfColumns | Gets or sets the number of columns in the specified slicer. |
RowHeight | Gets or sets the height, in points, of each row in the specified slicer. |
Shape | Gets the IShape object associated with the specified slicer. |
SlicerCache | Gets the ISlicerCache object associated with the slicer. |
Style | Gets or sets the style currently applied to the specified slicer. |
Top | Gets or sets the vertical position of the specified slicer, in points, relative to the upper-left corner of cell A1 on a worksheet. |
Width | Gets or sets the width of the specified slicer, in points. |
Name | Description |
---|---|
Delete() | Deletes the slicer and removes it from the associated ISlicers collection. |
FromJson(string) | Updates the slicer settings from the json string. |
ToJson() | Generates a json string from slicer. |