首页 > 其他 > 详细

Excel Sheet Column Title

时间:2016-02-27 12:27:05      阅读:122      评论:0      收藏: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 
cpp:
class Solution {
public:
    string convertToTitle(int n) {
        string result;

        int a;
        while (n > 0) {
            a = (n - 1) % 26;
            n = (n - 1) / 26;
            result.push_back(a + A);
        }

        reverse(result.begin(), result.end());
        return result;
    }
};

python:

class Solution(object):
    def convertToTitle(self, n):
        s = []
        while n > 0:
            a = (n - 1) % 26
            s.append(chr(a+65))
            n = int((n - 1) / 26)
        return ‘‘.join(s[::-1])

 

Excel Sheet Column Title

原文:http://www.cnblogs.com/wxquare/p/5222529.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!