Related to question Excel Sheet Column Title
Given a column title as appear in an Excel sheet, return its corresponding column number.
For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28Solution: 参照168, 26进制 逆转换
class Solution:
# @param s, a string
# @return an integer
def titleToNumber(self, s):
result = 0
myDict = {}
length = len(s)
alphabeta = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
for char in alphabeta:
myDict[char] = ord(char) - 64
for i in range(length):
result += myDict[s[i]] * pow(26, length-i-1)
return result