java.lang.NoClassDefFoundError: org/apache/poi/ss/usermodel/RichTextString at org.primefaces.component.export.ExporterFactory.getExporterForType

jsf primefaces datatable export-to-excel data-export
Deb picture Deb · Nov 8, 2012 · Viewed 19k times · Source

I used the same sample code Primefaces has in its web page:

<h:commandLink value="Excel">                     
  <p:dataExporter type="xls" target="dataTable" fileName="boo" pageOnly="true"/>  
</h:commandLink>

But does not work. In Internet Explorer browser gives the following message:

Details of the errors of the web page Message: Unexpected call to method or property access.

Nothing ever happens in Mozilla Firefox.

What might be happening?

Answer

BalusC picture BalusC · Nov 9, 2012 
javax.servlet.ServletException: org/apache/poi/ss/usermodel/RichTextString

Look further down in the stacktrace. I bet that the root cause is either a NoClassDefFoundError or ClassNotFoundException? In that case, this just means that you forgot to install Apache POI.

Download this Apache POI zip file, extract it, put poi-3.8-20120326.jar in /WEB-INF/lib folder and rebuild/redeploy/restart the webapp.

Related questions

How to set width of a p:column in a p:dataTable in PrimeFaces 3.0?

I'm using PrimeFaces 3.0-M3 and I have a <p:dataTable> with two columns in it. I want the first column to be fixed at a width of 20px. The other column can use whatever space is left over. …

Read More
Updating entire <p:dataTable> on complete of <p:ajax event="cellEdit">

I am having difficulty re-rendering a PrimeFaces Datatable once a cell has been edited. Changing the value in one cell may change entries in the other cells, hence the need to refresh the entire table. Here's the JSF page: <…

Read More
Set p:dataTable p:column width

I am trying to set the column widths of my data table. I have looked at this question for an answer How to set width of a p:column in a p:dataTable in PrimeFaces 3.0?. I am however trying to …

Read More