excel namedrange get

Excel: Named Range - get

Get named range (defined name) properties.

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

Attributes

Attribute	Type	Description
name	string	The defined name
ref	string	Referenced cell or range (e.g., Sheet1!A1:D10)
scope	string	Sheet name (only present for sheet-scoped ranges; absent for workbook-scoped)
comment	string	Description or comment for the named range

Examples

# Get named range by name
officecli get data.xlsx "/namedrange[SalesRange]"

/namedrange[SalesRange]
  name: SalesRange
  ref: Sheet1!B2:B100
  comment: Monthly sales figures

# Get named range by index
officecli get data.xlsx /namedrange[1]

# Get as JSON
officecli get data.xlsx "/namedrange[SalesRange]" --json

See Also

• Named Range - Overview of named range operations
• Named Range set - Modify a named range
• get - Excel - All Excel get paths

---

Based on OfficeCLI v1.0.34