i couldn't upload the code file, so here is it:


File file = new File(path to file);
InputStream is = new FileInputStream(file);
HSSFWorkbook wb = new HSSFWorkbook(is);
HSSFFormulaEvaluator formulaEvaluator = new HSSFFormulaEvaluator(wb);

int countSheets = wb.getNumberOfSheets();
for (int i = 0; i < countSheets - 1; i++) {
	HSSFSheet sheet = wb.getSheetAt(i);
	String name = sheet.getSheetName().split("\\-")[1];
	if (name.equals("MEETNET") {
		int countRows = sheet.getPhysicalNumberOfRows();
		for (int i = 1; i < countRows; i++) {
			Integer internId = null;
			Integer internBereikId = null;
			for (int j = 0; j <countCells; j++) {
				HSSFCell cell = row.getCell(j);
				
				if (j == 1) {
					if (cell.getCellType() == HSSFCell.CELL_TYPE_FORMULA) {
						internBereikId = formulaEvaluator.evaluateFormulaCell(cell);
					}
				}
			}
		}
	}
}

I've got the same problem :

<poi:cell NumberFormat="0" type="formula" value="COUNTA(A8:A#CurrentDataLine-2#)" index="#5+I#" />

It shows =COUNTA(A8:A354) in the cell, but the result is 1.
After giving an Enter in de formulabar the 1 turns into 347...

You are using a wrong method to retrieve results.

FormulaEvaluator#evaluateFormulaCell evaluates the formula and returns the type of the formula result, not the result itself. In your case it returned 0 which corresponds to Cell.CELL_TYPE_NUMERIC, that is the result of formula was number.

Use FormulaEvaluator#evaluate to get the result. The code below worked fine to me:

        HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(inputFile));
        HSSFFormulaEvaluator formulaEvaluator = new HSSFFormulaEvaluator(wb);
        HSSFSheet sheet = wb.getSheet("20-MEETNET");

        for (int i = 1; i <= sheet.getLastRowNum(); i++) {
            HSSFRow row = sheet.getRow(i);
            HSSFCell cell = row.getCell(1);
            CellValue val = formulaEvaluator.evaluate(cell);
            int internBereikId = (int)val.getNumberValue();
            System.out.println(i + ": " + internBereikId);
        }

Yegor