题目:
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解题思路:
c++版本::
class Solution {
public:
int titleToNumber(string s) {
int res = 0;
for(int i=0;i<s.size();i++)
res = 26*res + (s[i]-'A'+1);
return res;
}
};
python版本:
class Solution(object):
def titleToNumber(self, s):
"""
:type s: str
:rtype: int
"""
res = 0
for l in s:
res = 26*res + (ord(l)-ord('A')+1)
return res