Excel POI解析

Excel有xlsx格式和xls格式两种，以下就是本人在开发中使用POI解析方法，有很多不足，还请指出，谢谢！

// 2007版本的Excel

private List<PrpSagreeDetailHis> trancasitionsAgreenmentExcel2007(File excelFile)
throws Exception{
int index = 0;
//List<PrpSagreeDetail> prpSagreeDetailList
String queryRiskName = null;
String usenaturecode = null;
String carTypeCode = null;
DecimalFormat df = new DecimalFormat("#.00");
List<PrpSagreeDetailHis> prpSagreeDetailHisList = new ArrayList<PrpSagreeDetailHis>();
XSSFWorkbook xwk = new XSSFWorkbook(new FileInputStream(excelFile));
Sheet sheet = xwk.getSheetAt(0);
Iterator<Row> rows = sheet.rowIterator();
while (rows.hasNext()) {
PrpSagreeDetailHis prpSagreeDetailHis = new PrpSagreeDetailHis();
Row row = rows.next();
if (row.getRowNum() > 0) {
index++;
//设置单元格格式
if(row.getCell(0) !=null && !"".equals(row.getCell(0))){
row.getCell(0).setCellType(HSSFCell.CELL_TYPE_STRING);
}
if(row.getCell(1) !=null && !"".equals(row.getCell(1))){
row.getCell(1).setCellType(HSSFCell.CELL_TYPE_NUMERIC);
}
if(row.getCell(2) !=null && !"".equals(row.getCell(2))){
row.getCell(2).setCellType(HSSFCell.CELL_TYPE_NUMERIC);
}
//设置单元格格式
if(row.getCell(3) !=null && !"".equals(row.getCell(3))){
row.getCell(3).setCellType(HSSFCell.CELL_TYPE_NUMERIC);
}
if(row.getCell(4) !=null && !"".equals(row.getCell(4))){
row.getCell(4).setCellType(HSSFCell.CELL_TYPE_NUMERIC);
}
if(row.getCell(5) !=null && !"".equals(row.getCell(5))){
row.getCell(5).setCellType(HSSFCell.CELL_TYPE_STRING);
}
if(row.getCell(6) !=null && !"".equals(row.getCell(6))){
row.getCell(6).setCellType(HSSFCell.CELL_TYPE_STRING);
}


//判断险种是否符合要求
if (row.getCell(0)==null || "".equals(row.getCell(0))) {
//使用性质代码不能为空
prpSagreeDetailHis.setRiskCode("") ;
}else if (row.getCell(0)!=null && !("".equals(row.getCell(0)))) {
//险种代码不能为空
String queryRiskCode = row.getCell(0).getStringCellValue();
//根据RiskCode查询RiskName