SlicerCollection
SlicerCollection class
Specifies the collection of all the Slicer objects on the specified worksheet.
Properties
| Name | Type | Description |
|---|---|---|
| Count | Number | |
| Item (int) | Slicer | Gets the Slicer by index. |
| Item (java.lang.String) | Slicer | Gets the Slicer by slicer’s name. |
Methods
| Name | Description |
|---|---|
| remove | Remove the specified Slicer |
| removeAt | Deletes the Slicer at the specified index |
| clear | |
| add | Add a new Slicer using PivotTable as data source |
| iterator | |
| get | Reserved for internal use. |
| contains | Reserved for internal use. |
| indexOf | Reserved for internal use. |
SlicerCollection.Count property
Type: Number
SlicerCollection.Item (int) property
Gets the Slicer by index.
Type: Slicer
SlicerCollection.Item (java.lang.String) property
Gets the Slicer by slicer’s name.
Type: Slicer
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 |
clear()
add(pivot, destCellName, baseFieldName) (1 of 10)
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: The new add Slicer index
add(pivot, row, column, baseFieldName) (2 of 10)
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: The new add Slicer index
add(pivot, row, column, baseFieldIndex) (3 of 10)
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: The new add Slicer index
add(pivot, destCellName, baseFieldIndex) (4 of 10)
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: The new add Slicer index
add(pivot, row, column, baseField) (5 of 10)
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: The new add Slicer index
add(pivot, destCellName, baseField) (6 of 10)
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: The new add Slicer index
add(table, index, destCellName) (7 of 10)
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: The new add Slicer index
add(table, listColumn, destCellName) (8 of 10)
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: The new add Slicer index
add(table, listColumn, row, column) (9 of 10)
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: The new add Slicer index
add(value) (10 of 10)
Reserved for internal use.
iterator()
get(index)
Reserved for internal use.
contains(value)
Reserved for internal use.
indexOf(value)
Reserved for internal use.