java中excel导入各种类型取值

/**
* 取excel单元格的日期(如果是日期格式，用Date得到；如果是文本类型，根据导出格式转成date)
*/
private Date getCellDate(Row row,int i){
Date date = new Date();
String strDate = "";
try{
date = row.getCell(i).getDateCellValue();
}catch(Exception e){
strDate = getCellValue(i,row);
}
if(!"".equals(strDate)){
date = DateUtils.String2Date(StringUtils.replaceNull2Space(strDate), "yyyy-MM-dd HH:mm:ss");
}
return date;
}
/**
* 去通用代码，通过name取code
*/
private String getCodeByName(String type , String name){
String sql = "select t.Lookup_Code from sys_lookup_vl t where t.Lookup_Type = '"
+ type +"' and t.Lookup_Name = '" +name+ "'";
List<Object[]> list = this.getHibernateDAO().findBySql(sql);
if(null != list && list.size() > 0){
return ComUtil.replaceObjectToStr(list.get(0)[0]);
}else{
return "";
}
}
// 取单元格值的通用方法
private String getCellValue(int i, Row row) {
String name = "";
if(row.getCell(i) == null){
return name;
}
if (row.getCell(i).getCellType() == HSSFCell.CELL_TYPE_NUMERIC) {
name = row.getCell(i).getNumericCellValue() + "";
if(name.endsWith(".0")){
name = name.substring(0, name.length()-2).trim();
}
} else if (row.getCell(i).getCellType() == HSSFCell.CELL_TYPE_STRING) {
name = row.getCell(i).getStringCellValue().trim();
}
return name;
}