excel autofilter

Excel: AutoFilter

AutoFilter for column-based data filtering.

Path: /{SheetName}/autofilter

Operations

• add - Add an autofilter to a sheet

set

Property	Accepted Values	Description
range	cell range	Update filter range
column	column index (0-based)	Target column for filter criteria
values	comma-separated values	Filter to show only these values
filterType	value, custom	Filter mode
operator	equals, notEquals, greaterThan, lessThan, contains, notContains, beginsWith, endsWith	Custom filter operator
criteria	value	Custom filter value

officecli set data.xlsx /Sheet1/autofilter --prop column=0 --prop values="Active,Pending"
officecli set data.xlsx /Sheet1/autofilter --prop column=2 --prop filterType=custom --prop operator=greaterThan --prop criteria=1000
officecli set data.xlsx /Sheet1/autofilter --prop range=A1:G100

---

Based on OfficeCLI v1.0.64