Out Of Memory Exporting to Excel

[2004 IR Help]

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