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
Solution1:
思路：这道题相对于column那题简单了很多。从末位开始读数累加即可。
public class Solution { public int titleToNumber(String s) { int res=0; int pow=0; for(int i=s.length()-1;i>=0;i--) { res+=(s.charAt(i)-‘A‘+1)*Math.pow(26,pow); pow++; } return res; } }
Solution2:
看了discussion，可以从头开始读。
public class Solution { public int titleToNumber(String s) { int value = 0; for(int i = 0; i < s.length(); i++) value = value * 26 + ((int)s.charAt(i) - ‘A‘) + 1; return value; } }
171. Excel Sheet Column Number
原文：http://www.cnblogs.com/Machelsky/p/5877875.html