Java for LeetCode 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

解题思路:

JAVA实现如下:

    public int titleToNumber(String s) {
int res=0;
for(int i=0;i<s.length()-1;i++){
res+=s.charAt(i)-'A'+1;
res*=26;
}
return res+s.charAt(s.length()-1)-'A'+1;
}
上一篇:✡ leetcode 171. Excel Sheet Column Number 字母转换为数字 --------- java


下一篇:[LeetCode] 171. Excel Sheet Column Number 求Excel表列序号