HI,

I am using the following jars in my workspace

dom4j-1.6.1.jar
jxl-2.6.12.jar
jxls-core-1.0.3.jar
poi-3.9.jar
poi-ooxml-3.7.jar
poi-ooxml-schemas-3.7.jar
xmlbeans-2.3.0.jar

I got exception while evaluate template file formulas

Please help me.

My Code:
FileInputStream inputStream = new FileInputStream("Z:/Poi/xltemplate.xlsx");
XSSFWorkbook workbook = new XSSFWorkbook (inputStream);
FormulaEvaluator evaluator =
workbook.getCreationHelper().createFormulaEvaluator();

Exception:

Exception in thread "main" java.lang.NoClassDefFoundError:
org.apache.poi.hssf.record.formula.eval.ValueEval
        at java.lang.J9VMInternals.verifyImpl(Native Method)
        at java.lang.J9VMInternals.verify(J9VMInternals.java:72)
        at java.lang.J9VMInternals.initialize(J9VMInternals.java:134)
        at
org.apache.poi.xssf.usermodel.XSSFCreationHelper.createFormulaEvaluator(XSSFCreationHelper.java:51)
        at com.mlb.mobiledirectory.action.ExcelReport.main(ExcelReport.java:24)
Caused by: java.lang.ClassNotFoundException:
org.apache.poi.hssf.record.formula.eval.ValueEval
        at java.net.URLClassLoader.findClass(URLClassLoader.java:421)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:652)
        at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:346)
        at java.lang.ClassLoader.loadClass(ClassLoader.java:618)
        ... 5 more




--
View this message in context: 
http://apache-poi.1045710.n5.nabble.com/FormulaEvaluator-Issue-tp5716201.html
Sent from the POI - User mailing list archive at Nabble.com.

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to