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 -> 28
import string
class Solution(object):
def titleToNumber(self, s):
"""
:type s: str
:rtype: int
"""
upper = string.ascii_uppercase
cache = {v:i+1 for i,v in enumerate(upper)}
ans = 0
for i,v in enumerate(s[::-1]):
ans += 26**i * cache[v]
return ans

京公网安备 11010502036488号