Exporting from iReport to Excel

[urtley]

Hello,

I'm having an issue exporting from an iReport to an Excel format.  I have seen other threads regarding this topic, but I did not find the offered solutions very helpful. 

I'm using JRXlsExporter as seen here:

            JRXlsExporter exporterXLS = new JRXlsExporter();

            exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);

            exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);

            exporterXLS.exportReport();

 

But this error occurs during exportReport():

 

java.lang.NoSuchMethodError: org.apache.poi.hssf.usermodel.HSSFSheet.setColumnWidth(II)V

 

I have tried updating my jasperreports jar (which has been the general wisdom to fix this) to both poi-3.1-FINAL.jar and poi-3.5-beta1.jar, but neither have corrected the problem.  setColumnWidth is depreciated, but where might I turn to find a jar or resource that has addressed this issue?

 

I'd appreciate any comments or help.

 

Curt  

 

 

 

[chriss-gyulev]

Hi try with "JExcelApiExporter"

JExcelApiExporter xlsExporter = new JExcelApiExporter();

 

Regards,

Chriss

[schiefertom]

I had the same problem. Upgraded the Apache POI library to the newest Version 3.5 and encountered the "noSuchMethod" exception.

 

You can solve it by using the same POI version, which is included in jaspers lib directory.

 

You can find it here http://sourceforge.net/projects/jasperreports/files/1.jasperreports/ in the source file zip.