asposecells.api

Property Getters/Setters Detail

• getCount : int 

  int getCount()
  

• get : PivotTableFormat 

  PivotTableFormat get(index)
  

  Gets the format by the index.

  Parameters:

  index - The index.

  Returns:

Method Detail

• add

  int add()

  Add a PivotTableFormat.

  Returns:

  The index of new format.

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