PivotTable Object (JavaScript API for Excel)

Represents an Excel PivotTable.

Properties

Property Type Description Req. Set
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

loadparam-object">load(param: object)

Fills the proxy object created in JavaScript layer with property and object values specified in the parameter.

Syntax

object.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