I use following codes to read the formula in attached Excel: formula.xlsx. I found that except the first row, "c.getCellFormula()" return an empty string. In fact, other rows do contain formula.

--

XSSFWorkbook wb = new XSSFWorkbook("formula.xlsx");

FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
for(int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
	Sheet sheet = wb.getSheetAt(sheetNum);
	for(Row r : sheet) {
		for(Cell c : r) {
			if(c.getCellType() == Cell.CELL_TYPE_FORMULA) {           			
				System.out.println("c.getCellFormula():" + c.getCellFormula());
			}
		}
	}
}

--

Please help. Thanks a lot!