PivotAreaCollection
Contents
[
Hide
]PivotAreaCollection class
Represents a list of pivot area.
class PivotAreaCollection;
Methods
| Method | Description |
|---|---|
| get(number) | Gets a PivotArea object; |
| add(PivotArea) | Adds pivot area. |
| add(CellArea) | Adds an area based on pivot table view. |
| removeAt(number) | Remove one pivot conditional formatted area setting. |
| getCount() | @deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in. |
| isNull() | Checks whether the implementation object is null. |
get(number)
Gets a PivotArea object;
get(index: number) : PivotArea;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number |
Returns
add(PivotArea)
Adds pivot area.
add(pivotArea: PivotArea) : number;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| pivotArea | PivotArea | The pivot area. |
add(CellArea)
Adds an area based on pivot table view.
add(cellArea: CellArea) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| cellArea | CellArea | The area based on pivot table view. |
removeAt(number)
Remove one pivot conditional formatted area setting.
removeAt(index: number) : void;
Parameters:
| Parameter | Type | Description |
|---|---|---|
| index | number | The index |
getCount()
@deprecated. Please use the ‘count’ property instead. Gets the number of elements contained in.
getCount() : number;
isNull()
Checks whether the implementation object is null.
isNull() : boolean;