如何在jasper报告中导出为excel和csv格式(how to export to excel and csv format in jasper report)

我需要在jasper报告中导出为ex​​cel和csv格式。 对于excel我尝试通过创建自定义类（使用api），但它不是导出，事情是保存和取消弹出窗口来的文件类型未知..

知道为什么会这样吗？

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?

最满意答案

用作JRXlsExporter导出到XSL和JRCsvExporter用于CSV。

在大多数情况下，不需要创建自定义类。

编辑

该类存储在jar poi-3.5-FINAL-20090928.jar中，该jar应位于“iReportInstallationFolder”\ modules \ ext \

对我来说，它是C:\Program Files\Jaspersoft\iReport-3.7.4\ireport\modules\ext\

名称可能不同，但应该是poi-3.5-FINAL - * .jar。

让它包含在你的类路径中，你应该没问题。

您可以从Apache Poi主页下载jar。

这是我的网站链接到http://archive.apache.org/dist/poi/release/bin/poi-bin-3.5-FINAL-20090928.tar.gz

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

如何在jasper报告中导出为excel和csv格式(how to export to excel and csv format in jasper report)

我需要在jasper报告中导出为ex​​cel和csv格式。 对于excel我尝试通过创建自定义类（使用api），但它不是导出，事情是保存和取消弹出窗口来的文件类型未知..

知道为什么会这样吗？

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?

最满意答案

用作JRXlsExporter导出到XSL和JRCsvExporter用于CSV。

在大多数情况下，不需要创建自定义类。

编辑

该类存储在jar poi-3.5-FINAL-20090928.jar中，该jar应位于“iReportInstallationFolder”\ modules \ ext \

对我来说，它是C:\Program Files\Jaspersoft\iReport-3.7.4\ireport\modules\ext\

名称可能不同，但应该是poi-3.5-FINAL - * .jar。

让它包含在你的类路径中，你应该没问题。

您可以从Apache Poi主页下载jar。

这是我的网站链接到http://archive.apache.org/dist/poi/release/bin/poi-bin-3.5-FINAL-20090928.tar.gz

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