本文共 535 字,大约阅读时间需要 1 分钟。
??????????Excel????????26??????Excel??????????????????????1?26????1??A?26??Z?27??AA?????????????????????????????0????????Z???????????????
???????????
public String convertToTitle(int columnNumber) { StringBuilder sb = new StringBuilder(); while (columnNumber != 0) { columnNumber--; int remainder = columnNumber % 26; sb.insert(0, (char)(remainder + 'A')); columnNumber /= 26; } return sb.toString();}
???????columnNumber?1???????????????????columnNumber??26??????????????????0??????????????????
转载地址:http://vftc.baihongyu.com/