Skip to main content

ConsolidationFunction

ST_DataConsolidateFunction; VBA’s XlConsolidationFunction. Import from @reductoai/xlsx/officejs.

PivotAxis

Not exported by name. You get it from the API.

PivotEditor

What the layout and hierarchy handles read and edit through. Not exported by name. You get it from the API.

PivotFilters

Excel.PivotFilters; a date filter is refused. Import from @reductoai/xlsx/officejs.

PivotFilterType

Not exported by name. You get it from the API.

PivotItemsHost

What a field’s items read and write their filter through. Not exported by name. You get it from the API.

PivotLabelFilter

Import from @reductoai/xlsx/officejs.

PivotManualFilter

Excel.PivotManualFilter: the items to show, by name or handle. Import from @reductoai/xlsx/officejs.

PivotValueFilter

Import from @reductoai/xlsx/officejs.

ShowAsCalculation

Not exported by name. You get it from the API.

ShowAsRule

baseItem takes Excel’s “(previous)” and “(next)” as names too (extension; VBA’s xlPrevious/xlNext): the item before or after each cell’s own. Not exported by name. You get it from the API.

SlicerCrossFilter

Slicer Settings’ items with no data, VBA’s CrossFilterType. Not exported by name. You get it from the API.

SlicerSortType

Import from @reductoai/xlsx/officejs.