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 

Credits:
Special thanks to @ts for adding this problem and creating all test cases.

 


class Solution(object):
    def titleToNumber(self, s):
        """
        :type s: str
        :rtype: int
        """
        result = 0  
        n = len(s)  
        for i in range(n):  
            result = result*26+ord(s[i])-64  
        return result  

 

 
posted @ 2017-09-30 19:06  bernieloveslife  阅读(140)  评论(0编辑  收藏  举报