DEV Community

Abhishek Chaudhary
Abhishek Chaudhary

Posted on

Excel Sheet Column Number

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

SOLUTION:

class Solution:
    def titleToNumber(self, columnTitle: str) -> int:
        total = 0
        for c in columnTitle:
            total = 26 * total + ord(c) - ord('A') + 1
        return total
Enter fullscreen mode Exit fullscreen mode

Top comments (0)