Edit

Share via

Excel.Interfaces.PivotFieldLoadOptions interface

  • Reference
Package:
excel

Represents the Excel PivotField.

Remarks

[ API set: ExcelApi 1.8 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).
id

ID of the PivotField.
name

Name of the PivotField.
showAllItems

Determines whether to show all items of the PivotField.
subtotals

Subtotals of the PivotField.

Property Details

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as Range.format.fill.color).

$all?: boolean;

Property Value

boolean

id

ID of the PivotField.

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotField.

name?: boolean;

Property Value

boolean

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?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]