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' ) )