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