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

ct.load(param);

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