poi 不自动计算 设置单元格公式_Java POI：如何读取Excel单元格的值而不是计算公式？...

上面的建议对我来说不起作用cell.getRawValue()返回与AUT上的excel单元格相同的公式，所以写下面的函数，它工作：

public void readFormula() throws IOException {

FileInputStream fis = new FileInputStream("Path of your file");

Workbook wb = new XSSFWorkbook(fis);

Sheet sheet = wb.getSheetAt(0);

FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();

CellReference cellReference = new CellReference("C2"); //pass the cell which contains formula

Row row = sheet.getRow(cellReference.getRow());

Cell cell = row.getCell(cellReference.getCol());

CellValue cellValue = evaluator.evaluate(cell);

switch (cellValue.getCellType()) {

case Cell.CELL_TYPE_BOOLEAN:

System.out.println(cellValue.getBooleanValue());

break;

case Cell.CELL_TYPE_NUMERIC:

System.out.println(cellValue.getNumberValue());

break;

case Cell.CELL_TYPE_STRING:

System.out.println(cellValue.getStringValue());

break;

case Cell.CELL_TYPE_BLANK:

break;

case Cell.CELL_TYPE_ERROR:

break;

// CELL_TYPE_FORMULA will never happen

case Cell.CELL_TYPE_FORMULA:

break;

}

}