Differences

This shows you the differences between two versions of the page.

--- gettingstartedwithjasperreports [2022/01/05 19:50] – [MIStudio SimpleReport Project] wikiadmin
+++ gettingstartedwithjasperreports [2022/01/05 20:09] (current) – [Generate a Spreadsheet from SimpleReport] wikiadmin
@@ Line 298: / Line 298: @@
 That's the end of this basic Tutorial. You can also generate other report types from this same SimpleReport.jasper file (see code examples below).
-===Generate an Excel Spreadsheet from SimpleReport===
+===Generate a Spreadsheet from SimpleReport===
-Instead of generating a PDF you can make an xls or xlsx report (excel spreadsheets).
+Instead of generating a PDF you can make an xls or xlsx report (excel spreadsheets), or a csv file.
 To make an xls spreadsheet, use this code in the JavaScript bean:
@@ Line 339: / Line 339: @@
 <code javascript>
+//Script to run SimpleReport.jasper as an XLSX Excel Spreadsheet
+var HashMap = Java.type("java.util.HashMap");
+var FileInputStream = Java.type("java.io.FileInputStream");
+var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
+var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
+var JRXlsxExporter = Java.type("net.sf.jasperreports.engine.export.ooxml.JRXlsxExporter");
+var SimpleOutputStreamExporterOutput = Java.type("net.sf.jasperreports.export.SimpleOutputStreamExporterOutput");
+var SimpleExporterInput = Java.type("net.sf.jasperreports.export.SimpleExporterInput");
+compiledReport="SimpleReport.jasper";
+outputName = "SimpleReport.xlsx";
+try {
+        reportStream = new FileInputStream(compiledReport);
+        parameters = new HashMap(); //empty hashmap  (no parameters)
+        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
+        xlxsExporter = new JRXlsxExporter();
+        xlxsExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
+        xlxsExporter.setExporterOutput(new SimpleOutputStreamExporterOutput(outputName));
+        xlxsExporter.exportReport();
+} catch (e) {
+    print("Error in Run JasperReport script: \n"+e.stack);
+    print(e);
+}
 </code>
@@ Line 345: / Line 372: @@
 <code javascript>
+//Script to run SimpleReport.jasper to generate a CSV file
+var HashMap = Java.type("java.util.HashMap");
+var FileInputStream = Java.type("java.io.FileInputStream");
+var JasperPrint = Java.type("net.sf.jasperreports.engine.JasperPrint");
+var JasperFillManager = Java.type("net.sf.jasperreports.engine.JasperFillManager");
+var JRCsvExporter = Java.type("net.sf.jasperreports.engine.export.JRCsvExporter");
+var SimpleCsvExporterConfiguration = Java.type("net.sf.jasperreports.export.SimpleCsvExporterConfiguration");
+var SimpleWriterExporterOutput = Java.type("net.sf.jasperreports.export.SimpleWriterExporterOutput");
+var SimpleExporterInput = Java.type("net.sf.jasperreports.export.SimpleExporterInput");
+compiledReport="SimpleReport.jasper";
+outputName = "SimpleReport.csv";
+try {
+        reportStream = new FileInputStream(compiledReport);
+        parameters = new HashMap(); //empty hashmap  (no parameters)
+        parameters.put("IS_IGNORE_PAGINATION", true);
+        jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
+        csvExporter = new JRCsvExporter();
+        csvExporter.setExporterInput(new SimpleExporterInput(jasperPrint));
+        csvExporter.setExporterOutput(new SimpleWriterExporterOutput(outputName));
+        csvConfiguration = new SimpleCsvExporterConfiguration();
+        csvConfiguration.setWriteBOM(true);
+        csvConfiguration.setRecordDelimiter("\r\n");
+        csvExporter.setConfiguration(csvConfiguration);
+        csvExporter.exportReport();
+} catch (e) {
+    print("Error in Run JasperReport script: \n"+e.stack);
+    print(e);
+}
 </code>