[LeetCode&Python] Problem 171. Excel Sheet Column Number

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 
    ...

Example 1:

Input: "A"
Output: 1

Example 2:

Input: "AB"
Output: 28

Example 3:

Input: "ZY"
Output: 701
 
class Solution(object):
    def titleToNumber(self, s):
        """
        :type s: str
        :rtype: int
        """
        ans=0
        n=len(s)-1
        for i in range(len(s)):
            ans+=(ord(s[i])-ord('A')+1)*(26**(n-i))
        return ans

  

posted on 2018-11-16 10:06  chiyeung  阅读(114)  评论(0)    收藏  举报

导航