GrapeCity.Documents.Excel.ISlicers

Interface ISlicers

A collection of ISlicer objects.

public interface ISlicers : IEnumerable

Gets the number of objects in the collection.

int Count { get; }

Gets the ISlicer with the specified index.

ISlicer this[int index] { get; }

Gets the ISlicer with the specified name.

ISlicer this[string name] { get; }

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)

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.