nested exception is java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel /HSSFCellStyle

I am getting following exception while exporting jasper report in xls format.

org.springframework.web.util.NestedServletException: Handler processing failed; nested exception is java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFCellStyle
org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:899)
org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:793)
org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:476)
org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:431)
javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
org.acegisecurity.util.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:265)
December 8, 2008 | Filed Under Jasper 

Related Post

nested exception is java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel /HSSFCellStyle
nested exception is java.lang.NoClassDefFoundError: net/sf/ezmorph/Morpher
java.lang.NoClassDefFoundError: org/apache/commons/codec/DecoderException
nested exception is java.lang.IllegalStateException: Cannot create command without commandClass
javax.mail.MessagingException: 530 5.7.0 Must issue a STARTTLS

Comments

4 Responses to “nested exception is java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel /HSSFCellStyle”

  1. Shreenivasa on December 8th, 2008 9:46 pm

    If you are exporting report in xls then you need to include poi.jar in the classpath. Poi.jar is Java API To Access Microsoft Format Files. Below is the download link
    http://www.apache.org/dyn/closer.cgi/poi/dev/

    Let me know if you still face the problem?

  2. Federico on August 12th, 2009 11:21 pm

    Hi there!

    I am having this problem too.
    I already have poi included in my project but I still get a runtime exception on line:

    JRXlsExporter exporter = new JRXlsExporter();

    Resulting in:
    java.lang.NoClassDefFoundError: org/apache/poi/hssf/usermodel/HSSFCellStyle

    Does anybody know what can be done to fix this issue?

    Thanks and good luck!

    Federico

  3. Amit on August 26th, 2009 10:12 pm

    It seems the classpath problem only. Recheck the classpath.

  4. prasad on April 7th, 2011 12:34 pm

    i added poi-3.7-20101029 jar and commons-digester-1.8
    when run the app im getting this error
    any one help me?

    java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFRichTextString.applyFont(IILorg/apache/poi/hssf/usermodel/HSSFFont;)V
    at net.sf.jasperreports.engine.export.JRXlsExporter.getRichTextString(JRXlsExporter.java:601)
    at net.sf.jasperreports.engine.export.JRXlsExporter.setRichTextStringCellValue(JRXlsExporter.java:582)
    at net.sf.jasperreports.engine.export.JRXlsExporter.createTextCell(JRXlsExporter.java:551)
    at net.sf.jasperreports.engine.export.JRXlsExporter.exportText(JRXlsExporter.java:410)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:590)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:463)
    at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:186)
    at com.jbent.peoplecentral.model.manager.DynamicJasperManagerImpl.export(DynamicJasperManagerImpl.java:222)
    at com.jbent.peoplecentral.controller.DynamicJasperReportController.export(DynamicJasperReportController.java:96)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    at java.lang.reflect.Method.invoke(Unknown Source)

Leave a Reply