藍橋杯第八屆真題 ：Excel位址

點選檢視：藍橋杯曆年真題 題解目錄

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);
    }
}