excel pivottable get

Excel: Pivot Table - get

Get pivot table properties and field configuration.

Path: /{SheetName}/pivottable[N]

Attributes

Attribute	Type	Description
name	string	Pivot table name
cacheId	number	Cache definition ID
location	string	Cell range where the pivot table is placed
fieldCount	number	Total number of fields
rowFields	string	Comma-separated list of row field names
colFields	string	Comma-separated list of column field names
filterFields	string	Comma-separated list of filter field names
dataFieldCount	number	Number of data (value) fields
dataField1..dataFieldN	string	Data field info, format: name:func:fieldIdx
style	string	Applied pivot table style name

Examples

# Get pivot table properties
officecli get data.xlsx /Sheet1/pivottable[1]

/Sheet1/pivottable[1]
  name: SalesPivot
  cacheId: 1
  location: H1:K15
  fieldCount: 5
  rowFields: Region,Category
  colFields: Year
  filterFields: Status
  dataFieldCount: 2
  dataField1: Sales:sum:3
  dataField2: Qty:count:4
  style: PivotStyleMedium9

# Get as JSON
officecli get data.xlsx /Sheet1/pivottable[1] --json

See Also

• Pivot Table - Overview of pivot table operations
• Pivot Table add - Create pivot tables
• get - Excel - All Excel get paths

---

Based on OfficeCLI v1.0.18