csv

try {
Charset charset = Charset.forName("MS950"); reader = new CsvReader(is, ',', charset);
} catch (Exception ex) { log.error(StringUtil.getStackTraceAsString(ex)); }

try { while (reader.readRecord()) {
try { transCount++;

if (transCount == 1) {

continue;

}

/** 建立model */

TsRaceBulletinHMDTO transModel = new TsRaceBulletinHMDTO();

transModel.setTeam( reader.get(getExcelColumnIndex("A")) );//組別

transModel.setSortno( Long.valueOf( reader.get( getExcelColumnIndex("B") ) ) );//排名

transModel.initInsert("Y", userAccount);

tsRaceBulletinHMDAO.insertAll(transModel);
successCount++;
log.info("trans:" + successCount);
} catch (Exception ex) {

errorCount++; log.error("row " + transCount + " error... \n" + StringUtil.stackTrace(ex));

result += "row " + transCount + " error... \n"; }

}

} catch (Exception e) {

log.error(StringUtil.stackTrace(e));

} finally {
reader.close();
}

private static int getExcelColumnIndex(String columnName) { String allName[] = { "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" };
int index = 0;
for (int i = 0; i < index =" i;">