urtley Posted October 20, 2009 Share Posted October 20, 2009 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 Link to comment Share on other sites More sharing options...
chriss-gyulev Posted October 26, 2009 Share Posted October 26, 2009 Hi try with "JExcelApiExporter"JExcelApiExporter xlsExporter = new JExcelApiExporter(); Regards,Chriss Link to comment Share on other sites More sharing options...
schiefertom Posted November 4, 2009 Share Posted November 4, 2009 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now