Excel.Interfaces.PivotTableCollectionLoadOptions interface

Represents a collection of all the PivotTables that are part of the workbook or worksheet.

Remarks

[ API set: ExcelApi 1.3 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

id

For EACH ITEM in the collection: ID of the PivotTable.

name

For EACH ITEM in the collection: Name of the PivotTable.

worksheet

For EACH ITEM in the collection: The worksheet containing the current PivotTable.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

id

For EACH ITEM in the collection: ID of the PivotTable.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.5 ]

name

For EACH ITEM in the collection: Name of the PivotTable.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.3 ]

worksheet

For EACH ITEM in the collection: The worksheet containing the current PivotTable.

worksheet?: Excel.Interfaces.WorksheetLoadOptions;

Property Value

Remarks

[ API set: ExcelApi 1.3 ]