Python convert column number headings to letters

def col_num_to_char(col):
    char = ''
    div = col
    while div:
        div, mod = divmod(div - 1, 26)
        char = chr(mod + 65) + char
    return char
>>> print(col_num_to_char(1))
A
>>> print(col_num_to_char(2))
B
>>> print(col_num_to_char(3))
C
>>> print(col_num_to_char(24))
X
>>> print(col_num_to_char(25))
Y
>>> print(col_num_to_char(26))
Z
>>> print(col_num_to_char(27))
AA
>>>
kw: Microsoft Excel, Google Sheets, A1, R1C1, spreadsheet, column, row
Did this help you? Please let me know with a comment. Thank you
Posted .

Comments (RSS)

Leave a comment