dynamically generating Excel file

sunitapandey · November 13th, 2006, 05:50 AM

Hi
I want to generate excel file dynamically containing all data which is displayed on jsp page from view objects.
how can i migrate data from jsp page to xl file.
pls help.
An Sample code would help better to understand it.
Thanks in advance.
sunita

dgmanu · November 23rd, 2006, 12:33 AM

hi, here is the sample code u may try it before that check u having the all api there needed for excel generation ,

Code:

ServletContext context = this.getServlet().getServletConfig().getServletContext();
JasperPrint jasperPrint = JasperFillManager.fillReport(context.getRealPath("/EmpDetails.jasper"),parameters,con);
ByteArrayOutputStream output = new ByteArrayOutputStream();
        OutputStream outputfile= new FileOutputStream(new File(context.getRealPath("/EmpDetails.xls"));
        JRXlsExporter exporterXLS = new JRXlsExporter();
        exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, jasperPrint);
        exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, output);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_DETECT_CELL_TYPE, Boolean.TRUE);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.TRUE);
        exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
        exporterXLS.exportReport();
        outputfile.write(output.toByteArray());

sparun1607 · November 23rd, 2006, 03:24 AM

What is the jar that has to be imported ... for this program

Arun

sparun1607 · November 23rd, 2006, 03:53 AM

and where that jar file has to be imported

Arun