根据列标题获取Excel列字母- Python

def get_column_letter(column_title):
    column_title = column_title.upper()
    column_number = 0
    for i in range(len(column_title)):
        column_number = column_number * 26 + (ord(column_title[i]) - ord('A') + 1)
    column_letter = ""
    while column_number > 0:
        column_number, remainder = divmod(column_number - 1, 26)
        column_letter = chr(65 + remainder) + column_letter
    return column_letter

# 示例用法
column_title = "D"
column_letter = get_column_letter(column_title)
print(column_letter)  # 输出结果为 "D"