excel pivottable

Excel: Pivot Table

Pivot table operations.

Path: /{SheetName}/pivottable[N]

Operations

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

query

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

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

remove

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

---

Based on OfficeCLI v1.0.40