Edit

Excel.Interfaces.PivotFieldUpdateData interface

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

Remarks

Used by

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