LetterExcelUtil.java 1.35 KB
Newer Older
Memorydoc's avatar
#  
Memorydoc committed
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48
package pwc.taxtech.atms.common.util;

import java.util.ArrayList;
import java.util.List;

/**
 * author kevin
 * version 1.0
 */
public class LetterExcelUtil {

    public static int excelToNum(String col) { //  "AAA"
        if (col == null)
            return -1;
        char[] chrs = col.toUpperCase().toCharArray(); // 转为大写字母组成的 char数组
        int length = chrs.length;
        int ret = -1;
        for (int i = 0; i < length; i++) {
            ret += (chrs[i] - 'A' + 1) * Math.pow(26, length - i - 1); // 当做26进制来算 AAA=111 26^2+26^1+26^0
        }
        return ret;// 702; 从0开始的下标
    }

    /**
     * 数字下标转列
     *
     * @param index
     * @return
     */
    public static String NumToExcel(int index) {
        int shang = 0;
        int yu = 0;
        List<Integer> list = new ArrayList<Integer>();   //10进制转26进制 倒序
        while (true) {
            shang = index / 26;
            yu = index % 26;
            index = shang;
            list.add(yu);
            if (shang == 0)
                break;
        }
        StringBuilder sb = new StringBuilder();
        for (int j = list.size() - 1; j >= 0; j--) {
            sb.append((char) (list.get(j) + 'A' - (j > 1 ? 1 : j)));     //倒序拼接  序号转字符 非末位 序号减去 1
        }
        return sb.toString();
    }
}