[]
DEMOS DOCS API PRICING
FREE TRIAL
(Showing Draft Content)

GrapeCity.Documents.Excel.ISlicers.Add

Add Method

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

Creates a new slicer and returns a ISlicer object.

Declaration
ISlicer Add(IWorksheet slicerDestination, string name, string caption, double top, double left, double width, double height)
Function Add(slicerDestination As IWorksheet, name As String, caption As String, top As Double, left As Double, width As Double, height As Double) As ISlicer
Parameters
Type Name Description
IWorksheet slicerDestination

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.
string name

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

The caption of the slicer.
double top

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

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

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

The initial height, in points, of the slicer control.
Returns
Type Description
ISlicer