public static int colNameToIndex(String colName) {
		int length = colName.length();
		char c;
		int index = -1;
		for (int i = 0; i < length; i++) {
			c = Character.toUpperCase(colName.charAt(i));
			if (Character.isDigit(c)) {
				break;// 确定指定的char值是否为数字
			}
			index = (index + 1) * 26 + (int) c - 'A';
		}
		return index;
	}
@Test
	public void colNameToIndexTest() {
		assertEquals(704, ExcelUtil.colNameToIndex("AAC"));
		assertEquals(703, ExcelUtil.colNameToIndex("AAB"));
		assertEquals(702, ExcelUtil.colNameToIndex("AAA"));

		assertEquals(28, ExcelUtil.colNameToIndex("AC"));
		assertEquals(27, ExcelUtil.colNameToIndex("AB"));
		assertEquals(26, ExcelUtil.colNameToIndex("AA"));

		assertEquals(2, ExcelUtil.colNameToIndex("C"));
		assertEquals(1, ExcelUtil.colNameToIndex("B"));
		assertEquals(0, ExcelUtil.colNameToIndex("A"));
	}