Function a1ToCellRef

  • a1ToCellRef(a1: string): CellRef

    Parse an A1-style label back into a CellRef.

    Parameters

    • a1: string

      Label such as "A1" or "bc42" (case-insensitive).

    Returns CellRef

    The corresponding zero-based CellRef.

    Throws

    Error when the input does not match [A-Z]+[0-9]+ or the row component would resolve to a negative index.

Settings

Member Visibility