Excel Sheet Column Title

最新推荐文章于 2024-03-05 12:33:08 发布

RockPaperProgrammer

最新推荐文章于 2024-03-05 12:33:08 发布

阅读量207

点赞数

本文链接：https://blog.csdn.net/gina0613/article/details/51680417

版权

Leetcode Easy Javascript 专栏收录该内容

71 篇文章 0 订阅

订阅专栏

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;
};