15 Jun 2024•Easy•C++ / Python / TypeScript

Excel Sheet Column Title

C++, Python and TypeScript solutions for Excel Sheet Column Title.

The Excel Sheet Column Title solutions are below.

Solution files

Python•excel-sheet-column-title/synced-solution.py

class Solution:
    def convertToTitle(self, columnNumber: int) -> str:
        result = ""
        while columnNumber > 0:
            columnNumber -= 1
            result = chr(ord('A') + columnNumber % 26) + result
            columnNumber //= 26
        return result

C++•excel-sheet-column-title/synced-solution.cpp

class Solution {
public:
    string convertToTitle(int columnNumber) {
        string result = "";
        while (columnNumber > 0) {
            columnNumber--;
            result = char('A' + columnNumber % 26) + result;
            columnNumber /= 26;
        }
        return result;
    }
};

TypeScript•excel-sheet-column-title/synced-solution.ts

function convertToTitle(columnNumber: number): string {
    let result = "";
    while (columnNumber > 0) {
        columnNumber--;
        result = String.fromCharCode(65 + (columnNumber % 26)) + result;
        columnNumber = Math.floor(columnNumber / 26);
    }
    return result;
}