Expand description
Cell reference conversion utilities.
Provides functions for converting between A1-style cell references
(e.g. "A1", "$AB$100", "XFD1048576") and 1-based (col, row)
numeric coordinates.
Functionsยง
- cell_
name_ to_ coordinates - Parse an A1-style cell reference into
(col, row)coordinates (both 1-based). - column_
name_ to_ number - Convert a column name (e.g.
"A","Z","AA","XFD") to a 1-based column number. - column_
number_ to_ name - Convert a 1-based column number to its letter name.
- coordinates_
to_ cell_ name - Convert 1-based
(col, row)coordinates to an A1-style cell reference.