Excel.Interfaces.PivotFieldUpdateData interface

An interface for updating data on the PivotField object, for use in pivotField.set({ ... }).

Properties

name

Name of the PivotField.

showAllItems

Determines whether to show all items of the PivotField.

subtotals

Subtotals of the PivotField.

Property Details

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 ]