How to export data to excel/pdf?

[dbermudez]

Hello, I am using the dataExporter control, just like in the showcase demo, but when I try to export data into Excel, I get the following errors:

an exception of classNotFound exception org.apache.poi.hssf.usermodel.HSSFWorkbook for excel. The demo does not say anything about having to install packages or JAR files. Do I need to include packages, JAR files or do something in particular for the dataExporter to work properly?

[cagatay.civici]

You need poi, see user's guide.

[dbermudez]

Ok I downloaded the POI library version 3.7 files and there are several JAR files.

poi-3.7-20101029
poi-ooxml-3.7-20101029
poi-scratchpad-3.7-20101029

in the root of the downloaded folder. But there are more JAR files within a lib folder. Do I need to include all of the JAR files or which ones do I need?

[cagatay.civici]

Page 12, user's guide.

[dbermudez]

Got the correct versions this time. Thank you for the heads-up. I am getting OutOfMemory Exceptions from weblogic server now but I don't think it's from adding these libraries.

[dbermudez]

Ok managed to restart weblogic server and the exporting now works. Thanks again.

[bercolax]

Just for the benefit for Maven users the dependencies are provided below (which work with PrimeFaces v 3.0 M4 SNAPSHOT).

itext is needed only if you need PDF export

Code: Select all

         <dependency>
            <groupId>org.apache.poi</groupId>
            <artifactId>poi</artifactId>
            <version>3.7</version>
        </dependency>
         <dependency>
            <groupId>com.lowagie</groupId>
            <artifactId>itext</artifactId>
            <version>2.1.7</version>
          </dependency>

[cagatay.civici]

For 2.x users, poi version is 3.2.

[Marie123]

Hi!
I understand that maybe my answer to you may not help with this question, but in the future it will be useful https://www.altopdf.com/ for working with files online