poi读取的excel公式列换成数值
1.先获取FormulaEvaluator类
InputStream input=file.getInputStream();
HSSFWorkbook workbook = new HSSFWorkbook(input);
HSSFSheet sheet = workbook.getSheet("文件名");
FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator();
2.判断cellType类型为CELL_TYPE_FORMULA时
CellValue cellValue = evaluator.evaluate(cell);
cellval=cellValue.getNumberValue();
还没有评论,来说两句吧...