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();