excel pivottable add

Excel: Pivot Table - add

Create a pivot table from a data range.

Path: /{SheetName}

Properties

Property	Required	Accepted Values	Description
source	yes	range ref	Source data range (e.g., Sheet1!A1:E100)
position		cell ref	Top-left cell for the pivot table (e.g., G1)
rows		comma-separated	Row fields (e.g., Region,Category)
cols		comma-separated	Column fields (e.g., Year,Quarter)
values		field:func pairs	Value fields with aggregation (e.g., Sales:sum,Qty:count)
filters		comma-separated	Filter fields (e.g., Status,Priority)
name		text	Pivot table name
style		style name	Pivot table style (default: PivotStyleLight16)

Aggregation Functions

Function	Aliases	Description
sum	-	Sum of values
count	-	Count of values
average	avg	Average of values
max	-	Maximum value
min	-	Minimum value
product	-	Product of values
stddev	-	Standard deviation
var	-	Variance

Examples

# Basic pivot table
officecli add data.xlsx /Sheet1 --type pivottable \
  --prop source="Sheet1!A1:E100" \
  --prop rows=Region,Category \
  --prop values="Sales:sum"

# Full pivot table with columns, filters, and style
officecli add data.xlsx /Sheet1 --type pivottable \
  --prop source="Sheet1!A1:F500" \
  --prop position=H1 \
  --prop rows=Region \
  --prop cols=Year \
  --prop values="Sales:sum,Qty:count,Price:average" \
  --prop filters=Status \
  --prop name="SalesPivot" \
  --prop style=PivotStyleMedium9

# Pivot table with multiple aggregations
officecli add data.xlsx /Sheet2 --type pivottable \
  --prop source="Sheet1!A1:D200" \
  --prop rows=Department \
  --prop values="Salary:avg,Salary:max,Headcount:count"

See Also

• Pivot Table - Overview of pivot table operations
• Pivot Table get - Returned attributes
• add - Excel - All addable Excel elements

---

Based on OfficeCLI v1.0.38