Java code for generating Excel report with formula for cells

Question

How can I use this Excel formula

IF(W2<>"",NETWORKDAYS(V2,W2),"")   

in Java to generate an Excel report?

Answer 1

You can also Try JXL api.

http://jexcelapi.sourceforge.net/

Answer 2

Try Apache POI which reads/writes MS Office files. Check out the POI support for writing Excel formulas.