excel namedrange set

Excel: Named Range - set

Modify an existing named range.

Path: /namedrange[N] or /namedrange[Name]

Properties

Property	Accepted Values	Description
ref / refersTo / formula	cell/range reference	Update the referenced range. refersTo/formula are accepted aliases (v1.0.133+, matching Add); a leading = on formula is stripped the same way Add strips it.
name	text	Rename the range
scope	sheet name or workbook	Set the scope of the named range
comment	string	Update description

Examples

officecli set data.xlsx /namedrange[TaxRate] --prop ref="Sheet1!B2"
officecli set data.xlsx /namedrange[SalesRange] --prop comment="Updated sales data range"

# refersTo / formula aliases (v1.0.133+)
officecli set data.xlsx /namedrange[TaxRate] --prop refersTo="Sheet1!C3"
officecli set data.xlsx /namedrange[TaxRate] --prop formula="=Sheet1!D4"

---

Based on OfficeCLI v1.0.133