asposecells.api

Class PivotTableFormatCollection

Represents the collection of formats applied to PivotTable.

Property Getters/Setters Summary
methodgetCount()
methodget(index)
Gets the format by the index.
 
Method Summary
methodadd()
methodadd(value)
Reserved for internal use.
methodclear()
methodcontains(value)
Reserved for internal use.
methodformatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style)
Formats selected area.
methodget(index)
Reserved for internal use.
methodindexOf(value)
Reserved for internal use.
methoditerator()
methodremoveAt(index)
 

    • Property Getters/Setters Detail

      • getCount : int 

        int getCount()
        
    • Method Detail

      • formatArea

        PivotTableFormat formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style)
        Formats selected area.
        Parameters:
        axisType: int - A PivotFieldType value. The region of the PivotTable to which this rule applies.
        fieldPosition: int - Position of the field within the axis to which this rule applies.
        subtotalType: int - A PivotFieldSubtotalType value. The subtotal filter type of the pivot field
        selectionType: int - A PivotTableSelectionType value. Indicates how to select data.
        isGrandRow: boolean - Indicates whether selecting grand total rows.
        isGrandColumn: boolean - Indicates whether selecting grand total columns.
        style: Style - The style which appies to the area of the pivot table.
        Returns:
      • clear

         clear()
      • removeAt

         removeAt(index)
      • 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.