Excel.Interfaces.PivotFieldLoadOptions interface

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).

TypeScript

$all?: boolean;

Property Value

boolean

id

ID of the PivotField.

TypeScript

id?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

name

Name of the PivotField.

TypeScript

name?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

showAllItems

Determines whether to show all items of the PivotField.

TypeScript

showAllItems?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]

subtotals

Subtotals of the PivotField.

TypeScript

subtotals?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.8 ]