字母轉(zhuǎn)數(shù)字

def get_index(capital):
    """
    大寫字母（Excel列頭）轉(zhuǎn)索引
    :param capital: 'A' --> 0, 'AA' --> 26
    :return: int
    """
    number = 0
    capital = capital.upper()
    for char in capital:
        number = number * 26 + ord(char) - ord('A') + 1
    return number - 1

數(shù)字轉(zhuǎn)字母

def get_char(number):
    """
    索引轉(zhuǎn)大寫字母（Excel列頭）
    :param number: 0 --> 'A', 26 --> 'AA'
    :return: str
    """
    factor, moder = divmod(number, 26)
    mod_char = chr(moder + 65)
    if factor:
        mod_char = get_char(factor - 1) + mod_char
    return mod_char