publicclassExcelToNum{publicstaticintexceltonum(String str){int result =0;for(int i =0; i < str.length(); i++){
result = result *26+(str.charAt(i)-'a'+1);System.out.println(result);}return result;}publicstaticvoidmain(String[] args){System.out.println(exceltonum("ba"));}}
三、正整数转换为Excel
publicclassNumToExcel{publicstaticStringnumtoexcel(int num){StringBuilder sb =newStringBuilder();while(num >0){
num--;
sb.append((char)('a'+ num %26));
num /=26;}return sb.toString();}publicstaticvoidmain(String[] args){System.out.println(numtoexcel(53));}}