Excel.Interfaces.PivotItemCollectionLoadOptions interface

Represents a collection of all the PivotItems related to their parent PivotField.

[ API set: ExcelApi 1.8 ]

Properties

$all
id

For EACH ITEM in the collection: Id of the PivotItem.

[ API set: ExcelApi 1.8 ]

isExpanded

For EACH ITEM in the collection: Determines whether the item is expanded to show child items or if it's collapsed and child items are hidden.

[ API set: ExcelApi 1.8 ]

name

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

[ API set: ExcelApi 1.8 ]

visible

For EACH ITEM in the collection: Determines whether the PivotItem is visible or not.

[ API set: ExcelApi 1.8 ]

Property Details

$all

$all?: boolean;

Property Value

boolean

id

For EACH ITEM in the collection: Id of the PivotItem.

[ API set: ExcelApi 1.8 ]

id?: boolean;

Property Value

boolean

isExpanded

For EACH ITEM in the collection: Determines whether the item is expanded to show child items or if it's collapsed and child items are hidden.

[ API set: ExcelApi 1.8 ]

isExpanded?: boolean;

Property Value

boolean

name

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

[ API set: ExcelApi 1.8 ]

name?: boolean;

Property Value

boolean

visible

For EACH ITEM in the collection: Determines whether the PivotItem is visible or not.

[ API set: ExcelApi 1.8 ]

visible?: boolean;

Property Value

boolean