Hi As far i can see in the java code Talend is using the org.apache.POI library to recalculate formula,
and use this to recalculate all the formula :
private void evaluateFormulaCell() {
FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
for (int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++) {
sheet = wb.getSheetAt(sheetNum);
for (Row r : sheet) {
for (Cell c : r) {
if (c.getCellTypeEnum() == CellType.FORMULA) {
evaluator.evaluateFormulaCellEnum(c);
}
}
}
}
}
wb is a workbook object that contain the workbook
and here is the recalculate formula in POI documentation :
FileInputStream fis = new FileInputStream("/somepath/test.xls");Workbook wb = new HSSFWorkbook(fis); //or new XSSFWorkbook("/somepath/test.xls")FormulaEvaluator evaluator = wb.getCreationHelper().createFormulaEvaluator();
for (Sheet sheet : wb) {
for (Row r : sheet) {
for (Cell c : r) {
if (c.getCellType() == Cell.CELL_TYPE_FORMULA) {
evaluator.evaluateFormulaCell(c);
}
}
}
}
as you can see it's very similar
The org.APACHE.POI library seems to be the most used in java project and one of the best.
https://poi.apache.org/components/spreadsheet/eval.html
