aspose.cells

aspose.cells

Class SlicerCollection

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

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the Slicer by index.
functionget(name)
Gets the Slicer by slicer's name.
 
Method Summary
functionadd(table, listColumn, row, column)
Add a new Slicer using ListObjet as data source
functionadd(table, listColumn, destCellName)
Add a new Slicer using ListObjet as data source
functionadd(table, index, destCellName)
Add a new Slicer using ListObjet as data source
functionadd(pivot, row, column, baseField)
Add a new Slicer using PivotTable as data source
functionadd(pivot, row, column, baseFieldIndex)
Add a new Slicer using PivotTable as data source
functionadd(pivot, row, column, baseFieldName)
Add a new Slicer using PivotTable as data source
functionadd(pivot, destCellName, baseField)
Add a new Slicer using PivotTable as data source
functionadd(pivot, destCellName, baseFieldIndex)
Add a new Slicer using PivotTable as data source
functionadd(pivot, destCellName, baseFieldName)
Add a new Slicer using PivotTable as data source
functionadd(value)
Reserved for internal use.
functionclear()
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremove(slicer)
Remove the specified Slicer
functionremoveAt(index)
Deletes the Slicer at the specified index
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()

      • get : Slicer 

        function get(index)
        Gets the Slicer by index.

      • get : Slicer 

        function get(name)
        Gets the Slicer by slicer's name.

    • Method Detail

      • remove

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

      • removeAt

        function removeAt(index)
        Deletes the Slicer at the specified index
        Parameters:
        index: Number - The position index in Slicer collection

      • add

        function 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

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

        function add(pivot, row, column, baseFieldIndex)
        Add a new Slicer using PivotTable as data source
        Parameters:
        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

        function 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: Number - The index of PivotField in PivotTable.BaseFields
        Returns:
        The new add Slicer index

      • add

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

        function 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

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

        function 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

        function 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: 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

      • clear

        function clear()

      • iterator

        function iterator()

      • get

        function get(index)
        Reserved for internal use.

      • contains

        function contains(value)
        Reserved for internal use.

      • add

        function add(value)
        Reserved for internal use.

      • indexOf

        function indexOf(value)
        Reserved for internal use.