Differences

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

--- gettingstartedwithjasperreports [2022/01/05 19:56] – [Generate an Excel Spreadsheet from SimpleReport] wikiadmin
+++ gettingstartedwithjasperreports [2022/01/05 20:09] (current) – [Generate a Spreadsheet from SimpleReport] wikiadmin
@@ Line 354: / Line 354: @@
 try {
         reportStream = new FileInputStream(compiledReport);
+        parameters = new HashMap(); //empty hashmap  (no parameters)
         jasperPrint = JasperFillManager.fillReport( reportStream , parameters);
         xlxsExporter = new JRXlsxExporter();
@@ Line 371: / 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>