Edit

Excel.Interfaces.PivotTableUpdateData interface

  • Reference
Package:
excel

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

Properties

allowMultipleFiltersPerField

Specifies if the PivotTable allows the application of multiple PivotFilters on a given PivotField in the table.
enableDataValueEditing

Specifies if the PivotTable allows values in the data body to be edited by the user.
name

Name of the PivotTable.
refreshOnOpen

Specifies whether the PivotTable refreshes when the workbook opens. Corresponds to "Refresh on load" setting in the UI.
useCustomSortLists

Specifies if the PivotTable uses custom lists when sorting.

Property Details

allowMultipleFiltersPerField

Specifies if the PivotTable allows the application of multiple PivotFilters on a given PivotField in the table.

allowMultipleFiltersPerField?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.12 ]

enableDataValueEditing

Specifies if the PivotTable allows values in the data body to be edited by the user.

enableDataValueEditing?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

name

Name of the PivotTable.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.3 ]

refreshOnOpen

Specifies whether the PivotTable refreshes when the workbook opens. Corresponds to "Refresh on load" setting in the UI.

refreshOnOpen?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.13 ]

useCustomSortLists

Specifies if the PivotTable uses custom lists when sorting.

useCustomSortLists?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]