【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 

思路很简单，其实就是一个算法 tmp = tmp*26 + 那个值的ASCII码-64（65是A）

package testAndfun;

public class ExcelSheetColumnNumber {
	public static void main(String args[]){
		ExcelSheetColumnNumber ecn = new ExcelSheetColumnNumber();
		System.out.println(ecn.titleToNumber("AA"));
	}
	public int titleToNumber(String s) {
		int tmp = 0;
        for(int i=0;i<s.length();i++){
        	int in = s.charAt(i)-64;
        	tmp = tmp*26+in;
        }
        return tmp;
    }
}

顺便我也把python给写了~

class Solution:
    def titleToNumber(self, s):
        ans = 0
        for e in s:
            ans = ans * 26 + ord(e) - ord('A') + 1
        return ans

简单之极~