2004 IR Help Posted August 24, 2006 Share Posted August 24, 2006 By: crodriguez - crodriguezr Out Of Memory Exporting to Excel 2005-07-18 14:22 Hi i am having problems exporting a large report (65000 rows) to excel, i dont have any problem exporting to pdf or html, i think that the problem is the exporter here my code: System.out.println("JR - compilling report"); reporte = JasperCompileManager.compileReport(file); System.out.println("JR - filling report"); salida = JasperFillManager.fillReport(reporte, reportParams, this.getActiveDataSource(request).getConnection()); System.out.println("JR - setting header"); response.setContentType("application/msexcel"); response.setHeader("Content-disposition", "attachment;filename=" + descripcion + ".xls"); System.out.println("JR - creating report"); exporter = new JRXlsExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, salida); exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, response.getOutputStream()); System.out.println("JR - exporting report"); exporter.exportReport(); System.out.println("JR - showing report"); By: David Leal Valmañ¡ achepati67 RE: Out Of Memory Exporting to Excel 2006-03-08 05:00 Dear member, I am looking for a solution for problem you have encountred, for long excel files with more than 65536 lines on a given column. How did you solve this problem? Thanks in advance, David achepati67@yahoo.es 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