JavaScript SDK: SheetCoordinates: cell addresses

ctx.documents().coordinates() converts spreadsheet addresses and numeric indices. These methods run locally.

Each example is a separate fragment inside async function run(ctx). Use await only for methods whose signature returns a Promise.

Methods

• columnName()
• columnNumber()
• position()
• bounds()

columnName

ctx.documents().coordinates().columnName(column) → string

Convert a positive column number to letters: 1 → A, 27 → AA.

const result = ctx.documents().coordinates().columnName(2);

columnNumber

ctx.documents().coordinates().columnNumber(column) → number

Convert column letters to a one-based number. Pass only Latin column letters, such as B or AA.

const result = ctx.documents().coordinates().columnNumber('B');

position

ctx.documents().coordinates().position(address) → [number, number]

Converts an address such as B2 to [2, 2]. The JavaScript SDK does not accept absolute addresses with $.

const result = ctx.documents().coordinates().position('B2');

bounds

ctx.documents().coordinates().bounds(range) → Array<[number, number]>

Parses a range such as A1:B3 into two [row, column] positions. In JavaScript this is not a flat list of four numbers.

const result = ctx.documents().coordinates().bounds('A1:B3');