PivotTable Object (JavaScript API for Excel)
Represents an Excel PivotTable.
Properties
| Property | Type | Description | Req. Set |
|---|---|---|---|
| id | string | Id of the PivotTable. Read-only. | 1.5 |
| name | string | Name of the PivotTable. | 1.3 |
See property access examples.
Relationships
| Relationship | Type | Description | Req. Set |
|---|---|---|---|
| worksheet | Worksheet | The worksheet containing the current PivotTable. Read-only. | 1.3 |
Methods
| Method | Return Type | Description | Req. Set |
|---|---|---|---|
| refresh() | void | Refreshes the PivotTable. | 1.3 |
Method Details
refresh()
Refreshes the PivotTable.
Syntax
pivotTableObject.refresh();
Parameters
None
Returns
void
Parameters
| Parameter | Type | Description | |
|---|---|---|---|
| param | object | Optional. Accepts parameter and relationship names as delimited string or an array. Or, provide loadOption object. |
Returns
void
refresh()
Refreshes the PivotTable.
Syntax
pivotTableObject.refresh();
Parameters
None
Returns
void