Package net.sf.jasperreports.engine.export

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

184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
    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.setParameter(JRXlsExporterParameter.IS_FONT_SIZE_FIX_ENABLED, Boolean.TRUE);
   
    exporter.exportReport();

    System.err.println("XLS creation time : " + (System.currentTimeMillis() - start));
  }
View Full Code Here
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
         openFile(sReportName, sPathFileOutput, sReportType, response);
         }else{
           sPathFileOutput="D://"+sReportName+".xls";
           ByteArrayOutputStream output = new ByteArrayOutputStream();
             OutputStream outputfile= new FileOutputStream(new File(sPathFileOutput));                   
             JRXlsExporter exporterXLS = new JRXlsExporter();
             exporterXLS.setParameter(JRXlsExporterParameter.JASPER_PRINT,jasperPrint);
             exporterXLS.setParameter(JRXlsExporterParameter.OUTPUT_FILE_NAME,sPathFileOutput);
             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.FALSE);
             exporterXLS.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE);
             exporterXLS.exportReport();
             outputfile.write(output.toByteArray());
          openFile(sReportName, sPathFileOutput, sReportType, response);
            
         }
     }
View Full Code Here
369
370
371
372
373
374
375
376
377
378
379
                // 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
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
            if (jp.getPages().size() < 1) {
                throw new ViewHandlerException("Report is Empty (no results?)");
            } else {
                Debug.logInfo("Got report, there are " + jp.getPages().size() + " pages.", module);
            }
           JRXlsExporter exporter = new JRXlsExporter();
           exporter.setParameter(JRXlsExporterParameter.JASPER_PRINT, jp);
           exporter.setParameter(JRXlsExporterParameter.OUTPUT_STREAM, response.getOutputStream());
           exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE);
           exporter.exportReport();

        } catch (IOException ie) {
            throw new ViewHandlerException("IO Error in report", ie);
        } catch (java.sql.SQLException e) {
            throw new ViewHandlerException("Database error while running report", e);
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
      {
        engineOutput.setContentType(ReportEngineOutput.CONTENT_TYPE_XLS);
       
        if (exportType == ExportType.XLS)
        {
          exporter = new JRXlsExporter();
        }
        else if (exportType == ExportType.EXCEL)
        {
          exporter = new JExcelApiExporter();
        }
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
                        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
241
242
243
244
245
246
247
   */
  public static void renderAsXls(JasperReport report, Map<String, Object> parameters, Object reportData,
      OutputStream stream) throws JRException {

    JasperPrint print = JasperFillManager.fillReport(report, parameters, convertReportData(reportData));
    render(new JRXlsExporter(), print, stream);
  }
View Full Code Here
260
261
262
263
264
265
266
267
268
   */
  public static void renderAsXls(JasperReport report, Map<String, Object> parameters, Object reportData,
      OutputStream stream, Map<JRExporterParameter, Object> exporterParameters) throws JRException {

    JasperPrint print = JasperFillManager.fillReport(report, parameters, convertReportData(reportData));
    JRXlsExporter exporter = new JRXlsExporter();
    exporter.setParameters(exporterParameters);
    render(exporter, print, stream);
  }
View Full Code Here
248
249
250
251
252
253
254
   */
  public static void renderAsXls(JasperReport report, Map parameters, Object reportData, OutputStream stream)
      throws JRException {

    JasperPrint print = JasperFillManager.fillReport(report, parameters, convertReportData(reportData));
    render(new JRXlsExporter(), print, stream);
  }
View Full Code Here
268
269
270
271
272
273
274
275
276
   */
  public static void renderAsXls(JasperReport report, Map parameters, Object reportData, OutputStream stream,
      Map exporterParameters) throws JRException {

    JasperPrint print = JasperFillManager.fillReport(report, parameters, convertReportData(reportData));
    JRXlsExporter exporter = new JRXlsExporter();
    exporter.setParameters(exporterParameters);
    render(exporter, print, stream);
  }
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.