excel如果导入是数字类型poi的cell.getStringCellValue()会报错,先将cell转化为文本类型,然后读取
Cell numCell = row.getCell(0); if(numCell != null){ numCell.setCellType(Cell.CELL_TYPE_STRING); } String cellValue = numCell.getStringCellValue();即可
excel如果导入是数字类型poi的cell.getStringCellValue()会报错,先将cell转化为文本类型,然后读取
Cell numCell = row.getCell(0); if(numCell != null){ numCell.setCellType(Cell.CELL_TYPE_STRING); } String cellValue = numCell.getStringCellValue();即可