首页 > 其他 > 详细

Excel Sheet Column Title

时间:2016-05-09 08:28:40      阅读:186      评论: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 

The key is n--. The minimum in 26-bit number is mapped to 1, not 0.

 

public class Solution {
    public String convertToTitle(int n) {
        if(n<=0)return "";
        
        
        StringBuilder sb = new StringBuilder();
        while(n>0)
        {
            n--;
            char c = (char)(n%26+‘A‘);
            sb.append(c);
            n = n/26;
        }
        sb.reverse();
        
        return sb.toString();
    }
}

reference: http://www.programcreek.com/2014/03/leetcode-excel-sheet-column-title-java/

 

 

另一种解法:

public class Solution {
    public String convertToTitle(int n) {
        StringBuilder result = new StringBuilder();

        while(n>0){
            n--;
            result.insert(0, (char)(‘A‘ + n % 26));
            n /= 26;
        }

        return result.toString();
    }
}

reference: https://leetcode.com/discuss/19150/accepted-java-solution

Excel Sheet Column Title

原文:http://www.cnblogs.com/hygeia/p/5472503.html

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