Pivot table operations.

Path: /{SheetName}/pivottable[N]

• add - Create pivot tables
• set - Modify field layout, aggregation, display, styling
• get - Returned attributes

Selector: pivottable, pivot. Supports :contains() on name.

officecli query data.xlsx "pivottable"
officecli query data.xlsx 'pivot:contains("Sales")'

officecli remove data.xlsx /Sheet1/pivottable[1]

Based on OfficeCLI v1.0.52