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

[janak]

 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

[szaharia]

Hi,

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

HTH,

sanda

[burferd]

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

[saulhidalgo]

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!

[mousspring]

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

[manisanlucyan]

It's great. It works and thank you very much for sharing. 

stickman boost