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.