PivotTableFormatCollection
Contents
[
Hide
]PivotTableFormatCollection class
Represents the collection of formats applied to PivotTable.
Methods
| Name | Description |
|---|---|
| add() | Add a PivotTableFormat. |
| add() | Reserved for internal use. |
| clear() | |
| contains() | Reserved for internal use. |
| formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style) | Formats selected area. |
| get(index) | Gets the format by the index. |
| get() | Reserved for internal use. |
| getCount() | |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeAt() |
add()
Add a PivotTableFormat.
Returns: Number — Number The index of new format.
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
formatArea(axisType, fieldPosition, subtotalType, selectionType, isGrandRow, isGrandColumn, style)
Formats selected area.
| Parameter | Type | 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 | Style | The style which appies to the area of the pivot table. |
Returns: PivotTableFormat — PivotTableFormat
get(index)
Gets the format by the index.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The index. |
Returns: PivotTableFormat — PivotTableFormat
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.