Excel Sheet Column Title Excel Sheet Column Title 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
Excel Sheet Column Title Solutions
✅Time: O(n)
✅Space: O(1)
C++
class Solution {
public:
string convertToTitle(int n) {
return n == 0 ? ""
: convertToTitle((n - 1) / 26) + (char)('A' + ((n - 1) % 26));
}
};
Java
class Solution {
public String convertToTitle(int n) {
return n == 0 ? "" : convertToTitle((n - 1) / 26) + (char) ('A' + ((n - 1) % 26));
}
}
Python
class Solution:
def convertToTitle(self, n: int) -> str:
return self.convertToTitle((n - 1) // 26) + \
chr(ord('A') + (n - 1) % 26) if n else ''
Watch Tutorial
Checkout more Solutions here