excel pivottable

Excel: Pivot Table

Pivot table operations.

Path: /{SheetName}/pivottable[N]

Operations

• add - Create pivot tables
• get - Returned attributes

set

Property	Accepted Values	Description
name	text	Pivot table name
style	style name	Style (e.g., PivotStyleLight16)

officecli set data.xlsx /Sheet1/pivottable[1] --prop style=PivotStyleMedium9

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.11