[leetcode] Excel Sheet Column Title

最新推荐文章于 2019-02-22 14:12:33 发布

原创最新推荐文章于 2019-02-22 14:12:33 发布 · 362 阅读

0 ·

CC 4.0 BY-SA版权

Leetcode 专栏收录该内容

222 篇文章

订阅专栏

本文介绍了一种将正整数转换为Excel单元格标题的方法，从1到26分别对应A到Z，超过26则组合成AA, AB等。

From : https://leetcode.com/problems/excel-sheet-column-title/

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

class Solution {
public:
    string convertToTitle(int n) {
        string res = "";
        char c;
        int base = 26;
        while(n>0) {
            c = 'A' + (n%base + 25)%26;
            res = c + res;
            n = (n%26?n/26:n/26-1);
        }
        return res;
    }
};