Skip to content

171. Excel Sheet Column Number

Math String

Problem - Excel Sheet Column Number

Easy

Given a string columnTitle that represents the column title as appears 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: columnTitle = "A"
Output: 1

Example 2:

Input: columnTitle = "AB"
Output: 28

Example 3:

Input: columnTitle = "ZY"
Output: 701

 

Constraints:

  • 1 <= columnTitle.length <= 7
  • columnTitle consists only of uppercase English letters.
  • columnTitle is in the range ["A", "FXSHRXW"].

Solutions

1
2
3
4
5
6
7
8
class Solution:
    def titleToNumber(self, columnTitle: str) -> int:
        result = 0

        for char in map(ord, columnTitle):
            result = result*26 + (char - ord("A")) + 1

        return result

Submission Stats:

  • Runtime: 0 ms (100.00%)
  • Memory: 17.7 MB (48.65%)