excelcolumnmap.java

利用jxl和jdom到报表用的,可以自定义excel模板

package com.glf.reportIE.commons;

import java.util.regex.Pattern;



public class ExcelColumnMap {
	private static final String[] EXCEL_COLUMN = {
			"A","B","C","D","E","F","G","H","I","J","K","L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z",
			"AA","AB","AC","AD","AE","AF","AG","AH","AI","AJ","AK","AL","AM","AN","AO","AP","AQ","AR","AS","AT","AU","AV","AW","AX","AY","AZ",	
			"BA","BB","BC","BD","BE","BF","BG","BH","BI","BJ","BK","BL","BM","BN","BO","BP","BQ","BR","BS","BT","BU","BV","BW","BX","BY","BZ",	
			"CA","CB","CC","CD","CE","CF","CG","CH","CI","CJ","CK","CL","CM","CN","CO","CP","CQ","CR","CS","CT","CU","CV","CW","CX","CY","CZ",
			"DA","DB","DC","DD","DE","DF","DG","DH","DI","DJ","DK","DL","DM","DN","DO","DP","DQ","DR","DS","DT","DU","DV","DW","DX","DY","DZ",
			"EA","EB","EC","ED","EE","EF","EG","EH","EI","EJ","EK","EL","EM","EN","EO","EP","EQ","ER","ES","ET","EU","EV","EW","EX","EY","EZ",
			"FA","FB","FC","FD","FE","FF","FG","FH","FI","FJ","FK","FL","FM","FN","FO","FP","FQ","FR","FS","FT","FU","FV","FW","FX","FY","FZ",
			"GA","GB","GC","GD","GE","GF","GG","GH","GI","GJ","GK","GL","GM","GN","GO","GP","GQ","GR","GS","GT","GU","GV","GW","GX","GY","GZ",
			"HA","HB","HC","HD","HE","HF","HG","HH","HI","HJ","HK","HL","HM","HN","HO","HP","HQ","HR","HS","HT","HU","HV","HW","HX","HY","HZ",
			"IA","IB","IC","ID","IE","IF","IG","IH","II","IJ","IK","IL","IM","IN","IO","IP","IQ","IR","IS","IT","IU","IV"
			};
	
	/**
	 * 根据excel的单元格的字母得出相应的数字
	 * @param str
	 * @return
	 */
	public static String getColumnNumber(String str){
		
		//String tempStr = "";
		for(int i=0; i<EXCEL_COLUMN.length; i++){
			if(EXCEL_COLUMN[i].equals(str)){
				//tempStr = 
				return String.valueOf(i);
			}
		}
		return null;
	}
	
	/**
	 * 判读一个字符串是否为字母
	 */
	@SuppressWarnings("static-access")
	public static boolean isCharacter(String str){
		String regex="[A-Z]";
		Pattern patt=Pattern.compile(regex);
		return patt.matches(regex,str);
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO Auto-generated method stub
		//System.out.print(ExcelColumnMap.getColumnNumber("IV"));
		//System.out.print(ExcelColumnMap.isCharacter("0"));
	}

}