asposecells.api

Class SlicerCollection

Specifies the collection of all the Slicer objects on the specified worksheet.

Property Getters/Setters Summary
methodgetCount()
methodget(index)
Gets the Slicer by index.
methodget(name)
Gets the Slicer by slicer's name.
 
Method Summary
methodadd(table, listColumn, row, column)
Add a new Slicer using ListObjet as data source
methodadd(table, listColumn, destCellName)
Add a new Slicer using ListObjet as data source
methodadd(table, index, destCellName)
Add a new Slicer using ListObjet as data source
methodadd(pivot, row, column, baseField)
Add a new Slicer using PivotTable as data source
methodadd(pivot, row, column, baseFieldIndex)
Add a new Slicer using PivotTable as data source
methodadd(pivot, row, column, baseFieldName)
Add a new Slicer using PivotTable as data source
methodadd(pivot, destCellName, baseField)
Add a new Slicer using PivotTable as data source
methodadd(pivot, destCellName, baseFieldIndex)
Add a new Slicer using PivotTable as data source
methodadd(pivot, destCellName, baseFieldName)
Add a new Slicer using PivotTable as data source
methodadd(value)
Reserved for internal use.
methodclear()
methodcontains(value)
Reserved for internal use.
methodget(index)
Reserved for internal use.
methodindexOf(value)
Reserved for internal use.
methoditerator()
methodremove(slicer)
Remove the specified Slicer
methodremoveAt(index)
Deletes the Slicer at the specified index
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()
        
      • get : Slicer 

        Slicer get(index)
        
        Gets the Slicer by index.
      • get : Slicer 

        Slicer get(name)
        
        Gets the Slicer by slicer's name.
    • Method Detail

      • remove

         remove(slicer)
        Remove the specified Slicer
        Parameters:
        slicer: Slicer - The Slicer object
      • removeAt

         removeAt(index)
        Deletes the Slicer at the specified index
        Parameters:
        index: int - The position index in Slicer collection
      • add

        int add(pivot, destCellName, baseFieldName)
        Add a new Slicer using PivotTable as data source
        Parameters:
        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

        int add(pivot, row, column, baseFieldName)
        Add a new Slicer using PivotTable as data source
        Parameters:
        pivot: PivotTable - PivotTable object
        row: int - Row index of the cell in the upper-left corner of the Slicer range.
        column: int - 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

        int add(pivot, row, column, baseFieldIndex)
        Add a new Slicer using PivotTable as data source
        Parameters:
        pivot: PivotTable - PivotTable object
        row: int - Row index of the cell in the upper-left corner of the Slicer range.
        column: int - Column index of the cell in the upper-left corner of the Slicer range.
        baseFieldIndex: int - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        int add(pivot, destCellName, baseFieldIndex)
        Add a new Slicer using PivotTable as data source
        Parameters:
        pivot: PivotTable - PivotTable object
        destCellName: String - The cell in the upper-left corner of the Slicer range.
        baseFieldIndex: int - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index
      • add

        int add(pivot, row, column, baseField)
        Add a new Slicer using PivotTable as data source
        Parameters:
        pivot: PivotTable - PivotTable object
        row: int - Row index of the cell in the upper-left corner of the Slicer range.
        column: int - 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

        int add(pivot, destCellName, baseField)
        Add a new Slicer using PivotTable as data source
        Parameters:
        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

        int add(table, index, destCellName)
        Add a new Slicer using ListObjet as data source
        Parameters:
        table: ListObject - ListObject object
        index: int - 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

        int add(table, listColumn, destCellName)
        Add a new Slicer using ListObjet as data source
        Parameters:
        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

        int add(table, listColumn, row, column)
        Add a new Slicer using ListObjet as data source
        Parameters:
        table: ListObject - ListObject object
        listColumn: ListColumn - The ListColumn in ListObject.ListColumns
        row: int - Row index of the cell in the upper-left corner of the Slicer range.
        column: int - Column index of the cell in the upper-left corner of the Slicer range.
        Returns:
        The new add Slicer index
      • clear

         clear()
      • iterator

        Iterator iterator()
      • get

        Object get(index)
        Reserved for internal use.
      • contains

        boolean contains(value)
        Reserved for internal use.
      • add

        int add(value)
        Reserved for internal use.
      • indexOf

        int indexOf(value)
        Reserved for internal use.