Edit

Excel.Interfaces.PivotTableLoadOptions interface

  • Reference
Package:
excel

Represents an Excel PivotTable. To learn more about the PivotTable object model, read Work with PivotTables using the Excel JavaScript API.

Remarks

[ API set: ExcelApi 1.3 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).
id

ID of the PivotTable.
name

Name of the PivotTable.
worksheet

The worksheet containing the current PivotTable.

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

id

ID of the PivotTable.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.5 ]

name

Name of the PivotTable.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

worksheet

The worksheet containing the current PivotTable.

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

Property Value

Excel.Interfaces.WorksheetLoadOptions

Remarks

[ API set: ExcelApi 1.3 ]