Skip to content

excel namedrange add

zmworm edited this page Apr 8, 2026 · 51 revisions

Excel: Named Range - add

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

Path: / (workbook root)

Properties

Property Default Description
name (required) Name identifier (e.g., TaxRate)
ref (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

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.38

Clone this wiki locally