Journal Archive

2022

/**
 * @param {string} columnTitle
 * @return {number}
 */
var titleToNumber = function(columnTitle) {
    let res = 0;
    for (let i = columnTitle.length - 1, j = 0; i >= 0; i--, j++) {
        res += (columnTitle[i].charCodeAt() - 64) * Math.pow(26, j);
    }
    return res;
};

Day 68: Solving one of LeetCode problems

171. Excel Sheet Column Number Difficulty - Easy

Given a string columnTitle that represents the column title as appears in an Excel sheet, return its corresponding column number.

For example:

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

 

Example 1:

Input: columnTitle = "A"
Output: 1

Example 2:

Input: columnTitle = "AB"
Output: 28

Example 3:

Input: columnTitle = "ZY"
Output: 701