Skip to content

excel namedrange add

Jump to bottom
zmworm edited this page Apr 29, 2026 · 51 revisions

Excel: Named Range - add

Add a named range (defined name) to the workbook.

Path: / (workbook root), or /namedrange[NAME] to address an existing name by identifier

Properties

Property Default Description
name (required) Name identifier (e.g., TaxRate). Must start with a letter or underscore, no spaces, and must not parse as a cell reference — validated per OOXML §18.2.5; invalid names throw at add.
ref / refersTo (required) Cell/range reference (e.g., Sheet1!A1, Sheet1!A1:B10)
scope workbook workbook or sheet name for sheet-level scope
comment Description of the named range
volatile false Mark the name as volatile (formulas re-evaluate on every recalc).

/namedrange[@name=X] is supported as a query/get/set selector (in addition to the positional /namedrange[N]).

Examples

officecli add data.xlsx / --type namedrange --prop name="TaxRate" --prop ref="Sheet1!B1"
officecli add data.xlsx / --type namedrange --prop name="SalesRange" --prop ref="Sheet1!A1:D100" --prop comment="All sales data"
officecli add data.xlsx / --type namedrange --prop name="LocalName" --prop ref="Sheet1!C1:C50" --prop scope="Sheet1"

Based on OfficeCLI v1.0.64

Clone this wiki locally