GrapeCity.Documents.Excel.ISlicers

Interface ISlicers

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

A collection of ISlicer objects.

public interface ISlicers : IEnumerable

Inherited Members

System.Collections.IEnumerable.GetEnumerator()

Properties

Count

Gets the number of objects in the collection.

int Count { get; }

Property Value

int

this[int]

Gets the ISlicer with the specified index.

ISlicer this[int index] { get; }

Parameters

index int

the index.

Property Value

ISlicer

this[string]

Gets the ISlicer with the specified name.

ISlicer this[string name] { get; }

Parameters

name string

the name.

Property Value

ISlicer

Methods

Add(IWorksheet, string, string, double, double, double, double)

Creates a new slicer and returns a ISlicer object.

ISlicer Add(IWorksheet slicerDestination, string name, string caption, double top, double left, double width, double height)

Parameters

slicerDestination IWorksheet

a IWorksheet object that represents the sheet, where the resulting slicer will be placed.The destination sheet must be in the workbook that contains the ISlicers object specified by expression.

name string

The name of the slicer.The name must be unique across all slicers within a workbook.

caption string

The caption of the slicer.

top double

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

left double

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

width double

The initial width, in points, of the slicer control.

height double

The initial height, in points, of the slicer control.

Returns

ISlicer