Skip to content

excel namedrange get

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

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

Based on OfficeCLI v1.0.64

Clone this wiki locally