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

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

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

Introduction

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

Prototype

@Override
public XSSFRow getRow(int rownum)

Source Link

Document

Returns the logical row ( 0-based).

Usage

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

private void jabatan() {
    try {/*from ww  w.ja  v  a2s  . c o m*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("jabatan");
        java.util.List<achmad.rifai.erp1.entity.Jabatan> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            org.apache.poi.xssf.usermodel.XSSFRow r = s.getRow(x);
            achmad.rifai.erp1.entity.Jabatan j = new achmad.rifai.erp1.entity.Jabatan();
            j.setNama(r.getCell(0).getStringCellValue());
            j.setGaji(org.joda.money.Money.parse(r.getCell(1).getStringCellValue()));
            j.setKapasitas(Integer.parseInt(r.getCell(2).getStringCellValue()));
            j.setDeleted(Boolean.parseBoolean(r.getCell(3).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(j);
        }
        progJabatan.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOJabatan(d).insert(l.get(c));
            progJabatan.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progJabatan.setValue(100);
}

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

private void jurnal() {
    try {//  w ww .j a  va2  s  .  c o m
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("jurnal");
        java.util.List<achmad.rifai.erp1.entity.Jurnal> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            org.apache.poi.xssf.usermodel.XSSFRow r = s.getRow(x);
            achmad.rifai.erp1.entity.Jurnal j = new achmad.rifai.erp1.entity.Jurnal();
            j.setKode(r.getCell(0).getStringCellValue());
            j.setTgl(java.sql.Date.valueOf(r.getCell(1).getStringCellValue()));
            j.setKet(r.getCell(2).getStringCellValue());
            j.setNo(Integer.parseInt(r.getCell(3).getStringCellValue()));
            j.setDeleted(Boolean.parseBoolean(r.getCell(4).getStringCellValue()));
            j.setKredit(org.joda.money.Money.parse(r.getCell(5).getStringCellValue()));
            j.setDebit(org.joda.money.Money.parse(r.getCell(6).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(j);
        }
        progJurnal.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOJurnal(d).insert(l.get(c));
            progJurnal.setValue(50 + ((50 * (1 + c)) / l.size()));
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progJurnal.setValue(100);
}

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

private void karyawan() {
    try {/*  w ww  .j  a  va2 s.  co m*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("karyawan");
        java.util.List<achmad.rifai.erp1.entity.Karyawan> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Karyawan k = new achmad.rifai.erp1.entity.Karyawan();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            k.setId(r1.getCell(0).getStringCellValue());
            k.setNama(r1.getCell(1).getStringCellValue());
            boolean trus = true;
            List<String> l2 = new java.util.LinkedList<>();
            while (trus || null == r2.getCell(0)) {
                l2.add(r2.getCell(2).getStringCellValue());
                y++;
                r2 = s.getRow(y);
                trus = false;
            }
            k.setAlamat(l2);
            k.setPass(r1.getCell(3).getStringCellValue());
            k.setEmail(r1.getCell(4).getStringCellValue());
            k.setJabatan(r1.getCell(5).getStringCellValue());
            k.setHiredate(java.sql.Date.valueOf(r1.getCell(6).getStringCellValue()));
            k.setTelp(r1.getCell(7).getStringCellValue());
            k.setMasuk(Boolean.parseBoolean(r1.getCell(8).getStringCellValue()));
            k.setBlocked(Boolean.parseBoolean(r1.getCell(9).getStringCellValue()));
            k.setDeleted(Boolean.parseBoolean(r1.getCell(10).getStringCellValue()));
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(k);
        }
        progKaryawan.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOKaryawan(d).insert(l.get(c));
            progKaryawan.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progKaryawan.setValue(100);
}

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

private void keluar() {
    try {//from w w  w .  j  a  v a  2s . c  om
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("expenses");
        List<achmad.rifai.erp1.entity.Keluar> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Keluar k = new achmad.rifai.erp1.entity.Keluar();
            org.apache.poi.xssf.usermodel.XSSFRow r = s.getRow(x);
            k.setKode(r.getCell(0).getStringCellValue());
            k.setTgl(org.joda.time.DateTime.parse(r.getCell(1).getStringCellValue()));
            k.setJurnal(r.getCell(2).getStringCellValue());
            k.setUang(org.joda.money.Money.parse(r.getCell(3).getStringCellValue()));
            k.setDeleted(Boolean.parseBoolean(r.getCell(4).getStringCellValue()));
            x++;
            l.add(k);
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progKeluar.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOKeluar(d).insert(l.get(c));
            progKeluar.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progKeluar.setValue(100);
}

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

private void ledger() {
    try {/*from ww  w . java 2s .c om*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("ledger");
        List<achmad.rifai.erp1.entity.Ledger> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Ledger le = new achmad.rifai.erp1.entity.Ledger();
            org.apache.poi.xssf.usermodel.XSSFRow r = s.getRow(x);
            le.setKode(r.getCell(0).getStringCellValue());
            le.setTgl(java.sql.Date.valueOf(r.getCell(1).getStringCellValue()));
            le.setKet(r.getCell(2).getStringCellValue());
            le.setNo(Integer.parseInt(r.getCell(3).getStringCellValue()));
            le.setDebit(org.joda.money.Money.parse(r.getCell(4).getStringCellValue()));
            le.setKredit(org.joda.money.Money.parse(r.getCell(5).getStringCellValue()));
            le.setDeleted(Boolean.parseBoolean(r.getCell(6).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(le);
        }
        progLedger.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOLedger(d).insert(l.get(c));
            progLedger.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progLedger.setValue(100);
}

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

private void pelanggan() {
    try {/* w  ww  .ja v  a  2 s  . c o m*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("pelanggan");
        List<achmad.rifai.erp1.entity.Pelanggan> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Pelanggan p = new achmad.rifai.erp1.entity.Pelanggan();
            boolean trus = true;
            int y = x, c, z = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y), r3 = s.getRow(z);
            List<String> ls1 = new java.util.LinkedList<>(), ls2 = new java.util.LinkedList<>();
            while (trus || (null == r2.getCell(0) && !r2.getCell(2).getStringCellValue().isEmpty())) {
                ls1.add(r2.getCell(2).getStringCellValue());
                trus = false;
                y++;
                r2 = s.getRow(y);
            }
            p.setAlamat(ls1);
            trus = true;
            while (trus || (null == r3.getCell(0) && !r3.getCell(3).getStringCellValue().isEmpty())) {
                ls2.add(r3.getCell(3).getStringCellValue());
                trus = false;
                z++;
                r3 = s.getRow(z);
            }
            p.setTelp(ls2);
            if (y < z)
                c = z;
            else
                c = y;
            p.setKode(r1.getCell(0).getStringCellValue());
            p.setNama(r1.getCell(1).getStringCellValue());
            p.setBlocked(Boolean.parseBoolean(r1.getCell(4).getStringCellValue()));
            p.setDeleted(Boolean.parseBoolean(r1.getCell(5).getStringCellValue()));
            l.add(p);
            x = c + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progPelanggan.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOPelanggan(d).insert(l.get(c));
            progPelanggan.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progPelanggan.setValue(100);
}

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

private void pembelian() {
    try {/*from   w  w w.java 2  s .c o  m*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("pembelian");
        List<achmad.rifai.erp1.entity.Pembelian> l = new java.util.LinkedList<>();
        int x = 2;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Pembelian p = new achmad.rifai.erp1.entity.Pembelian();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            List<achmad.rifai.erp1.entity.ItemBeli> l1 = new java.util.LinkedList<>();
            boolean trus = true;
            while (trus || r2.getCell(0) == null) {
                achmad.rifai.erp1.entity.ItemBeli i = new achmad.rifai.erp1.entity.ItemBeli();
                i.setBarang(r2.getCell(3).getStringCellValue());
                i.setJumlah(Integer.parseInt(r2.getCell(4).getStringCellValue()));
                i.setSatuan(r2.getCell(5).getStringCellValue());
                i.setHarga(org.joda.money.Money.parse(r2.getCell(6).getStringCellValue()));
                trus = false;
                y++;
                l1.add(i);
                r2 = s.getRow(y);
            }
            p.setItems(l1);
            p.setStruk(r1.getCell(0).getStringCellValue());
            p.setSuplier(r1.getCell(1).getStringCellValue());
            p.setTgl(java.sql.Date.valueOf(r1.getCell(2).getStringCellValue()));
            p.setHarga(org.joda.money.Money.parse(r1.getCell(7).getStringCellValue()));
            p.setDeleted(Boolean.parseBoolean(r1.getCell(8).getStringCellValue()));
            l.add(p);
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progPembelian.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOPembelian(d).insert(l.get(c));
            progPembelian.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progPembelian.setValue(100);
}

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

private void penjualan() {
    try {//from  www . j  a v  a 2s .  com
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("penjualan");
        List<achmad.rifai.erp1.entity.Penjualan> l = new java.util.LinkedList<>();
        int x = 2;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Penjualan p = new achmad.rifai.erp1.entity.Penjualan();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            List<achmad.rifai.erp1.entity.ItemJual> l1 = new java.util.LinkedList<>();
            boolean trus = true;
            while (trus || null == r2.getCell(0)) {
                achmad.rifai.erp1.entity.ItemJual i = new achmad.rifai.erp1.entity.ItemJual();
                i.setBarang(r2.getCell(3).getStringCellValue());
                i.setJumlah(Integer.parseInt(r2.getCell(4).getStringCellValue()));
                i.setUang(org.joda.money.Money.parse(r2.getCell(5).getStringCellValue()));
                trus = false;
                l1.add(i);
                y++;
                r2 = s.getRow(y);
            }
            p.setItems(l1);
            p.setNota(r1.getCell(0).getStringCellValue());
            p.setPelanggan(r1.getCell(1).getStringCellValue());
            p.setTgl(java.sql.Date.valueOf(r1.getCell(2).getStringCellValue()));
            p.setTotal(org.joda.money.Money.parse(r1.getCell(6).getStringCellValue()));
            p.setTerbayar(org.joda.money.Money.parse(r1.getCell(7).getStringCellValue()));
            p.setKet(r1.getCell(8).getStringCellValue());
            p.setDeleted(Boolean.parseBoolean(r1.getCell(9).getStringCellValue()));
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(p);
        }
        progPenjualan.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOPenjualan(d).insert(l.get(c));
            progPenjualan.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progPenjualan.setValue(100);
}

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

private void pesan() {
    try {//from   ww  w  .  j a  v a2 s.c o  m
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("pesan");
        List<achmad.rifai.erp1.entity.Pesan> l = new java.util.LinkedList<>();
        int x = 2;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Pesan p = new achmad.rifai.erp1.entity.Pesan();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            List<achmad.rifai.erp1.entity.Penerima> l1 = new java.util.LinkedList<>();
            boolean trus = true;
            while (trus || null == r2.getCell(0)) {
                achmad.rifai.erp1.entity.Penerima pe = new achmad.rifai.erp1.entity.Penerima();
                pe.setAkun(r2.getCell(3).getStringCellValue());
                pe.setTerbaca(Boolean.parseBoolean(r2.getCell(4).getStringCellValue()));
                trus = false;
                y++;
                r2 = s.getRow(y);
                l1.add(pe);
            }
            p.setKe(l1);
            p.setKode(r1.getCell(0).getStringCellValue());
            p.setPengirim(r1.getCell(1).getStringCellValue());
            p.setWaktu(org.joda.time.DateTime.parse(r1.getCell(2).getStringCellValue()));
            p.setPesan(r1.getCell(5).getStringCellValue());
            p.setDeleted(Boolean.parseBoolean(r1.getCell(6).getStringCellValue()));
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(p);
        }
        progPesan.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOPesan(d).insert(l.get(c));
            progPesan.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progPesan.setValue(100);
}

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

private void rekening() {
    try {/*ww  w  .jav a  2s.c om*/
        achmad.rifai.erp1.util.Db d = achmad.rifai.erp1.util.Work.loadDB();
        org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
        org.apache.poi.xssf.usermodel.XSSFSheet s = w.getSheet("Rekening");
        List<achmad.rifai.erp1.entity.Rekening> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Rekening r = new achmad.rifai.erp1.entity.Rekening();
            org.apache.poi.xssf.usermodel.XSSFRow ro = s.getRow(x);
            r.setKode(ro.getCell(0).getStringCellValue());
            r.setGolongan(ro.getCell(1).getStringCellValue());
            r.setPosisi(ro.getCell(2).getStringCellValue());
            r.setKet(ro.getCell(3).getStringCellValue());
            r.setDeleted(Boolean.parseBoolean(ro.getCell(4).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(r);
        }
        progRekening.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAORekening(d).insert(l.get(c));
            progRekening.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progRekening.setValue(100);
}