Java code for generating Excel report with formula for cells

How can I use this Excel formula

IF(W2<>"",NETWORKDAYS(V2,W2)开发者_如何学JAVA,"")   

in Java to generate an Excel report?

---

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

---

You can also Try JXL api.

http://jexcelapi.sourceforge.net/