SlicerCollection
Source: aspose.
Specifies the collection of all the Slicer objects on the specified worksheet.
Methods
Methods
add(pivot, destCellName, baseFieldName) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
destCellName |
String |
|
The cell in the upper-left corner of the Slicer range. |
|
baseFieldName |
String |
|
The name of PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(pivot, row, column, baseFieldName) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
row |
Number |
|
Row index of the cell in the upper-left corner of the Slicer range. |
|
column |
Number |
|
Column index of the cell in the upper-left corner of the Slicer range. |
|
baseFieldName |
String |
|
The name of PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(pivot, row, column, baseFieldIndex) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
row |
Number |
|
Row index of the cell in the upper-left corner of the Slicer range. |
|
column |
Number |
|
Column index of the cell in the upper-left corner of the Slicer range. |
|
baseFieldIndex |
Number |
|
The index of PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(pivot, destCellName, baseFieldIndex) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
destCellName |
String |
|
The cell in the upper-left corner of the Slicer range. |
|
baseFieldIndex |
Number |
|
The index of PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(pivot, row, column, baseField) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
row |
Number |
|
Row index of the cell in the upper-left corner of the Slicer range. |
|
column |
Number |
|
Column index of the cell in the upper-left corner of the Slicer range. |
|
baseField |
|
The PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(pivot, destCellName, baseField) → Number
Add a new Slicer using PivotTable as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
pivot |
|
PivotTable object |
|
|
destCellName |
String |
|
The cell in the upper-left corner of the Slicer range. |
|
baseField |
|
The PivotField in PivotTable.BaseFields |
- Returns
-
NumberThe new add Slicer index
add(table, index, destCellName) → Number
Add a new Slicer using ListObjet as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
table |
|
ListObject object |
|
|
index |
Number |
|
The index of ListColumn in ListObject.ListColumns |
|
destCellName |
String |
|
The cell in the upper-left corner of the Slicer range. |
- Returns
-
NumberThe new add Slicer index
add(table, listColumn, destCellName) → Number
Add a new Slicer using ListObjet as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
table |
|
ListObject object |
|
|
listColumn |
|
The ListColumn in ListObject.ListColumns |
|
|
destCellName |
String |
|
The cell in the upper-left corner of the Slicer range. |
- Returns
-
NumberThe new add Slicer index
add(table, listColumn, row, column) → Number
Add a new Slicer using ListObjet as data source
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
table |
|
ListObject object |
|
|
listColumn |
|
The ListColumn in ListObject.ListColumns |
|
|
row |
Number |
|
Row index of the cell in the upper-left corner of the Slicer range. |
|
column |
Number |
|
Column index of the cell in the upper-left corner of the Slicer range. |
- Returns
-
NumberThe new add Slicer index
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get()
Gets the Slicer by index.
get()
Gets the Slicer by slicer's name.
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.
iterator()
remove(slicer)
Remove the specified Slicer
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
slicer |
|
The Slicer object |
removeAt(index)
Deletes the Slicer at the specified index
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
index |
Number |
|
The position index in Slicer collection |