if(cell.getCellType() == HSSFCell.CELL_TYPE_NUMERIC){
double d = cell.getNumericCellValue();
if (d - (int) d < Double.MIN_VALUE) {
// 是否为int型
cellStr = Integer.toString((int) d);
} else{
DecimalFormat df = new DecimalFormat("0");
cellStr = df.format(cell.getNumericCellValue());
}
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
cellStr = cell.getRichStringCellValue().getString();
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
cellStr = cell.getCellFormula();
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
cellStr = " ";
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_ERROR) {
cellStr = " ";
}
double d = cell.getNumericCellValue();
if (d - (int) d < Double.MIN_VALUE) {
// 是否为int型
cellStr = Integer.toString((int) d);
} else{
DecimalFormat df = new DecimalFormat("0");
cellStr = df.format(cell.getNumericCellValue());
}
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_STRING) {
cellStr = cell.getRichStringCellValue().getString();
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
cellStr = cell.getCellFormula();
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_BLANK) {
cellStr = " ";
}else if (cell.getCellType() == HSSFCell.CELL_TYPE_ERROR) {
cellStr = " ";
}