How to export to excel and csv format in jasper report

jasper-reports

i need to export to excel and csv format in jasper reports.
for excel i tried by creating custom class (using api)but it is not exporting, the thing is save and cancel popup window is coming with file type unkown..

any idea why it is happening?

Best Answer

Use as a JRXlsExporter to export to XSL and a JRCsvExporter for CSV.

There should be no need to create a custom class in most cases.

Edit

The class is stored inside the jar poi-3.5-FINAL-20090928.jar, which should be locate in your "iReportInstallationFolder"\modules\ext\

For me it's C:\Program Files\Jaspersoft\iReport-3.7.4\ireport\modules\ext\

The name could be different but should be poi-3.5-FINAL-*.jar.

Make it is included in your classpath and you should be fine.

You can download the jar from Apache Poi home page.

Here is a link to the jar I have from their site http://archive.apache.org/dist/poi/release/bin/poi-bin-3.5-FINAL-20090928.tar.gz

Related Solutions

Java – Jasper report exports empty data in PDF format when there is more data

When there is no date source you can try this code

       jasperReport = JasperCompileManager.compileReport(sourceFileName);
       jasperPrint = JasperFillManager.fillReport(jasperReport,jasperParameter,new JREmptyDataSource()); 
       JasperExportManager.exportReportToPdfFile(jasperPrint, "D://.pdf")

Even if you do not have any data source and its a static data report giving JREmptyDataSource is important, otherwise you may get a blank report.

Check this link for more info https://stackoverflow.com/a/5334415/649451

-- Cheers!

How to export to excel in JasperReports

Try setting the following headers:

Content-Type: application/vnd.ms-excel
Content-Disposition: attachment; filename=report.xls

Best Answer

Related Solutions

Java – Jasper report exports empty data in PDF format when there is more data

How to export to excel in JasperReports

Related Topic