apps-script-utils 2.1.1 Help

extractRangeFromA1Notation

function extractRangeFromA1Notation(a1Notation: string): string | null;

Everything after the ! — and the whole string when there is no ! at all, since a bare notation is already only a range.

Parameters

Parameter

Type

Description

a1Notation

string

The notation to read.

Returns

string | null — the range part.

Examples

Extracting

extractRangeFromA1Notation("Sheet1!A1:B2"); // => "A1:B2"

See also

Source

src/appsscript/sheet/extractRangeFromA1Notation.ts

23 September 2026

This documentation was generated with AI (Claude) from the library's source code.