public static String getCellValue(Cell cell) { if (cell == null) { return ""; } if (cell.getCellType() == CellType.STRING) { return cell.getStringCellValue(); } else if (cell.getCellType() == CellType.BOOLEAN) { return String.valueOf(cell.getBooleanCellValue()); } else if (cell.getCellType() == CellType.FORMULA) { try { return cell.getCellFormula(); } catch (Exception e) { return String.valueOf(cell.getNumericCellValue()); } } else if (cell.getCellType() == CellType.NUMERIC) { return String.valueOf(cell.getNumericCellValue()); } else if (cell.getCellType() == CellType.ERROR) { return String.valueOf(cell.getErrorCellValue()); } return ""; }
Poi 根据excel文本框value类型取值
最新推荐文章于 2024-05-07 14:38:43 发布