Example usage for org.apache.poi.xssf.usermodel XSSFWorkbook write

List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook write

Introduction

In this page you can find the example usage for org.apache.poi.xssf.usermodel XSSFWorkbook write.

Prototype

@SuppressWarnings("resource")
public final void write(OutputStream stream) throws IOException 

Source Link

Document

Write out this document to an Outputstream.

Usage

From source file:achmad.rifai.admin.ui.Saver.java

private void pembelian(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("pembelian");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Struk", s);
    title2(1, r1, "Pemasok", s);
    title2(2, r1, "Tanggal", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 6));
    title(3, r1, "Item");
    title(3, r2, "Barang");
    title(4, r2, "Jumlah");
    title(5, r2, "Satuan");
    title(6, r2, "Sub Total");
    title2(7, r1, "Total", s);
    title2(8, r1, "Hapus", s);
    int x = 2;//ww w  .  java2 s.co m
    for (achmad.rifai.erp1.entity.Pembelian p : new achmad.rifai.erp1.entity.dao.DAOPembelian(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.ItemBeli i : p.getItems()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, i.getBarang());
            konten(4, r, "" + i.getJumlah());
            konten(5, r, i.getSatuan());
            konten(6, r, "" + i.getHarga());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, p.getStruk());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, p.getSuplier());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + p.getTgl());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 7, 7));
        konten1(7, r, "" + p.getHarga());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 8, 8));
        konten1(8, r, "" + p.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((9 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void penjualan(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("penjualan");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Nota", s);
    title2(1, r1, "Pelanggan", s);
    title2(2, r1, "Tanggal", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 5));
    title(3, r1, "Item");
    title(3, r2, "Barang");
    title(4, r2, "Qty");
    title(5, r2, "Sub Total");
    title2(6, r1, "Total", s);
    title2(7, r1, "Terbayar", s);
    title2(8, r1, "Keterangan", s);
    int x = 2;//from   w  w  w  . ja  va2s  .c o m
    for (achmad.rifai.erp1.entity.Penjualan p : new achmad.rifai.erp1.entity.dao.DAOPenjualan(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.ItemJual i : p.getItems()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, i.getBarang());
            konten(4, r1, "" + i.getJumlah());
            konten(5, r1, "" + i.getUang());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, p.getNota());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, p.getPelanggan());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + p.getTgl());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + p.getTotal());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 7, 7));
        konten1(7, r, "" + p.getTerbayar());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 8, 8));
        konten1(8, r, p.getKet());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 9, 9));
        konten1(9, r, "" + p.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((10 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void pesan(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("pesan");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode Pesan", s);
    title2(1, r1, "Pengirim", s);
    title2(2, r1, "Waktu", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 4));
    title(3, r1, "Penerima");
    title(3, r2, "Pembaca");
    title(4, r2, "Sudah Dibaca");
    title2(5, r1, "Isi", s);
    title2(6, r1, "Hapus", s);
    int x = 2;/*w  w w. j  a va  2  s.  c om*/
    for (achmad.rifai.erp1.entity.Pesan p : new achmad.rifai.erp1.entity.dao.DAOPesan(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Penerima pe : p.getKe()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, pe.getAkun());
            konten(4, r, "" + pe.isTerbaca());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, p.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, p.getPengirim());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + p.getWaktu());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, p.getPesan());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + p.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((11 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void rekening(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Rekening");
    XSSFRow r1 = s.createRow(0);/* w w  w. j  a v a  2 s .co  m*/
    title(0, r1, "Kode");
    title(1, r1, "Golongan");
    title(2, r1, "Posisi");
    title(3, r1, "Keterangan");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Rekening re : new achmad.rifai.erp1.entity.dao.DAORekening(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, re.getKode());
        konten(1, r, re.getGolongan());
        konten(2, r, re.getPosisi());
        konten(3, r, re.getKet());
        konten(4, r, "" + re.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((12 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void income(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Pemasukan");
    XSSFRow r1 = s.createRow(0);// w w  w.java2s . c  o  m
    title(0, r1, "Kode");
    title(1, r1, "Jurnal");
    title(2, r1, "Tanggal");
    title(3, r1, "Jumlah");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Terima t : new achmad.rifai.erp1.entity.dao.DAOTerima(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, t.getKode());
        konten(1, r, t.getJurnal());
        konten(2, r, "" + t.getTgl());
        konten(3, r, "" + t.getUang());
        konten(4, r, "" + t.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((14 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void tracks(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Buku Perilaku");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "Pegawai", s);
    title2(4, r1, "Bulan", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 2, 3));
    title(2, r1, "Daftar");
    title(2, r2, "Perilaku");
    title(3, r2, "Waktu");
    title2(5, r1, "Tahun", s);
    title2(6, r1, "Hapus", s);
    int x = 2;//from   w w  w  .ja v a  2 s  .  c  o  m
    for (achmad.rifai.erp1.entity.Tracks t : new achmad.rifai.erp1.entity.dao.DAOTracks(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Jejak j : t.getL()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, j.getAksi());
            konten(3, r, "" + j.getWaktu());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, t.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, t.getId());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 4, 4));
        konten1(4, r, "" + t.getBln());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, "" + t.getTahun());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + t.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((15 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void tugas(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Tugas");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "No", s);
    title2(2, r1, "Tanggal", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 6));
    title(3, r1, "Pegawai Dan Status");
    title(3, r2, "Pegawai");
    title(4, r2, "Diambil");
    title(5, r2, "Sedang Dikerjakan");
    title(6, r2, "Sudah Selesai");
    title2(7, r1, "Keterangan", s);
    title2(8, r1, "Batal", s);
    title2(9, r1, "Pending", s);
    title2(10, r1, "Hapus", s);
    int x = 2;//ww w .j av  a 2s .  c o  m
    for (achmad.rifai.erp1.entity.Tugas t : new achmad.rifai.erp1.entity.dao.DAOTugas(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Petugas p : t.getL()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, p.getKaryawan());
            konten(4, r, "" + p.isDiambil());
            konten(5, r, "" + p.isSedang());
            konten(6, r, "" + p.isTerlaksana());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, t.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, "" + t.getNo());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + t.getTgl());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 7, 7));
        konten1(7, r, t.getKet());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 8, 8));
        konten1(8, r, "" + t.isBatal());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 9, 9));
        konten1(9, r, "" + t.isPending());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 10, 10));
        konten1(10, r, "" + t.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((16 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void bonus(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Bonus Pegawai");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "Pegawai", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 2, 3));
    title(2, r1, "Bonus");
    title(2, r2, "No");
    title(3, r2, "Jumlah");
    title2(4, r1, "Bulan", s);
    title2(5, r1, "Tahun", s);
    title2(6, r1, "Hapus", s);
    int x = 2;/* w  w  w  .  j ava  2  s .  c  om*/
    for (achmad.rifai.erp1.entity.BulanBonus b : new achmad.rifai.erp1.entity.dao.DAOBulanBonus(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Bonusan bo : b.getL()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, "" + bo.getNomer());
            konten(3, r, "" + bo.getJumlah());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, b.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, b.getPeg());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 4, 4));
        konten1(4, r, "" + b.getBln());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, "" + b.getThn());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + b.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((17 * 100) / 17);
}

From source file:achmad.rifai.admin.ui.Saver.java

private void suplier(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Pemasok");
    XSSFRow r1 = s.createRow(0);//from   ww  w  . j  ava2  s . c o m
    title(0, r1, "Kode");
    title(1, r1, "Nama Pemasok");
    title(2, r1, "Alamat");
    title(3, r1, "Telepon");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Suplier su : new achmad.rifai.erp1.entity.dao.DAOSuplier(d).all()) {
        int y = x, z = x, c;
        for (String st : su.getAlamat()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, st);
            y++;
        }
        for (String st : su.getTelp()) {
            XSSFRow r = s.createRow(z);
            konten(3, r, st);
            z++;
        }
        if (y > z)
            c = y;
        else
            c = z;
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 0, 0));
        konten1(0, r, su.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 1, 1));
        konten1(1, r, su.getNama());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 4, 4));
        konten1(4, r, "" + su.isDeleted());
        x = c + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((13 * 100) / 17);
}

