You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by kalirajan <ka...@vernal.is> on 2014/08/01 23:49:33 UTC

FormulaEvaluator Issue

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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: FormulaEvaluator Issue

Posted by kalirajan <ka...@vernal.is>.
Thanks Nick to your quick reply.

Its works now after I replaced the jars what I mention top by blow.

poi-scratchpad-3.10-FINAL-20140208
poi-3.10-FINAL-20140208
poi-excelant-3.10-FINAL-20140208
poi-ooxml-3.10-FINAL-20140208
poi-ooxml-schemas-3.10-FINAL-20140208
xmlbeans-2.3.0
dom4j-1.6.1


Kalirajan






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

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: FormulaEvaluator Issue

Posted by Nick Burch <ap...@gagravarr.org>.
On Fri, 1 Aug 2014, kalirajan wrote:
> 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

A little old, but should be fine

> Exception in thread "main" java.lang.NoClassDefFoundError:
> org.apache.poi.hssf.record.formula.eval.ValueEval

I think you're not using the jars you think you are. Ensure you really are 
using those ones listed above (or newer ones!), and zap any old ones from 
the classpath

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org