点击查看:蓝桥杯历年真题 题解目录
Excel地址
1.基本思路和进制转换相似
2.利用余数,选择字符,添加在字符串末尾
3.最后将字符串逆序
import java.util.*;
public class Main007_Excel地址 {
public static void main(String[] args) {
// TODO Auto-generated method stub
Scanner in = new Scanner(System.in);
int a = in.nextInt();
String str = "ZABCDEFGHIJKLMNOPQRSTUVWXY";
StringBuffer sb = new StringBuffer();
while(a>0) {
if(a%26==0) {
sb.append(str.charAt(a%26));
a=a-26;
}else {
sb.append(str.charAt(a%26));
}
a=a/26;
}
sb.reverse();
System.out.println(sb);
}
}