TypeScript 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: Akmelo.Context): Promise<void>. Use await only for methods whose signature returns a Promise.
Methods
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 TypeScript 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 TypeScript this is not a flat list of four numbers.
const result = ctx.documents().coordinates().bounds('A1:B3');