Excel.Interfaces.PivotItemUpdateData interface

An interface for updating data on the PivotItem object, for use in pivotItem.set({ ... }).

Properties

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.

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

isExpanded?: boolean;

boolean

Name of the PivotItem.

name?: string;

string

Specifies if the PivotItem is visible.

visible?: boolean;

boolean