Examples of JRXlsExporter

net.sf.jasperreports.engine.export.JRXlsExporter
Exports a JasperReports document to XLS format. It has binary output type and exports the document to a grid-based layout. @author Teodor Danciu (teodord@users.sourceforge.net) @version $Id: JRXlsExporter.java 4261 2011-03-24 13:35:37Z teodord $

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


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


    JRXlsExporter exporter = new JRXlsExporter();


    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


      File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
      JRXlsExporter exporter = new JRXlsExporter();
    
      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 + ". XLS creation time : " + (System.currentTimeMillis() - start));
    }
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter

          fileExt = "xls";


          JasperReport report = JasperCompileManager.compileReport(reportsDirectoryPath + reportFileName + ".jrxml");
          JasperPrint print = JasperFillManager.fillReport(report, params, conn);


          JRXlsExporter exporter = new JRXlsExporter();


          exporter.setParameter(JRExporterParameter.JASPER_PRINT, print);
          exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, out);
          exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
          exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.TRUE);
          exporter.setParameter(JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.TRUE);
          exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
                    
          response.setHeader("Content-disposition", "inline; filename=\"" + outputFileName + "." + fileExt + "\"");
          response.setHeader("Cache-Control", "no-cache");
          response.setContentType(contentType);
          
          exporter.exportReport();          
          break;
      }


      out.flush();
      out.close();

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

Examples of net.sf.jasperreports.engine.export.JRXlsExporter


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


    File destFile = new File(sourceFile.getParent(), jasperPrint.getName() + ".xls");
    
    JRXlsExporter exporter = new JRXlsExporter();
    
    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("XLS creation time : " + (System.currentTimeMillis() - start));
  }

View Full Code Here

0 1 2 3 4 5

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.