conversions.excel_title_to_column

Functions

excel_title_to_column(→ int)

Given a string column_title that represents

Module Contents

conversions.excel_title_to_column.excel_title_to_column(column_title: str) → int

Given a string column_title that represents the column title in an Excel sheet, return its corresponding column number.

>>> excel_title_to_column("A")
1
>>> excel_title_to_column("B")
2
>>> excel_title_to_column("AB")
28
>>> excel_title_to_column("Z")
26
>>> excel_title_to_column("a")
1
>>> excel_title_to_column("ab")
28
>>> excel_title_to_column("")
Traceback (most recent call last):
    ...
ValueError: Column title must contain only alphabetic characters.
>>> excel_title_to_column("A1")
Traceback (most recent call last):
    ...
ValueError: Column title must contain only alphabetic characters.