Add Method (ISlicers)

Creates a new slicer and returns a ISlicer object.

Syntax

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

Parameters

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.
name: The name of the slicer.The name must be unique across all slicers within a workbook.
caption: The caption of the slicer.
top: The initial vertical position of the slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.
left: The initial horizontal position of the slicer, in points, relative to the upper-left corner of cell A1 on a worksheet.
width: The initial width, in points, of the slicer control.
height: The initial height, in points, of the slicer control.

Reference

ISlicers Interface
ISlicers Members