GrapeCity.Spreadsheet.Slicers.ISlicers.Add

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.