解析Excel时列号数字转换为字母

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