janak Posted February 18, 2011 Share Posted February 18, 2011 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 Link to comment Share on other sites More sharing options...
szaharia Posted February 24, 2011 Share Posted February 24, 2011 Hi,Apparently a newer apache-poi version is needed. JR 4.0 works properly with POI 3.6.HTH,sanda Link to comment Share on other sites More sharing options...
burferd Posted June 24, 2011 Share Posted June 24, 2011 I'm seeing this error when attempting to create an excel report using JR 4.0.2 and POI 3.6. Link to comment Share on other sites More sharing options...
saulhidalgo Posted August 29, 2011 Share Posted August 29, 2011 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! Link to comment Share on other sites More sharing options...
mousspring Posted October 27, 2011 Share Posted October 27, 2011 Excellent my friend. I did it and it worked. Thanks. Link to comment Share on other sites More sharing options...
manisanlucyan Posted September 27, 2022 Share Posted September 27, 2022 It's great. It works and thank you very much for sharing. stickman boost Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now