首页 > 代码库 > LeetCode Excel Sheet Column Number

LeetCode 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 

 1 public class Solution { 2     public int titleToNumber(String s) { 3         if (s == null || s.equals("")) { 4             return 0; 5         } 6         int ret=0; 7         while (s.length() > 0) { 8             int y=s.length()-1; 9             int first=s.charAt(0)-‘A‘+1;10             ret = (int) (ret + first * Math.pow(26, y));11             s = s.substring(1);12         }13         return ret;14     }15 }

 

LeetCode Excel Sheet Column Number