Excel.Interfaces.PivotItemData interface

Package:

excel

An interface describing the data returned by calling pivotItem.toJSON().

Properties

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

id

ID of the PivotItem.

id?: string;

Property Value

string

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?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

visible

Specifies if the PivotItem is visible.

visible?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]