Excel.Interfaces.PivotFieldUpdateData interface

Package:

excel

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

Excel.Subtotals

Remarks

[Api set: ExcelApi 1.8]