Creting Excel stream via web

[2002 JI Open Discussion]

By: Servizi - jlda

Creting Excel stream via web

2003-01-24 00:22

I launch Jasperreports from my web application.

When I generate a report in HTML, PDF, CSV file format everything works well, but, using the

JRXlsExporter I receive an empty byte stream.

 

Can anybody help me?

 

 

 

 

By: Matt Hall - matt2k

RE: Creting Excel stream via web

2003-01-30 16:58

 

Hey,

 

Just figured this out myself, it looks something like this (I am assuming you already have your JasperPrint object ready to go):

 

JRXlsExporter exporter = new JRXlsExporter();

 

ByteArrayOutputStream xlsReport = new ByteArrayOutputStream();

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, xlsReport);

 

exporter.exportReport();

reportBytes = xlsReport.toByteArray();

 

Then stream those reportBytes back to the client.

 

Hope that helps.

 

Matt