Python实现excel的列名称转数字、26进制（A-Z）与1

参考文章：[PYTHON]26进制（A-Z）与10进制互相转换

Python实现excel的列名称转数字、26进制（A-Z）与10进制互相转换

sequence = list( map( lambda x: chr( x ), range( ord( 'A' ), ord( 'Z' ) + 1 ) ) )

##-----字母转数字（python实现 1-26=A-Z, then AA-AZ）
def ten2TwentySix(num):
    L = []
    num=num-1;  #实现从1对应A
    if num > 25:
        while True:
            d = int( num / 26 )
            remainder = num % 26
            if d <= 25:
                L.insert( 0, sequence[remainder] )
                L.insert( 0, sequence[d - 1] )
                break
            else:
                L.insert( 0, sequence[remainder] )
                num = d - 1
    else:
        L.append( sequence[num] )
    return "".join( L )


def twentySix2Ten(s):
    l = len( s )
    sum = 1    #实现从A对应1
    if l > 1:
        for i in range( l - 1 ):
            index = sequence.index( s[i] )
            print( index )
            num = pow( 26, l - 1 ) * (index + 1)
            print( num )
            l = l - 1
            sum = sum + num
        sum = sum + sequence.index( s[-1] )
    else:
        sum = sum + sequence.index( s[-1] )
    return sum


if __name__ == '__main__':
    print( ten2TwentySix( 100 ) )
    print( twentySix2Ten( 'Z' ) )