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?

krock · Accepted Answer · 2010-07-09 03:46:37Z

2

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

answered Jul 9, 2010 at 3:46

krock

29.7k13 gold badges81 silver badges86 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

IF i use setformula() for the IF(W2<>"",NETWORKDAYS(V2,W2),"") it get realigned to wrong order.. please suggest the right to generate excel..

Mike · Accepted Answer · 2011-10-20 11:57:43Z

0

You can also Try JXL api.

http://jexcelapi.sourceforge.net/

answered Oct 20, 2011 at 11:57

Mike

1,9095 gold badges26 silver badges32 bronze badges