About Jasperreport 3.5.3 and xls

[sweet_yangyz]

Hi:

       I used the jasperreport 3.5.3 in our project, and export pdf ,html, and xml all right, but when I export the report as a xls file,the exception will be threw like this:

java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.setColumnWidth(II)V
 at net.sf.jasperreports.engine.export.JRXlsExporter.setColumnWidth(JRXlsExporter.java:212)
 at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.setColumnWidths(JRXlsAbstractExporter.java:654)
 at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportPage(JRXlsAbstractExporter.java:527)
 at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReportToStream(JRXlsAbstractExporter.java:463)
 at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport(JRXlsAbstractExporter.java:186)
 at net.sweet.test.report.DataSourceFactory.test_generateReport(DataSourceFactory.java:88)
 ......

I want to kown that which version of POI will be referenced in jasperreport?

I referenced the POI 3.0.2_FINAL in our project, can you help me ?

 

Thx,

Sweet.

 

Code:

JRXlsExporter exporter = new JRXlsExporter();			exporter					.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);			FileOutputStream oStream = new FileOutputStream(					"D:\\report\\log4j.xls");			exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, oStream);			exporter.setParameter(					JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,					Boolean.TRUE);			exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET,					Boolean.FALSE);			exporter.setParameter(					JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,					Boolean.FALSE);			exporter.exportReport();

[denys]

 for version 3.5.2 pom.xml states:

<dependency>

<groupId>org.apache.poi</groupId>

<artifactId>poi</artifactId>

<version>3.2-FINAL</version>

<scope>compile</scope>

<optional>true</optional>

</dependency>

 

I would assume that 3.5.3 uses the same version of POI lib.

 

Code:

		<dependency>			<groupId>org.apache.poi</groupId>			<artifactId>poi</artifactId>			<version>3.2-FINAL</version>			<scope>compile</scope>			<optional>true</optional>		</dependency>

[Teodor Danciu]

Hi,

 

You can get the required POI library from the /lib directory of the JasperReports distribution package.

 

I hope this helps.

Teodor

 

[sweet_yangyz]

Thanks ,I try to replace the POI lib  with 3.2 version instead of the one with 3.0.2, now it work well.

Thanks again.     :)

 

Sweet

[Suite]

Thanks ,

I replaced the  the POI lib  with 3.2 and now it is OK.

Thanks to all