apps-script-utils 2.1.1 Help

getColumnLetterByPosition

function getColumnLetterByPosition(columnPosition: number): string;

Indices count from zero, the way a GridRange does; positions count from one, the way getRange(row, column) does. Mixing the two is the usual source of an off-by-one in a spreadsheet script, which is why both pairs exist under separate names.

Parameters

Parameter

Type

Description

columnPosition

number

The zero-based column position (e.g., 1 for 'A').

Returns

string — the column letter.

Examples

Converting

getColumnLetterByPosition(1); // => "A" getColumnLetterByPosition(27); // => "AA"

See also

Source

src/appsscript/sheet/getColumnLetterByPosition.ts

23 September 2026
getColumnLetterByIndexgetColumnPositionByLetter

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