转载自:http://blog.csdn.net/u010571844/article/details/46806265
转载内容(有修改):
public class ExcelColumn {
public static void main(String[] args) {
String colstr = "B";
int colIndex = excelColStrToNum(colstr);
System.out.println(colstr+"列转换成数字下标:"+colIndex);
colIndex = 26;
colstr = excelColIndexToStr(colIndex);
System.out.println("下标为"+colIndex+"转换成列:"+colstr);
colstr = "AAAA";
colIndex = excelColStrToNum(colstr);
System.out.println(colstr+"列转换成数字下标:"+colIndex);
colIndex = 466948;
colstr = excelColIndexToStr(