class
PivotTableFormatCollection
Source: aspose.
Represents the collection of formats applied to PivotTable.
Methods
add() → Number
Add a PivotTableFormat.
- Returns
-
NumberThe index of new format.
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style) → PivotTableFormat
Formats selected area.
Parameters
| Name | Type | Optional | Description |
|---|---|---|---|
|
axisType |
Number |
|
PivotFieldType |
|
fieldPosition |
Number |
|
Position of the field within the axis to which this rule applies. |
|
subtotalType |
Number |
|
PivotFieldSubtotalType |
|
selectionType |
Number |
|
PivotTableSelectionType |
|
isGrandRow |
boolean |
|
Indicates whether selecting grand total rows. |
|
isGrandColumn |
boolean |
|
Indicates whether selecting grand total columns. |
|
style |
|
The style which appies to the area of the pivot table. |
- Returns
get(index) → PivotTableFormat
Gets the format by the index.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
index |
Number |
|
The index. |
- Returns
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.