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

Excel Sheet Column Title

Collected C++, Python, TypeScript solutions for excel sheet column title. Add a dedicated write-up later if you want deeper notes.

View original LeetCode question

auto-generated entry for Excel Sheet Column Title. the solution files are available below.

solution files

C++ excel-sheet-column-title/synced-solution.cpp
Python excel-sheet-column-title/synced-solution.py
TypeScript excel-sheet-column-title/synced-solution.ts

Solution files

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

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

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

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

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

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