Collected C++, Python, TypeScript solutions for excel sheet column number. Add a dedicated write-up later if you want deeper notes.
auto-generated entry for Excel Sheet Column Number. the solution files are available below.
excel-sheet-column-number/synced-solution.cppexcel-sheet-column-number/synced-solution.pyexcel-sheet-column-number/synced-solution.tsclass Solution:
def titleToNumber(self, columnTitle: str) -> int:
result = class="syntax-number">0
for char in columnTitle:
result = result * class="syntax-number">26 + (ord(char) - ord(class="syntax-string">'A') + class="syntax-number">1)
return result
class Solution {
public:
int titleToNumber(string columnTitle) {
int result = class="syntax-number">0;
for (char c : columnTitle) {
result = result * class="syntax-number">26 + (c - class="syntax-string">'A' + class="syntax-number">1);
}
return result;
}
};
function titleToNumber(columnTitle: string): number {
let result = class="syntax-number">0;
for (const char of columnTitle) {
result = result * class="syntax-number">26 + (char.charCodeAt(class="syntax-number">0) - class="syntax-number">65 + class="syntax-number">1);
}
return result;
}