给定一个出现在Excel表中的列标题,返回它对应的列数字
For example:
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ...Example 1:
Input: "A" Output: 1Example 2:
Input: "AB" Output: 28Example 3:
Input: "ZY" Output: 701
1:和"Excel表列名称(https://mp.csdn.net/postedit/82630223)"类似,用倒序字符串和ord()方法即可
def titleToNumber(self, s):
"""
:type s: str
:rtype: int
"""
sum = 0
for i, j in enumerate(s[::-1]):
sum += (ord(j)-ord('A')+1)*26**i
return sum