【问题描述】
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【思路1】
26进制,按位减asicc64得到值后相加。
public static int titleToNumber(String s) {
int n = 0; // 总数
int temp; // 每一位asicc码
int count = 0;
for (int i = (s.length() - 1); i >= 0; i--) {
temp = s.charAt(i) - 64;
System.out.println("temp:" + temp);
n += (int) Math.pow(26, count) * temp;
System.out.println("n" + n);
count++;
}
return n;
}
public static int titleToNumber2(String s){
int n = 0;
int temp = 0;
for (int i = 0; i < s.length(); i++) {
temp = s.charAt(i) - 64;
n = n*26 + temp;
}
return n;
}