Skip to content

excel autofilter add

zmworm edited this page Apr 22, 2026 · 48 revisions

Excel: AutoFilter - add

Add an autofilter for column-based data filtering.

Path: /{SheetName}

Properties

Property Default Description
range (required) Filter range (e.g., A1:D100). Must parse as a valid cell range; malformed values are rejected at add.

Examples

officecli add data.xlsx /Sheet1 --type autofilter --prop range=A1:D100
officecli add data.xlsx /Sheet1 --type autofilter --prop range=A1:F1

Based on OfficeCLI v1.0.54

Clone this wiki locally