Edit

Excel.Interfaces.PivotFieldData interface

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

Remarks

Used by

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

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

Remarks

API set: ExcelApi 1.8