EasyNo. 0168
Excel Sheet Column Title — LeetCode 168 Python Solution
- Pattern
- Math and Number Theory
- Topics
- Math, String
- Reading time
- 2 min
- Source
- leetcode.com
The problem
Given an integer columnNumber, return its corresponding column title as it appears in an Excel sheet. For example: A -> 1 B -> 2 C -> 3 ...
Example
A -> 1 B -> 2 C -> 3 ... Z -> 26 AA -> 27 AB -> 28 ...
Python solution
class Solution:
def convertToTitle(self, columnNumber: int) -> str:
res = []
while columnNumber:
columnNumber -= 1
res.append(chr(ord('A') + columnNumber % 26))
columnNumber //= 26
return ''.join(res[::-1])Complexity
- Time
- O(n) or O(1)
- 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 168. Excel Sheet Column Title 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
| No. | Problem | Difficulty |
|---|---|---|
| 0171 | Excel Sheet Column Number | Easy |
| 0043 | Multiply Strings | Medium |
| 0273 | Integer to English Words | Hard |
| 0412 | Fizz Buzz | Easy |
| 0415 | Add Strings | Easy |
| 0504 | Base 7 | Easy |
Frequently asked questions
- How hard is LeetCode 168. Excel Sheet Column Title?
LeetCode 168. Excel Sheet Column Title is rated Easy on LeetCode.
- What topics does LeetCode 168. Excel Sheet Column Title cover?
LeetCode 168. Excel Sheet Column Title is tagged Math and String on LeetCode.