asposecells.api

Class PivotFieldCollection

Represents a collection of all the PivotField objects in the PivotTable's specific PivotFields type.

Property Getters/Setters Summary
methodgetCount()
Gets the count of the pivotFields.
methodgetType()
Gets the PivotFields type. The value of the property is PivotFieldType integer constant.
methodget(index)
Gets the PivotField Object at the specific index.
methodget(name)
Gets the PivotField Object of the specific name.
 
Method Summary
methodadd(pivotField)
Adds a PivotField Object to the specific type PivotFields.
methodaddByBaseIndex(baseFieldIndex)
Adds a PivotField Object to the specific type PivotFields.
methodclear()
clear all fields of PivotFieldCollection
 

    • Property Getters/Setters Detail

      • getType : int 

        int getType()
        
        Gets the PivotFields type. The value of the property is PivotFieldType integer constant.
      • getCount : int 

        int getCount()
        
        Gets the count of the pivotFields.
    • Method Detail

      • addByBaseIndex

        int addByBaseIndex(baseFieldIndex)
        Adds a PivotField Object to the specific type PivotFields.
        Parameters:
        baseFieldIndex: int - field index in the base PivotFields.
        Returns:
        the index of the PivotField Object in this PivotFields.
      • add

        int add(pivotField)
        Adds a PivotField Object to the specific type PivotFields.
        Parameters:
        pivotField: PivotField - a PivotField Object.
        Returns:
        the index of the PivotField Object in this PivotFields.
      • clear

         clear()
        clear all fields of PivotFieldCollection