EasyNo. 0171

Excel Sheet Column Number — LeetCode 171 Python Solution

Topics
Math, String
Reading time
2 min

The problem

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

Example

Example
A -> 1
B -> 2
C -> 3
...
Z -> 26
AA -> 27
AB -> 28 
...

Python solution

PythonSolution
class Solution:
    def titleToNumber(self, columnTitle: str) -> int:
        ans = 0
        for c in map(ord, columnTitle):
            ans = ans * 26 + c - ord("A") + 1
        return ans

Complexity

Time
O(n)where n is the length of the string `columnTitle`
Space · auxiliary
O(1)

Pattern: Math and Number Theory

Find the closed form, the invariant, or the modular identity — and skip the loop entirely. LeetCode 171. Excel Sheet Column Number is filed here on both counts: the reference solution below belongs to the algorithm family this hub collects, and LeetCode tags it Math.

The math and number theory guide has the Python template for the pattern and the 485 LeetCode problems that use it.

Related problems

Related problems
No.ProblemDifficulty
0168Excel Sheet Column TitleEasy
0043Multiply StringsMedium
0273Integer to English WordsHard
0412Fizz BuzzEasy
0415Add StringsEasy
0504Base 7Easy

Frequently asked questions

How hard is LeetCode 171. Excel Sheet Column Number?

LeetCode 171. Excel Sheet Column Number is rated Easy on LeetCode.

What is the time complexity of LeetCode 171. Excel Sheet Column Number?

The Python solution on this page runs in O(n), where n is the length of the string `columnTitle`.

What is the space complexity of LeetCode 171. Excel Sheet Column Number?

The Python solution on this page uses O(1) auxiliary space.

What topics does LeetCode 171. Excel Sheet Column Number cover?

LeetCode 171. Excel Sheet Column Number is tagged Math and String on LeetCode.

Stuck on problems like this in a live interview?

Stealth Interview is a desktop app for macOS and Windows. It reads the problem off your screen and returns a working solution with a step-by-step explanation and its time and space complexity, invisible to screen sharing.

Free to download. Check it runs on your machine, then pick a plan.