Edit

Excel.Interfaces.PivotItemLoadOptions interface

  • Reference
Package:
excel

Represents the Excel PivotItem.

Remarks

[ API set: ExcelApi 1.8 ]

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 PivotItem.
isExpanded

Determines whether the item is expanded to show child items or if it's collapsed and child items are hidden.
name

Name of the PivotItem.
visible

Specifies if the PivotItem is visible.

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

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

isExpanded

Determines whether the item is expanded to show child items or if it's collapsed and child items are hidden.

isExpanded?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotItem.

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

visible

Specifies if the PivotItem is visible.

visible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]