How to generate XLS(Excel) file in java using jrxml?

The following is the code for report generation of Excel(XLS) report using JAVA JRXML.Its generating a blank file.I am calling the method by this:

 

 

 

[code]

public String xls(String filename, String dest_filename, String jasper_file){ 

try{ 

//File sourceFile = new File(filename); 

//HashMap hm = new HashMap();

 

 

       // JasperPrint print = JasperFillManager.fillReport(filename, hm, new JREmptyDataSource());  

1

JasperCompileManager.compileReportToFile(filename, jasper_file);

File sourceFile = new File(jasper_file);  

JasperReport jasperReport = (JasperReport) JRLoader.loadObject(sourceFile);  

JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, new HashMap<String, Object>());  

 

File destFile = new File(dest_filename); 

 

JRXlsExporter exporter = new JRXlsExporter(); 

 

exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);

exporter.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);

exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);

exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);

exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString()); 

exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); 

exporter.exportReport(); 

 

} 

catch(Throwable t){return "error: " + t.getMessage();} 

return "XLS Report generated Successfully!"; 

} 

[/code]