Function letterToCol

  • Converts a column letter (e.g., A, B, C, ..., Z, AA, AB, ...) to a column number.

    Parameters

    • A: string

      The column letter to convert.

    • zeroIndexed: boolean = false

      Optional. If true, the function will return a zero-indexed column number. Default is false.

    Returns number

    The column number corresponding to the input column letter.

    Throws

    Will throw an error if the input column letter is invalid.

    Example

    letterToCol('A');;
    //=> 1
    letterToCol('Z');;
    //=> 26
    letterToCol('AA');;
    //=> 27
    letterToCol('AB', true);;
    //=> 27

Generated using TypeDoc