Jump to content
Changes to the Jaspersoft community edition download ×

Out Of Memory Exporting to Excel

2004 IR Help

Recommended Posts

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.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");


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,




Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...