Click or drag to resize

XlsSlicerCollection Add Method (IPivotTable, Int32, Int32, IPivotField)

Adds a slicer to the collection.

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public int Add(
	IPivotTable pivot,
	int row,
	int column,
	IPivotField baseField
)

Parameters

pivot
Type: Spire.Xls.Core IPivotTable
The pivot table to which the slicer is connected.
row
Type: System Int32
The row index where the slicer will be placed.
column
Type: System Int32
The column index where the slicer will be placed.
baseField
Type: Spire.Xls.Core IPivotField
The base field in the pivot table to be used by the slicer.

Return Value

Type: Int32
The index of the newly added slicer in the collection.
See Also