XlsSlicerCollection
Add Method (IPivotTable, String, 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,
string destCellName,
IPivotField baseField
)
Public Function Add (
pivot As IPivotTable,
destCellName As String,
baseField As IPivotField
) As Integer
public:
int Add(
IPivotTable^ pivot,
String^ destCellName,
IPivotField^ baseField
)
member Add :
pivot : IPivotTable *
destCellName : string *
baseField : IPivotField -> int
Parameters
-
pivot
-
Type:
Spire.Xls.Core
IPivotTable
The pivot table to which the slicer is connected.
-
destCellName
-
Type:
System
String
The name of the cell 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