package test;
public class Demo {
public static void main(String[] args) {
int columnNum= 26;
System.out.println(getExcelColumnNum(columnNum));
}
public static String getExcelColumnNum(int columnNum) {
StringBuffer stringBuffer = new StringBuffer();
getExcelColumnNum(columnNum, stringBuffer);
return stringBuffer.toString();
}
private static void getExcelColumnNum(int columnNum, StringBuffer sbBuffer) {
if (columnNum / 26 > 0) {
//列从0开始计算
getExcelColumnNum(columnNum / 26 - 1, sbBuffer);
}
sbBuffer.append((char) (columnNum % 26 + 'A'));
}
}
解析Excel时列号数字转换为字母
最新推荐文章于 2023-01-26 16:12:51 发布