Skip to content

168. Excel Sheet Column Title

Math String

Problem - Excel Sheet Column Title

Easy

Given an integer columnNumber, return its corresponding column title as it appears in an Excel sheet.

For example:

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

 

Example 1:

Input: columnNumber = 1
Output: "A"

Example 2:

Input: columnNumber = 28
Output: "AB"

Example 3:

Input: columnNumber = 701
Output: "ZY"

 

Constraints:

  • 1 <= columnNumber <= 231 - 1

Solutions

1
2
3
4
5
6
7
8
9
class Solution:
    def convertToTitle(self, columnNumber: int) -> str:
        result = []
        while columnNumber:
            columnNumber -= 1
            result.append(chr(ord("A") + columnNumber % 26))
            columnNumber //= 26

        return "".join(result[::-1])

Submission Stats:

  • Runtime: 0 ms (100.00%)
  • Memory: 17.8 MB (62.94%)