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

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

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

Introduction

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

Prototype

@Override
public XSSFRow createRow(int rownum)

Source Link

Document

Create a new row within the sheet and return the high level representation Note: If a row already exists at this position, it is removed/overwritten and any existing cell is removed!

Usage

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

private void barang(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook();
    org.apache.poi.xssf.usermodel.XSSFSheet s = w.createSheet("barang");
    XSSFRow r1 = s.createRow(0);
    title(0, r1, "Kode");
    title(1, r1, "Nama");
    title(2, r1, "Harga");
    title(3, r1, "Stok");
    title(4, r1, "Satuan");
    title(5, r1, "Hapus");
    int x = 1;/*from  w  ww  . j  a va2 s.  co m*/
    for (achmad.rifai.erp1.entity.Barang b : new achmad.rifai.erp1.entity.dao.DAOBarang(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, b.getKode());
        konten(1, r, b.getNama());
        konten(2, r, "" + b.getHarga());
        konten(3, r, "" + b.getStok());
        konten(4, r, b.getSatuan());
        konten(5, r, "" + b.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((1 * 100) / 17);
}

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

private void jabatan(Db d) throws Exception {
    java.io.FileInputStream i = new java.io.FileInputStream(f);
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(i);
    org.apache.poi.xssf.usermodel.XSSFSheet s = w.createSheet("jabatan");
    XSSFRow r1 = s.createRow(0);
    title(0, r1, "Nama");
    title(1, r1, "Gaji");
    title(2, r1, "Kapasitas");
    title(3, r1, "Hapus");
    int x = 1;// w  ww . j  av a 2s  . co  m
    for (achmad.rifai.erp1.entity.Jabatan j : new achmad.rifai.erp1.entity.dao.DAOJabatan(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, j.getNama());
        konten(1, r, "" + j.getGaji());
        konten(2, r, "" + j.getKapasitas());
        konten(3, r, "" + j.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((3 * 100) / 17);
    i.close();
}

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

private void jurnal(Db d) throws Exception {
    java.io.FileInputStream i = new java.io.FileInputStream(f);
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(i);
    org.apache.poi.xssf.usermodel.XSSFSheet s = w.createSheet("jurnal");
    XSSFRow r1 = s.createRow(0);
    title(0, r1, "Kode");
    title(1, r1, "Tanggal");
    title(2, r1, "Keterangan");
    title(3, r1, "No");
    title(4, r1, "Hapus");
    title(5, r1, "Kredit");
    title(6, r1, "Debit");
    int x = 1;/*  ww w .  j av  a2  s . c  o m*/
    for (achmad.rifai.erp1.entity.Jurnal j : new achmad.rifai.erp1.entity.dao.DAOJurnal(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, j.getKode());
        konten(1, r, "" + j.getTgl());
        konten(2, r, j.getKet());
        konten(3, r, "" + j.getNo());
        konten(4, r, "" + j.isDeleted());
        konten(5, r, "" + j.getKredit());
        konten(6, r, "" + j.getDebit());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((4 * 100) / 17);
    i.close();
}

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

private void keluar(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    org.apache.poi.xssf.usermodel.XSSFSheet s = w.createSheet("expenses");
    XSSFRow r1 = s.createRow(0);
    title(0, r1, "Kode");
    title(1, r1, "Tanggal");
    title(2, r1, "Jurnal");
    title(3, r1, "Uang");
    title(4, r1, "Hapus");
    int x = 1;/*w ww  . j  a  va2  s.c om*/
    for (achmad.rifai.erp1.entity.Keluar k : new achmad.rifai.erp1.entity.dao.DAOKeluar(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, k.getKode());
        konten(1, r, "" + k.getTgl());
        konten(2, r, k.getJurnal());
        konten(3, r, "" + k.getUang());
        konten(4, r, "" + k.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((6 * 100) / 17);
}

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

private void ledger(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    org.apache.poi.xssf.usermodel.XSSFSheet s = w.createSheet("ledger");
    XSSFRow r1 = s.createRow(0);
    title(0, r1, "Kode");
    title(1, r1, "Tanggal");
    title(2, r1, "Keterangan");
    title(3, r1, "No");
    title(4, r1, "Debit");
    title(5, r1, "Kredit");
    title(6, r1, "Hapus");
    int x = 1;//w w  w  . ja  v  a 2  s  . c  o m
    for (achmad.rifai.erp1.entity.Ledger l : new achmad.rifai.erp1.entity.dao.DAOLedger(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, l.getKode());
        konten(1, r, "" + l.getTgl());
        konten(2, r, l.getKet());
        konten(3, r, "" + l.getNo());
        konten(4, r, "" + l.getDebit());
        konten(5, r, "" + l.getKredit());
        konten(6, r, "" + l.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((7 * 100) / 17);
}

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 w w  w .  j  a  v a2s .  com
    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);
    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;// w w w  . ja  va2  s.  c o  m
    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 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);
    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;//from   w w w . java 2s. c  om
    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  w w.  ja  v  a 2s  .  c o 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;/* w  w  w  . j a v a2 s . 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);
}