aspose.cells

aspose.cells

Class PivotFilterCollection

Represents a collection of all the PivotFilter objects

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the pivotfilter object at the specific index.
 
Method Summary
functionadd(fieldIndex, type)
Adds a PivotFilter Object to the specific type
functionadd(value)
Reserved for internal use.
functionaddDateFilter(baseFieldIndex, type, dateTime1, dateTime2)
functionaddLabelFilter(baseFieldIndex, type, label1, label2)
functionaddTop10Filter(baseFieldIndex, valueFieldIndex, type, isTop, itemCount)
functionaddValueFilter(baseFieldIndex, valueFieldIndex, type, value1, value2)
functionclear()
functionclearFilter(fieldIndex)
Clear PivotFilter from the specific PivotField
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()

      • get : PivotFilter 

        function get(index)
        Gets the pivotfilter object at the specific index.

    • Method Detail

      • add

        function add(fieldIndex, type)
        Adds a PivotFilter Object to the specific type
        Parameters:
        fieldIndex: Number - the PivotField index
        type: Number - A PivotFilterType value. the PivotFilter type
        Returns:
        the index of the PivotFilter Object in this PivotFilterCollection.

      • addTop10Filter

        function addTop10Filter(baseFieldIndex, valueFieldIndex, type, isTop, itemCount)
        Parameters:
        type - A PivotFilterType value.

      • addValueFilter

        function addValueFilter(baseFieldIndex, valueFieldIndex, type, value1, value2)
        Parameters:
        type - A PivotFilterType value.

      • addLabelFilter

        function addLabelFilter(baseFieldIndex, type, label1, label2)
        Parameters:
        type - A PivotFilterType value.

      • addDateFilter

        function addDateFilter(baseFieldIndex, type, dateTime1, dateTime2)
        Parameters:
        type - A PivotFilterType value.

      • clearFilter

        function clearFilter(fieldIndex)
        Clear PivotFilter from the specific PivotField
        Parameters:
        fieldIndex: Number - the PivotField index

      • clear

        function clear()

      • removeAt

        function removeAt(index)

      • 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.