JAVA读取Excel文件,导入poi.jar包
<!-- excel -->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi</artifactId>
<version>3.6</version>
</dependency>
Java代码
/*
* 数字单元格样式转换,避免科学计数式写人数据库
*/
public String getHSSTextString(Row row, int colNum) {
Cell cell = row.getCell(colNum);
if (null != cell) {
switch (cell.getCellType()) {
case HSSFCell.CELL_TYPE_NUMERIC:
DecimalFormat df = new DecimalFormat("#");//转换成整型
return df.format(cell.getNumericCellValue());
//return String.valueOf(cell.getNumericCellValue());
case HSSFCell.CELL_TYPE_STRING:
return cell.getStringCellValue().trim();
case HSSFCell.CELL_TYPE_BLANK: // 空值
return "";
case HSSFCell.CELL_TYPE_ERROR: // 故障
return "";
default:
return "";
}
} else {
return "";
}
}