iReport 3 jTabel to Excel

iReport 3 jTabel to Excel   

Kebanyakan komputer kantor yang menggunakan OS Windows mempunyai program Microsoft Office untuk mendukung kerja dan membuat laporan di kantor. Mocrosoft Office Excel salah satu yang sering kita gunakan dalam bekerja dan membuat laporan-laporan. Langsung Cap Cuus...

Contoh JavaApp jTable to Excel dengan Netbeans 7.1

Dibawah ini void untuk compile report dan set mode excelnya :

        //PROSES PEMANGGILAN REPORT

        private void jTableToExelWithiReport() {

        this.setCursor(java.awt.Cursor.getPredefinedCursor(java.awt.Cursor.WAIT_CURSOR));

        try {

            //Ambil model dari jTable

            model = (javax.swing.table.DefaultTableModel) jTable1.getModel();

            net.sf.jasperreports.engine.data.JRTableModelDataSource data = new net.sf.jasperreports.engine.data.JRTableModelDataSource(model);

            //Path file iReport

            java.io.File fullPath = new java.io.File((curDir + "\\Report\\jTableToExcel.xml"));

            // Persiapkan parameter untuk Report

            java.util.Map parameters = new java.util.HashMap();

            parameters.put("PRM_DATE", new java.text.SimpleDateFormat("dd MMM yyyy", java.util.Locale.getDefault()).format(new java.util.Date()));

            //Compile report

            net.sf.jasperreports.engine.JasperReport JRpt = net.sf.jasperreports.engine.JasperCompileManager.compileReport(fullPath.toString());

            net.sf.jasperreports.engine.JasperPrint JPrint = net.sf.jasperreports.engine.JasperFillManager.fillReport(JRpt, parameters, data);

            java.io.File destFile = new java.io.File(fullPath.getParent(), JPrint.getName() + ".xls");

            //Membuat exporter excel

            net.sf.jasperreports.engine.export.JRXlsExporter exporter = new net.sf.jasperreports.engine.export.JRXlsExporter();

            //Mengatur file excel yg akan di buat

            exporter.setParameter(net.sf.jasperreports.engine.JRExporterParameter.JASPER_PRINT, JPrint);

            exporter.setParameter(net.sf.jasperreports.engine.JRExporterParameter.OUTPUT_FILE_NAME, destFile.toString());

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, false);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, false);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_COLUMNS, false);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_DETECT_CELL_TYPE, true);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, false);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_IGNORE_GRAPHICS, false);

            exporter.setParameter(net.sf.jasperreports.engine.export.JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN, true);

            //Proses export ke excel

            exporter.exportReport();

            //Menjalankan file excel yg sudah dibuat

            Runtime.getRuntime().exec("cmd /c Start report\\" + destFile.getName());

            destFile.deleteOnExit();

        } catch (Exception ex) {

            javax.swing.JOptionPane.showMessageDialog(null, "Report Can't view because : " + ex);

        }

        this.setCursor(java.awt.Cursor.getDefaultCursor());

    }

Untuk Download Projectnya klik Di sini