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
比较简单 与excel sheet column title这道 题正好 是反的。之前做过,所以简单许多,两次就过了
public static int titleToNumber(String s) {
int result = 0;
int s_len = s.length();
int value;
for (int i = s_len - 1; i >= 0; i--) {
value = s.charAt(i) - 64;
value *= Math.pow(26, s_len - i - 1);
result += value;
}
return result;
}