首页 > 代码库 > 171. Excel Sheet Column Number

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 
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 = http://www.mamicode.com/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