题目描述:Given a positive integer, return its corresponding column title as appear in an Excel sheet.
For example:
分析:根据数字返回在excel表格中的表示1 -> A
2 -> B
3 -> C
…
26 -> Z
27 -> AA
28 -> AB
解题思路:将十进制转换为二十六进制。注:初始值从1开始,在进行求模运算和除运算时要将n-1.
public String convertToTitle(int n) {
StringBuilder sb = new StringBuilder();
int temp;
while(n>0){
temp = (n-1)%26;
sb.append((char)(temp+'A'));
n=(n-1)/26;
}
return sb.reverse().toString();
}