aspose.cells

Property Getters/Setters Detail

• getCount : Number 

  function getCount()
  

• get : PivotTableFormat 

  function get(index)
  

  Gets the format by the index.

  Parameters:

  index - The index.

  Returns:

Method Detail

• add

  function add()

  Add a PivotTableFormat.

  Returns:

  The index of new format.

• formatArea

  function formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style)

  Formats selected area.

  Parameters:

  axisType: Number - A PivotFieldType value. The region of the PivotTable to which this rule applies.

  fieldPosition: Number - Position of the field within the axis to which this rule applies.

  subtotalType: Number - A PivotFieldSubtotalType value. The subtotal filter type of the pivot field

  selectionType: Number - 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

  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.