Use function in JXLS template

Question

My template has some function such as TODAY(), CHOOSE(),... but when I use Jxls to write contents, these function not working, its display 0.

How to make these functions works?

Answer 1

To have an Excel function evaluated you can try the following

• Put it into $[]
• Use POI API to indicate that formulas should be evaluated as explained in Formula Evaluation. In particular you can try using workbook.getCreationHelper().createFormulaEvaluator().evalua‌​teAll(); or try to force formula recalculation with workbook.setForceFormulaRecalculation(true);

Answer 2

Ah, I got it, put formulas inside $[]