# GrapeCity.Spreadsheet.Slicers.ISlicers.Add ## Content

Add Method

Add(IWorksheet, string, string, int, int, int, int)

Creates a new slicer.

Declaration
ISlicer Add(IWorksheet worksheet, string name = null, string caption = null, int x = -1, int y = -1, int width = -1, int height = -1)
Function Add(worksheet As IWorksheet, Optional name As String = Nothing, Optional caption As String = Nothing, Optional x As Integer = -1, Optional y As Integer = -1, Optional width As Integer = -1, Optional height As Integer = -1) As ISlicer
Parameters
Type Name Description
IWorksheet worksheet

A IWorksheet object where the resulting slicer will be placed. The destination sheet must be in the workbook that contains the Slicers object specified by expression.
string name

The name of the slicer. Spread automatically generates a name if the parameter is missing. The name must be unique across all slicers within a workbook.
string caption

The caption of the slicer.
int x

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

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

The initial width, in pixels, of the slicer control.
int height

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

The created ISlicer object.