GrapeCity.Documents.Excel.ISlicer

Interface ISlicer

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Represents a slicer in a IWorkbook.

public interface ISlicer

Properties

Caption

Gets or sets the caption of the specified slicer.

string Caption { get; set; }

Property Value

string

DisplayHeader

Gets or sets whether the header that displays the slicer ISlicer.Caption is visible.

bool DisplayHeader { get; set; }

Property Value

bool

Height

Gets or sets the height of the specified slicer, in points.

double Height { get; set; }

Property Value

double

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.

double Left { get; set; }

Property Value

double

Name

Gets or sets the name of the specified slicer.

string Name { get; set; }

Property Value

string

NumberOfColumns

Gets or sets the number of columns in the specified slicer.

int NumberOfColumns { get; set; }

Property Value

int

RowHeight

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

double RowHeight { get; set; }

Property Value

double

Shape

Gets the IShape object associated with the specified slicer.

IShape Shape { get; }

Property Value

IShape

SlicerCache

Gets the ISlicerCache object associated with the slicer.

ISlicerCache SlicerCache { get; }

Property Value

ISlicerCache

Style

Gets or sets the style currently applied to the specified slicer.

ITableStyle Style { get; set; }

Property Value

ITableStyle

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.

double Top { get; set; }

Property Value

double

Width

Gets or sets the width of the specified slicer, in points.

double Width { get; set; }

Property Value

double

Methods

Delete()

Deletes the slicer and removes it from the associated ISlicers collection.

void Delete()

FromJson(string)

Updates the slicer settings from the json string.

void FromJson(string json)

Parameters

json string

The json string contains a slicer.

ToJson()

Generates a json string from slicer.

string ToJson()

Returns

string

The json string contains a slicer.