Example usage for org.apache.poi.xssf.usermodel XSSFSheet addMergedRegion

List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet addMergedRegion

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFSheet
  6. addMergedRegion

Introduction

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

Prototype

@Override
public int addMergedRegion(CellRangeAddress region)

Source Link

Document

Adds a merged region of cells on a sheet.

Usage

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

private void absen(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("absen");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Tanggal", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 1, 2));
    title(1, r1, "Daftar");
    title2(3, r1, "Hapus", s);
    title(1, r2, "Pegawai");
    title(2, r2, "Keadaan");
    int x = 2;/*from   ww  w . j av  a2s . co m*/
    for (achmad.rifai.erp1.entity.BukuAbsen b : new achmad.rifai.erp1.entity.dao.DAOBukuAbsen(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Absen a : b.getL()) {
            XSSFRow r = s.createRow(y);
            konten(1, r, a.getS());
            konten(2, r, "" + a.getL());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, b.getTgl());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 3, 3));
        konten1(3, r, "" + b.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((2 * 100) / 17);
}

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

private void karyawan(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("karyawan");
    XSSFRow r1 = s.createRow(0);/*w  w w .  j  a  va 2  s. com*/
    title(0, r1, "ID");
    title(1, r1, "Nama");
    title(2, r1, "Alamat");
    title(3, r1, "Password");
    title(4, r1, "E-Mail");
    title(5, r1, "Jabatan");
    title(6, r1, "Tanggal Diterima");
    title(7, r1, "Telepon / HP");
    title(8, r1, "Sedang Login");
    title(9, r1, "Sedang Dicekal");
    title(10, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Karyawan k : new achmad.rifai.erp1.entity.dao.DAOKaryawan(d).all()) {
        int y = x;
        for (String st : k.getAlamat()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, st);
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, k.getId());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, k.getNama());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 3, 3));
        konten1(3, r, k.getPass());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 4, 4));
        konten1(4, r, k.getEmail());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, k.getJabatan());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + k.getHiredate());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 7, 7));
        konten1(7, r, k.getTelp());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 8, 8));
        konten1(8, r, "" + k.isMasuk());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 9, 9));
        konten1(9, r, "" + k.isBlocked());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 10, 10));
        konten1(10, r, "" + k.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((5 * 100) / 17);
}

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

private void title2(int i, XSSFRow r1, String s, XSSFSheet sh) {
    sh.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 1, i, i));
    org.apache.poi.xssf.usermodel.XSSFCell c = r1.createCell(i);
    c.setCellType(CellType.STRING);/*from www  .  j a  v  a2s. com*/
    c.setCellValue(s);
    org.apache.poi.xssf.usermodel.XSSFCellStyle cs = c.getCellStyle();
    cs.setFillBackgroundColor(new org.apache.poi.xssf.usermodel.XSSFColor(Color.BLACK));
    cs.setFillForegroundColor(new org.apache.poi.xssf.usermodel.XSSFColor(Color.YELLOW));
    cs.setAlignment(HorizontalAlignment.CENTER);
    cs.setVerticalAlignment(VerticalAlignment.CENTER);
    cs.setBorderBottom(BorderStyle.DASHED);
    cs.setBorderTop(BorderStyle.DASHED);
    cs.setBorderLeft(BorderStyle.DASHED);
    cs.setBorderRight(BorderStyle.DASHED);
}

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

private void pelanggan(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("pelanggan");
    XSSFRow r1 = s.createRow(0);// w w  w . ja v  a 2s  .c  om
    title(0, r1, "Kode");
    title(1, r1, "Nama Pelanggan");
    title(2, r1, "Alamat");
    title(3, r1, "Telepon");
    title(4, r1, "Dicekal");
    title(5, r1, "Dihapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Pelanggan p : new achmad.rifai.erp1.entity.dao.DAOPelanggan(d).all()) {
        int y = x, c, z = x;
        for (String st : p.getAlamat()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, st);
            y++;
        }
        for (String st : p.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, p.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 1, 1));
        konten1(1, r, p.getNama());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 4, 4));
        konten1(4, r, "" + p.isBlocked());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 5, 5));
        konten1(5, r, "" + p.isDeleted());
        x = c + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((8 * 100) / 17);
}

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;//w  ww .  jav  a2  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  .  j  a  va 2s  .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;//from  w  ww  .j a v  a2  s. co  m
    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 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;//  ww  w .  j a va  2 s .co  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;//www. ja v a 2  s  .  com
    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  ww .  j  a  v  a 2 s  .  c o  m
    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);
}