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题意:把Excel的字母的列转换为数字。
思路:直接实现。
class Solution {
public:
int titleToNumber(string s) {
int i = 0;
int sum = 0;
while (i < s.size()){
sum = sum * 26 + (s[i] - 'A' + 1);
i++;
}
return sum;
}
};