From source file:aco.Utilities.java

License:Open Source License

static void writeInputDataPoints() {
    //the file already exists
    if (new File(filePath3).canRead()) {
        //System.out.println("File already exists..");
        try {/*from w  w  w . j a v a 2  s .c  o  m*/
            FileInputStream file = new FileInputStream(new File(filePath3));

            //Create Workbook instance holding reference to .xlsx file
            XSSFWorkbook workbook1 = new XSSFWorkbook(file);

            //Get first/desired sheet from the workbook
            XSSFSheet sheet1 = workbook1.getSheetAt(11);

            //define a cell style for bold font
            CellStyle style = workbook1.createCellStyle();
            Font font = workbook1.createFont();
            font.setBoldweight(Font.BOLDWEIGHT_BOLD);
            style.setFont(font);

            Row r1 = sheet1.getRow(0);
            if (r1 == null) {
                // First cell in the row, create
                r1 = sheet1.createRow(0);
            }

            Cell c = r1.getCell(0);
            if (c == null) {
                c = r1.createCell(0);
            }
            c.setCellValue("VRPTW instance - " + VRPTW.instance.name
                    + "; data point coordinates corresponding to customers' requests");
            c.setCellStyle(style);

            Row r = sheet1.getRow(2);
            if (r == null) {
                // First cell in the row, create
                r = sheet1.createRow(2);
            }

            Cell c1 = r.getCell(0);
            if (c1 == null) {
                c1 = r.createCell(0);
            }
            c1.setCellValue("Point #");
            c1.setCellStyle(style);

            c1 = r.getCell(1);
            if (c1 == null) {
                c1 = r.createCell(1);
            }
            c1.setCellValue("X Coord");
            c1.setCellStyle(style);

            c1 = r.getCell(2);
            if (c1 == null) {
                c1 = r.createCell(2);
            }
            c1.setCellValue("Y Coord");
            c1.setCellStyle(style);

            int size = VRPTW.instance.nodes.length;
            int rowIndex = 3;
            double x, y;
            for (int i = 0; i < size; i++) {
                x = VRPTW.instance.nodes[i].x;
                y = VRPTW.instance.nodes[i].y;
                r = sheet1.getRow(rowIndex + i);
                if (r == null) {
                    // First cell in the row, create
                    //System.out.println("Empty row, create new one");
                    r = sheet1.createRow(rowIndex + i);
                }

                c1 = r.getCell(0);
                if (c1 == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c1 = r.createCell(0);
                }
                c1.setCellValue(i);

                c1 = r.getCell(1);
                if (c1 == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c1 = r.createCell(1);
                }
                c1.setCellValue(x);

                c1 = r.getCell(2);
                if (c1 == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c1 = r.createCell(2);
                }
                c1.setCellValue(y);

            }

            //Write the workbook in file system
            FileOutputStream out = new FileOutputStream(new File(filePath3));
            workbook1.write(out);
            out.close();

            //System.out.println("Written successfully on disk.");
        } catch (Exception e) {
            e.printStackTrace();
        }

    } else {
        System.out.println("File not exists..");
    }
}