Examples of JRXlsxExporter

net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter
Exports a JasperReports document to XLSX format. It has character output type and exports the document to a grid-based layout. @author Teodor Danciu (teodord@users.sourceforge.net) @version $Id: JRDocxExporter.java 2943 2009-07-23 19:45:12Z teodord $

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


    JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");
    
    JRXlsxExporter exporter = new JRXlsxExporter();
    
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
    
    exporter.exportReport();


    System.err.println("XLSX creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


    JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");


    JRXlsxExporter exporter = new JRXlsxExporter();


    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);


    exporter.exportReport();


    System.err.println("XLSX creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


      JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


      File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");
    
      JRXlsxExporter exporter = new JRXlsxExporter();
    
      exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
      exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
      exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
    
      exporter.exportReport();


      System.err.println("Report : " + sourceFile + ". XLSX creation time : " + (System.currentTimeMillis() - start));
    }
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


    JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");
    
    JRXlsxExporter exporter = new JRXlsxExporter();
    
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
    
    exporter.exportReport();


    System.err.println("XLSX creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


    JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");
    
    JRXlsxExporter exporter = new JRXlsxExporter();
    
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
    
    exporter.exportReport();


    System.err.println("XLSX creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter


    JasperPrint jasperPrint = (JasperPrint)JRLoader.loadObject(sourceFile);


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xlsx");
    
    JRXlsxExporter exporter = new JRXlsxExporter();
    
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());
    exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
    exporter.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, Boolean.TRUE);
    
    exporter.exportReport();


    System.err.println("XLSX creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter

    return "xlsx";
  }


  public JRExporter setup() {
    configure(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
    return new JRXlsxExporter();  
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter

     public void XLSX(ActionEvent actionEvent) throws JRException, IOException{
        init();
       HttpServletResponse httpServletResponse=(HttpServletResponse)FacesContext.getCurrentInstance().getExternalContext().getResponse();
      httpServletResponse.addHeader("Content-disposition", "attachment; filename=report.xlsx");
       ServletOutputStream servletOutputStream=httpServletResponse.getOutputStream();
       JRXlsxExporter docxExporter=new JRXlsxExporter();
       docxExporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
       docxExporter.setParameter(JRExporterParameter.OUTPUT_STREAM, servletOutputStream);
       docxExporter.exportReport();
   }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter

    return "xlsx";
  }


  @SuppressWarnings("rawtypes")
  public Exporter setup() {
    return new JRXlsxExporter();  
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter

    else if(reportType.equalsIgnoreCase("xlsx")){
    
      JasperPrint jasperPrint = JasperFillManager.fillReport (reportStream, parameters, ds);
      response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
      response.setHeader("Content-Disposition","attachment; filename=\""+ "Accounts.xlsx" + "\"");
      JRXlsxExporter exporterXls = new JRXlsxExporter();
      exporterXls.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); 
      exporterXls.setParameter(JRExporterParameter.OUTPUT_STREAM, outStream);
      exporterXls.exportReport();
    }
    else{
      
      JasperPrint jasperPrint = JasperFillManager.fillReport (reportStream, parameters, ds);
      response.setContentType("application/vnd.ms-excel");
      response.setHeader("Content-Disposition","attachment; filename=\""+ "Accounts.xls" + "\"");
      JRXlsExporter exporterXls = new JRXlsExporter ();
      exporterXls.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); 
      exporterXls.setParameter(JRExporterParameter.OUTPUT_STREAM, outStream);
      exporterXls.exportReport();
    }
    
    outStream.flush();
    outStream.close();
  }

View Full Code Here

0 1 2 3 4

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.