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.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

  • 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...