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