genrating the excel report
Hi i want to genrate the excel report to the browser, as it should prompt with dialouge box to download the file or to open.
Below is the snippet of code, which the result is showing in browser as text.
if (reportFormat.equals("EXCEL")) {
System.out.println(" EXCEL report to be genarted ");
jrExporter = new JRXlsExporter();
jrExporter.setParameter(JRXlsExporterParameter.IS_ ONE_PAGE_PER_SHEET, Boolean.TRUE);
response.setContentType("application/vnd.ms-excel");
response.setHeader("Content-disposition","attachment; filename=" + reportName + ".xls" );
response.setHeader("pragma", "no-cache");
response.setHeader("Pragma", "public" );
response.setHeader("Cache-Control","no-cache");
response.setHeader("Cache-Control","must-revalidate");
ServletOutputStream out = response.getOutputStream();
System.out.println(" servlet output stream initialized...");
jrExporter.setParameter(JRExporterParameter.JASPER _PRINT, jasperPrint);
System.out.println("jasperPrint has been set...");
jrExporter.setParameter(JRExporterParameter.OUTPUT _STREAM, out);
System.out.println("out put stream has been set...");
jrExporter.exportReport();
System.out.println("jrExporter exported report...");
out.flush();
out.close();
System.out.println("Completed...");
}
Kinldy let me know where it's going wrong
Thanks.
|