Module utils

Module utils 

Source
Expand description

Utility functions for cell reference conversion.

Modules§

constants
Excel limit constants and default values.

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.