Example usage for org.apache.poi.xssf.usermodel XSSFRow getCell

List of usage examples for org.apache.poi.xssf.usermodel XSSFRow getCell

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFRow
  6. getCell

Introduction

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

Prototype

@Override
public XSSFCell getCell(int cellnum)

Source Link

Document

Returns the cell at the given (0 based) index, with the org.apache.poi.ss.usermodel.Row.MissingCellPolicy from the parent Workbook.

Usage

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

private void keluar() {
    try {//from  w w  w .j  av 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("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  w  w w. ja  va 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("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 {/*from   w w  w.  jav a2  s .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("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 {/*  ww  w  .  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("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  ww  w .j ava 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("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 {//w w  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("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 {// w w w.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("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);
}

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

private void suplier() {
    try {/*from  w w  w . j av a2  s .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("Pemasok");
        List<achmad.rifai.erp1.entity.Suplier> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Suplier su = new achmad.rifai.erp1.entity.Suplier();
            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> l1 = new java.util.LinkedList<>(), l2 = new java.util.LinkedList<>();
            boolean trus = true;
            while (trus || (null == r2.getCell(0) && !r2.getCell(2).getStringCellValue().isEmpty())) {
                trus = false;
                l1.add(r2.getCell(2).getStringCellValue());
                y++;
                r2 = s.getRow(y);
            }
            su.setAlamat(l1);
            trus = true;
            while (trus || (null == r3.getCell(0) && !r3.getCell(3).getStringCellValue().isEmpty())) {
                trus = false;
                l2.add(r3.getCell(3).getStringCellValue());
                z++;
                r3 = s.getRow(z);
            }
            su.setTelp(l2);
            if (y > z)
                c = y;
            else
                c = z;
            su.setKode(r1.getCell(0).getStringCellValue());
            su.setNama(r1.getCell(1).getStringCellValue());
            su.setDeleted(Boolean.parseBoolean(r1.getCell(4).getStringCellValue()));
            l.add(su);
            x = c + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progSuplier.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOSuplier(d).insert(l.get(c));
            progSuplier.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progSuplier.setValue(100);
}

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

private void income() {
    try {/*from   w  ww  .  ja  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("Pemasukan");
        List<achmad.rifai.erp1.entity.Terima> l = new java.util.LinkedList<>();
        int x = 1;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Terima t = new achmad.rifai.erp1.entity.Terima();
            org.apache.poi.xssf.usermodel.XSSFRow r = s.getRow(x);
            t.setKode(r.getCell(0).getStringCellValue());
            t.setJurnal(r.getCell(1).getStringCellValue());
            t.setTgl(org.joda.time.DateTime.parse(r.getCell(2).getStringCellValue()));
            t.setUang(org.joda.money.Money.parse(r.getCell(3).getStringCellValue()));
            t.setDeleted(Boolean.parseBoolean(r.getCell(4).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(t);
        }
        progIncome.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOTerima(d).insert(l.get(c));
            progIncome.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progIncome.setValue(100);
}

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

private void tracks() {
    try {/*  w  w w .  j av a  2 s .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("Buku Perilaku");
        List<achmad.rifai.erp1.entity.Tracks> l = new java.util.LinkedList<>();
        int x = 2;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.Tracks t = new achmad.rifai.erp1.entity.Tracks();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            List<achmad.rifai.erp1.entity.Jejak> l1 = new java.util.LinkedList<>();
            boolean trus = true;
            while (trus || null == r2.getCell(0)) {
                achmad.rifai.erp1.entity.Jejak j = new achmad.rifai.erp1.entity.Jejak();
                j.setAksi(r2.getCell(2).getStringCellValue());
                j.setWaktu(org.joda.time.DateTime.parse(r2.getCell(3).getStringCellValue()));
                l1.add(j);
                trus = false;
                y++;
                r2 = s.getRow(y);
            }
            t.setL(l1);
            t.setKode(r1.getCell(0).getStringCellValue());
            t.setId(r1.getCell(1).getStringCellValue());
            t.setBln(Month.valueOf(r1.getCell(4).getStringCellValue()));
            t.setTahun(Integer.parseInt(r1.getCell(5).getStringCellValue()));
            t.setDeleted(Boolean.parseBoolean(r1.getCell(6).getStringCellValue()));
            l.add(t);
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progTrack.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOTracks(d).insert(l.get(c));
            progTrack.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progTrack.setValue(100);
}