Function A1ToColRow

  • Converts an A1 notation string to a column-row pair.

    Parameters

    • A1: string

      The A1 notation string to convert.

    • zeroIndexed: boolean = false

      Optional. If true, the returned indices will be zero-based. Default is false.

    Returns number[]

    An array where the first element is the column index and the second element is the row index.

    Throws

    If the A1 string is invalid.

    Example

    //=> [1, 1]
    A1ToColRow('B2', true);
    //=> [1, 1]

Generated using TypeDoc