Skip to content

a1ToRowColumnOrNull

function a1ToRowColumnOrNull(a1Address): [number, number] | null;

Convert an A1 cell address into zero-based row and column indices, if possible. Like a1ToRowColumn but returns null instead of throwing an error, if a1Address is not an A1 cell address.

string

a cell address in A1 format

[number, number] | null

zero-based row and column indices, or null if a1Address is not a cell address in A1 format.