Skip to content

excel validation

zmworm edited this page Apr 4, 2026 · 28 revisions

Excel: Data Validation

Data validation rules for cells and ranges.

Path: /{SheetName}/validation[N]

Operations

  • get - Returned attributes and output format

  • add - Add validation rules (list, number, date, etc.)

  • set - Modify existing validation rules

get

officecli get data.xlsx /Sheet1/validation[1]
officecli get data.xlsx /Sheet1/validation[2]

remove

officecli remove data.xlsx /Sheet1/validation[1]

Based on OfficeCLI v1.0.33

Clone this wiki locally