ws.names

WorksheetNames

Sub-API for sheet-scoped named range operations.

6 methods

add

→ Promise<void>

add(name: string, reference: string, comment?: string): Promise<void>;

Parameter	Type	Required
name	string	required
reference	string	required
comment	string	optional

Add a named range scoped to this sheet. @param name - Name for the range @param reference - Cell reference (e.g., "A1:B10" or "=Sheet1!A1:B10") @param comment - Optional comment

get

→ Promise<NamedRangeInfo | null>

get(name: string): Promise<NamedRangeInfo | null>;

Parameter	Type	Required
name	string	required

Get a named range by name, scoped to this sheet. @param name - Name to look up @returns Named range info or null if not found

NamedRangeInfo

getRange

→ Promise<NamedRangeReference | null>

getRange(name: string): Promise<NamedRangeReference | null>;

Parameter	Type	Required
name	string	required

Get the range reference for a named range scoped to this sheet. @param name - Name to look up @returns Range reference or null if not found

NamedRangeReference

remove

→ Promise<void>

remove(name: string): Promise<void>;

Parameter	Type	Required
name	string	required

Remove a named range scoped to this sheet. @param name - Name to remove

update

→ Promise<void>

update(name: string, updates: NamedRangeUpdateOptions): Promise<void>;

Parameter	Type	Required
name	string	required
updates	NamedRangeUpdateOptions	required

Update a named range scoped to this sheet. @param name - Name of the range to update @param updates - Fields to update

NamedRangeUpdateOptions

list

→ Promise<NamedRangeInfo[]>

list(): Promise<NamedRangeInfo[]>;

List all named ranges scoped to this sheet. @returns Array of named range info objects

NamedRangeInfo