首页 > 其他 > 详细

Excel Sheet Column Title

时间:2015-05-28 00:50:13      阅读:262      评论: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 

通过的程序如下:

public class Solution {
    public String convertToTitle(int n) {
         int index = 26;
        String excelTitle = "";
        int temp = n;
        while (temp > 0) {
            int mod = temp % index;
            temp = temp / index;
            if (mod == 0) {
                temp--;
                excelTitle = ‘Z‘ + excelTitle;
            } else {
                excelTitle = (char)(‘A‘ -1 + mod) +excelTitle;
            }
        }
        return  excelTitle;
    }
}

Excel Sheet Column Title

原文:http://blog.csdn.net/qunzer/article/details/46056185

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