171. excel sheet column number 解答

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 

Credits:
Special thanks to @ts for adding this problem and creating all test cases.

解答

1
2
3
4
5
6
7
8
9
10
11
12
public class Solution {
public int titleToNumber(String s) {
int res = 0;
int i = 0;
while(i<s.length()) {
res *=26;
res += (s.charAt(i) - 'A')+1;
i++;
}
return res;
}
}