211111-Python十进制转二十六(用于Excel表格自动化统计)

211111-Python十进制转二十六(用于Excel表格自动化统计)

base = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
def decTo26(num):
    l = []
    while True:
        num,rem = divmod(num, 26)
        print(num, rem)
        l.append(base[rem-1])
        if num == 0:
            print(l)
            return ''.join(l[::-1])

num = 27
print(decTo26(num))

1 1
0 1
['A', 'A']
AA