Excel.Interfaces.PivotFieldData interface

Package:

excel

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

Properties

id	ID of the PivotField.
items	Returns the PivotItems associated with the PivotField.
name	Name of the PivotField.
showAllItems	Determines whether to show all items of the PivotField.
subtotals	Subtotals of the PivotField.

Property Details

id

ID of the PivotField.

id?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

items

Returns the PivotItems associated with the PivotField.

items?: Excel.Interfaces.PivotItemData[];

Property Value

Excel.Interfaces.PivotItemData[]

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotField.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

showAllItems

Determines whether to show all items of the PivotField.

showAllItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

subtotals

Subtotals of the PivotField.

subtotals?: Excel.Subtotals;

Property Value

Excel.Subtotals

Remarks

[ API set: ExcelApi 1.8 ]