SlicerCollection
SlicerCollection class
Specifies the collection of all the Slicer objects on the specified worksheet.
Methods
| Name | Description |
|---|---|
| add(pivot, destCellName, baseFieldName) | Add a new Slicer using PivotTable as data source |
| add(pivot, row, column, baseFieldName) | Add a new Slicer using PivotTable as data source |
| add(pivot, row, column, baseFieldIndex) | Add a new Slicer using PivotTable as data source |
| add(pivot, destCellName, baseFieldIndex) | Add a new Slicer using PivotTable as data source |
| add(pivot, row, column, baseField) | Add a new Slicer using PivotTable as data source |
| add(pivot, destCellName, baseField) | Add a new Slicer using PivotTable as data source |
| add(table, index, destCellName) | Add a new Slicer using ListObjet as data source |
| add(table, listColumn, destCellName) | Add a new Slicer using ListObjet as data source |
| add(table, listColumn, row, column) | Add a new Slicer using ListObjet as data source |
| 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 |
| removeAt(index) | Deletes the Slicer at the specified index |
add(pivot, destCellName, baseFieldName)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | 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: Number — Number The new add Slicer index
add(pivot, row, column, baseFieldName)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | 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: Number — Number The new add Slicer index
add(pivot, row, column, baseFieldIndex)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | 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: Number — Number The new add Slicer index
add(pivot, destCellName, baseFieldIndex)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | 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: Number — Number The new add Slicer index
add(pivot, row, column, baseField)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | 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 | PivotField | The PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Slicer index
add(pivot, destCellName, baseField)
Add a new Slicer using PivotTable as data source
| Parameter | Type | Description |
|---|---|---|
| pivot | PivotTable | PivotTable object |
| destCellName | String | The cell in the upper-left corner of the Slicer range. |
| baseField | PivotField | The PivotField in PivotTable.BaseFields |
Returns: Number — Number The new add Slicer index
add(table, index, destCellName)
Add a new Slicer using ListObjet as data source
| Parameter | Type | Description |
|---|---|---|
| table | ListObject | 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: Number — Number The new add Slicer index
add(table, listColumn, destCellName)
Add a new Slicer using ListObjet as data source
| Parameter | Type | Description |
|---|---|---|
| table | ListObject | ListObject object |
| listColumn | ListColumn | The ListColumn in ListObject.ListColumns |
| destCellName | String | The cell in the upper-left corner of the Slicer range. |
Returns: Number — Number The new add Slicer index
add(table, listColumn, row, column)
Add a new Slicer using ListObjet as data source
| Parameter | Type | Description |
|---|---|---|
| table | ListObject | ListObject object |
| listColumn | 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: Number — Number The 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 | Type | Description |
|---|---|---|
| slicer | Slicer | The Slicer object |
removeAt(index)
Deletes the Slicer at the specified index
| Parameter | Type | Description |
|---|---|---|
| index | Number | The position index in Slicer collection |