Export XLS Report to String

[ketro]

    How can I export my Xls report to a (binary) string instead of file?

JExcelApiExporter XlsExporter = new JExcelApiExporter();
XlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, printedReport);
XlsExporter.setParameter(JRXlsAbstractExporterParameter.IS_DETECT_CELL_TYPE, new Boolean("true"));
XlsExporter.exportReport();
String Xls="";

    Just like I do with PDF's:

JasperExportManager.exportReportToPdf(printedReport)

 

 

---

Thank you!

[lucianc]

Quoting the JasperExportManager.exportReportToPdf(JasperPrint jasperPrint) method, see below (btw, JasperReports is open source).

You can do the same thing with JExcelApiExporter.

HTH,

Lucian

Code:

ByteArrayOutputStream baos = new ByteArrayOutputStream();JRPdfExporter exporter = new JRPdfExporter();		exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);exporter.setParameter(JRExporterParameter.OUTPUT_STREAM, baos);		exporter.exportReport();		return baos.toByteArray();