How to export report to xls format using APIs?

[chengfan]

Hi,

 

Urgently need help on export reports to various format using APIs.

 

The APIs in JasperExportManager include methods to export to HTML, PDF and XML. How can we export the report to other formats, e.g., text or xls?

 

Thanks in advance.

 

cF

[wegnerk]

there exists also exporter for xls and rtf and so on. for xls an example:

 

Code:

JExcelApiExporter xlsExporter = new JExcelApiExporter();
xlsExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
xlsExporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.FALSE);
xlsExporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE);
xlsExporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME,"report.xls");
xlsExporter.exportReport();

 

thats only a fragment, just try it out, there are some parameter, which can be set like this.

 

Post edited by: wegnerk, at: 2006/12/05 14:56

Post edited by: wegnerk, at: 2006/12/05 14:56