java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFWorkbook.getCreationHelper()Lorg/apac

0

 this proble is arises after changing the jasper2.x.jar to jasperreports-4.0.0.jar .

still i am not understand why this error is arises.

is this error due to version difference in irreport tools and poi.jar files??

 

java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFWorkbook.getCreationHelper()Lorg/apache/poi/ss/usermodel/CreationHelper;
        at net.sf.jasperreports.engine.export.JRXlsExporter.openWorkbook(JRXlsExporter.java:200)
        at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:530)
        at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:299)
        at WIL.JasperReports.Accounts.ClientBilling.JobsToBillAll.JobsToBillAllReport.doPost(JobsToBillAllReport.java:137)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
        at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:470)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:857)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
        at java.lang.Thread.run(Thread.java:619)
 



Post Edited by janak at 02/18/2011 18:50
janak's picture
9
Joined: Dec 12 2007 - 6:40pm
Last seen: 5 years 11 months ago

4 Answers:

0

Hi,

Apparently a newer apache-poi version is needed. JR 4.0 works properly with POI 3.6.

HTH,

sanda

shertage's picture
1932
Joined: Sep 26 2006 - 8:06pm
Last seen: 15 hours 31 min ago
0

I'm seeing this error when attempting to create an excel report using JR 4.0.2 and POI 3.6.

burferd's picture
97
Joined: Mar 22 2007 - 1:37am
Last seen: 12 years 4 months ago
0

It works properly with poi3.6.

I had the same problem and I solved it removing ALL the previous version of poi in your project. So... ensure you have only poi 3.6.

I hope this helps.

See you!

saulhidalgo's picture
Joined: Aug 28 2011 - 9:26pm
Last seen: 7 years 10 months ago
0

Excellent my friend. I did it and it worked. Thanks.

mousspring's picture
Joined: Oct 27 2011 - 10:21am
Last seen: 7 years 8 months ago
Feedback