Excel.Interfaces.PivotFieldData interface

  • Reference
Package:
excel

Warning

This API is now deprecated.

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

Warning

This API is now deprecated.

ID of the PivotField.

id?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

items

Warning

This API is now deprecated.

Returns the PivotItems associated with the PivotField.

items?: Excel.Interfaces.PivotItemData[];

Property Value

Excel.Interfaces.PivotItemData[]

Remarks

[ API set: ExcelApi 1.8 ]

name

Warning

This API is now deprecated.

Name of the PivotField.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.8 ]

showAllItems

Warning

This API is now deprecated.

Determines whether to show all items of the PivotField.

showAllItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

subtotals

Warning

This API is now deprecated.

Subtotals of the PivotField.

subtotals?: Excel.Subtotals;

Property Value

Excel.Subtotals

Remarks

[ API set: ExcelApi 1.8 ]