Excel Sheet Column Title

来源：互联网发布：精日知乎编辑：程序博客网时间：2024/05/21 23:33

Given a positive integer, return its corresponding column title as appear in an Excel sheet.

For example:

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

Credits:
Special thanks to @ifanchu for adding this problem and creating all test cases.

Subscribe to see which companies asked this question

Tags

Math

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------

因为这里的值是以1为基准的，而不是0，相当于26进制的数都整体减1，才能对应上从0开始的十进制数。

/** * @param {number} n * @return {string} */var convertToTitle = function(n) {    if(n<=26) {        return String.fromCharCode(64 + n);    }        var ret = "";    while(n > 0) {        n--;        var a = n % 26;        ret = String.fromCharCode(65 + a) + ret;        n = Math.floor(n/26);    }        return ret;};

0 0