Package net.sf.jasperreports.engine.export

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

27
28
29
30
31
32
33
    return "xls";
  }

  @SuppressWarnings("rawtypes")
  public Exporter setup() {
    return new JRXlsExporter(); 
  }
View Full Code Here
371
372
373
374
375
376
377
378
379
380
381
                // Needed to support chart images:
                exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
                request.getSession().setAttribute("net.sf.jasperreports.j2ee.jasper_print", jasperPrint);
            } else if (format.equals(FORMAT_XLS)) {
                response.setContentType("application/vnd.ms-excel");
                exporter = new JRXlsExporter();
            } else if (format.equals(FORMAT_XML)) {
                response.setContentType("text/xml");
                exporter = new JRXmlExporter();
            } else if (format.equals(FORMAT_RTF)) {
                response.setContentType("application/rtf");
View Full Code Here
29
30
31
32
33
34
35
  /**
   * @see org.wicketstuff.jasperreports.handlers.IJRResourceHandler#newExporter()
   */
  public JRAbstractExporter newExporter()
  {
    return new JRXlsExporter();
  }
View Full Code Here
32
33
34
35
36
37
38
  /**
   * @see org.wicketstuff.jasperreports.handlers.IJRResourceHandler#newExporter()
   */
  public JRAbstractExporter newExporter()
  {
    return new JRXlsExporter();
  }
View Full Code Here
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
          exporterRTF.setParameter(JRExporterParameter.JASPER_PRINT, print);
          exporterRTF.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
          exporterRTF.exportReport();
        case XLS:
          logger.debug(bundle.getString("exporting-report", "xls"));
          JRXlsExporter exporterXLS = new JRXlsExporter();
          exporterXLS.setParameter(JRExporterParameter.JASPER_PRINT, print);
          exporterXLS.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
          exporterXLS.exportReport();
          break;
        case ODS:
          logger.debug(bundle.getString("exporting-report", "ods"));
            JROdsExporter exporterODS = new JROdsExporter();
            exporterODS.setParameter(JRExporterParameter.JASPER_PRINT, print);
View Full Code Here
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
          exporterRTF.setParameter(JRExporterParameter.JASPER_PRINT, print);
          exporterRTF.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
          exporterRTF.exportReport();
        case XLS:
          logger.debug(bundle.getString("exporting-report", "xls"));
          JRXlsExporter exporterXLS = new JRXlsExporter();
          exporterXLS.setParameter(JRExporterParameter.JASPER_PRINT, print);
          exporterXLS.setParameter(JRExporterParameter.OUTPUT_STREAM, outputStream);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
          exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
          exporterXLS.exportReport();
          break;
        case ODS:
          logger.debug(bundle.getString("exporting-report", "ods"));
            JROdsExporter exporterODS = new JROdsExporter();
            exporterODS.setParameter(JRExporterParameter.JASPER_PRINT, print);
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
    exporter.setParameter(JRHtmlExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);
    exporter.exportReport();
  }

  private void exportXLS(String destinationFolder, String reportName, JasperPrint jasperPrint) throws JRException {
    JRXlsExporter exporter = new JRXlsExporter();
    exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint);
    exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, destinationFolder + File.separatorChar + reportName
        + "." + EXPORT_FORMAT.XLS.toString().toLowerCase());
    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.exportReport();
  } 
View Full Code Here
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
      {
                                returnResult = tempFolder + "readonly.xls";
        ByteArrayOutputStream outputByteArray = new ByteArrayOutputStream();
                                outStream = new FileOutputStream(new File(returnResult));

        JRXlsExporter exporterXLS = new JRXlsExporter();
               exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT, print);
              exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, outputByteArray);
              exporterXLS.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
               exporterXLS.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE);
               exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
               exporterXLS.exportReport();
                                outStream.write(outputByteArray.toByteArray());
      } else // PDF by default
      { 
                                returnResult = tempFolder + "readonly.pdf";
                                outStream = new FileOutputStream(new File(returnResult));
View Full Code Here
80
81
82
83
84
85
86
87
88
89
90
91
92
93
    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
TOP

Related Classes of net.sf.jasperreports.engine.export.JRXlsExporter

  • accounts.web.ReportJasperController
  • BarbecueApp
  • Barcode4JApp
  • BatchExportApp
  • br.com.caelum.vraptor.jasperreports.formats.Xls
  • br.gov.frameworkdemoiselle.report.internal.implementation.JasperReportsExporter
  • br.jus.tjrn.arq.report.jasper.JasperReportFileManager
  • ChartThemesApp
  • CrosstabApp
  • CsvDataSourceApp
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.