Edit

Share via

Excel.Interfaces.PivotFieldData interface

  • Reference
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 ]