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

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

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. getSheet

Introduction

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

Prototype

@Override
public XSSFSheet getSheet(String name)

Source Link

Document

Get sheet with the given name (case insensitive match)

Usage

From source file:FenetrePrincipal.java

/**
 * This method is called from within the constructor to initialize the form.
 * WARNING: Do NOT modify this code. The content of this method is always
 * regenerated by the Form Editor.//from  w ww.  j  a  va  2 s . co m
 */
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">                          
private void initComponents() {

    jScrollBar1 = new JScrollBar();
    jPanelOption = new JPanel();
    jPanelBanniere = new JPanel();
    jLabelBanniere = new JLabel();
    jPanel4 = new JPanel();
    jLabel1 = new JLabel();
    jPanelCentre = new JPanel();
    jScrollPane1 = new JScrollPane();
    jTable1 = new JTable();
    jMenuBar1 = new JMenuBar();
    jMenu1 = new JMenu();
    jMenu2 = new JMenu();
    ajouterBouton = new JButton("Ajouter Etudiant");
    statBouton = new JButton("   Satistiques   ");
    jPanelBouton1 = new JPanel();
    jPanelBouton2 = new JPanel();
    pdfBouton = new JButton("   Exporter Pdf   ");
    exportBouton = new JButton("Exporter Fichier ");
    setDefaultCloseOperation(WindowConstants.EXIT_ON_CLOSE);
    getContentPane().setLayout(new javax.swing.BoxLayout(getContentPane(), javax.swing.BoxLayout.LINE_AXIS));
    jLabelBanniere.setText("");

    javax.swing.GroupLayout jPanelBanniereLayout = new javax.swing.GroupLayout(jPanelBanniere);
    jPanelBanniere.setLayout(jPanelBanniereLayout);
    jPanelBanniereLayout.setHorizontalGroup(jPanelBanniereLayout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING).addComponent(jLabelBanniere,
                    javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE,
                    javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE));
    jPanelBanniereLayout
            .setVerticalGroup(
                    jPanelBanniereLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addGroup(jPanelBanniereLayout.createSequentialGroup()
                                    .addComponent(jLabelBanniere, javax.swing.GroupLayout.PREFERRED_SIZE, 50,
                                            javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(0, 0, Short.MAX_VALUE)));

    jPanel4.setLayout(new java.awt.GridLayout(4, 1));

    jLabel1.setText("");
    jPanel4.add(jPanelBouton1);
    jPanel4.add(jPanelBouton2);
    jPanelBouton1.add(ajouterBouton);
    jPanelBouton1.add(statBouton);
    jPanelBouton2.add(exportBouton);
    jPanelBouton2.add(pdfBouton);

    try {
        File excel = new File("results.xlsx");
        FileInputStream fis = new FileInputStream(excel);

        XSSFWorkbook wb = new XSSFWorkbook(fis);
        XSSFSheet ws = wb.getSheet("M1 Informatique - S8 - Pre-insc");

        rowNum = ws.getLastRowNum() + 1;
        colNum = ws.getRow(0).getLastCellNum();

        data = new String[rowNum][colNum];

        for (int i = 0; i < rowNum; i++) {
            XSSFRow row = ws.getRow(i);
            for (int j = 0; j < colNum; j++) {
                XSSFCell cell = row.getCell(j);
                String value = cellToString(cell);
                data[i][j] = value;
                System.out.println("The value is : " + value);
            }

        }

    } catch (FileNotFoundException e) {
        // TODO Auto-generated catch block
        System.out.println("Erreur");
        e.printStackTrace();
    } catch (IOException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
    }

    String[] entetes = new String[colNum];
    for (int i = 0; i < colNum; i++) {
        entetes[i] = data[0][i];
    }

    jTable1.setModel(new javax.swing.table.DefaultTableModel(data, entetes));
    jScrollPane1.setViewportView(jTable1);
    jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);

    javax.swing.GroupLayout jPanelCentreLayout = new javax.swing.GroupLayout(jPanelCentre);
    jPanelCentre.setLayout(jPanelCentreLayout);
    jPanelCentreLayout.setHorizontalGroup(jPanelCentreLayout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelCentreLayout.createSequentialGroup().addContainerGap()
                    .addComponent(jScrollPane1, javax.swing.GroupLayout.DEFAULT_SIZE, 465, Short.MAX_VALUE)
                    .addContainerGap()));
    jPanelCentreLayout.setVerticalGroup(jPanelCentreLayout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelCentreLayout.createSequentialGroup().addComponent(jScrollPane1,
                    javax.swing.GroupLayout.PREFERRED_SIZE, 481, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addGap(0, 0, Short.MAX_VALUE)));

    javax.swing.GroupLayout jPanelOptionLayout = new javax.swing.GroupLayout(jPanelOption);
    jPanelOption.setLayout(jPanelOptionLayout);
    jPanelOptionLayout.setHorizontalGroup(
            jPanelOptionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                    .addComponent(jPanelBanniere, javax.swing.GroupLayout.DEFAULT_SIZE,
                            javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                    .addGroup(jPanelOptionLayout.createSequentialGroup()
                            .addComponent(jPanel4, javax.swing.GroupLayout.PREFERRED_SIZE, 150,
                                    javax.swing.GroupLayout.PREFERRED_SIZE)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                            .addComponent(jPanelCentre, javax.swing.GroupLayout.DEFAULT_SIZE,
                                    javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)));
    jPanelOptionLayout.setVerticalGroup(jPanelOptionLayout
            .createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
            .addGroup(jPanelOptionLayout.createSequentialGroup()
                    .addComponent(jPanelBanniere, javax.swing.GroupLayout.PREFERRED_SIZE,
                            javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                    .addGroup(jPanelOptionLayout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                            .addComponent(jPanelCentre, javax.swing.GroupLayout.DEFAULT_SIZE,
                                    javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(jPanel4, javax.swing.GroupLayout.DEFAULT_SIZE,
                                    javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))));

    getContentPane().add(jPanelOption);

    jMenu1.setText("Fichier");
    jMenuBar1.add(jMenu1);
    JMenuItem importer = new JMenuItem("Importer");
    JMenuItem exporter = new JMenuItem("Exporter");
    jMenu1.add(importer);
    jMenu1.add(exporter);

    jMenu2.setText("Edition");
    jMenuBar1.add(jMenu2);

    setJMenuBar(jMenuBar1);

    importer.addActionListener(new ActionListener() {

        @Override
        public void actionPerformed(ActionEvent e) {
            // TODO Auto-generated method stub
            //FileExtensionFilterDemo f = new FileExtensionFilterDemo();
            showOpenFileDialog();
        }
    });

    pack();
}

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

private void barang() {
    try {/*from   w  w  w  . j  a  v 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("barang");
        java.util.List<achmad.rifai.erp1.entity.Barang> 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.Barang b = new achmad.rifai.erp1.entity.Barang();
            b.setKode(r.getCell(0).getStringCellValue());
            b.setNama(r.getCell(1).getStringCellValue());
            b.setHarga(org.joda.money.Money.parse(r.getCell(2).getStringCellValue()));
            b.setStok(Integer.parseInt(r.getCell(3).getStringCellValue()));
            b.setSatuan(r.getCell(4).getStringCellValue());
            b.setDeleted(Boolean.parseBoolean(r.getCell(5).getStringCellValue()));
            x++;
            st = s.getRow(x).getCell(0).getStringCellValue();
            l.add(b);
        }
        progBarang.setValue(50);
        for (int c = 0; c < l.size(); x++) {
            new achmad.rifai.erp1.entity.dao.DAOBarang(d).insert(l.get(c));
            progBarang.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progBarang.setValue(100);
}

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

private void absen() {
    try {/*from w w  w  .ja  v 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("absen");
        java.util.List<achmad.rifai.erp1.entity.BukuAbsen> l = new java.util.LinkedList<>();
        int x = 2;
        String st = s.getRow(x).getCell(0).getStringCellValue();
        while (!st.isEmpty()) {
            achmad.rifai.erp1.entity.BukuAbsen b = new achmad.rifai.erp1.entity.BukuAbsen();
            int y = x;
            org.apache.poi.xssf.usermodel.XSSFRow r1 = s.getRow(x), r2 = s.getRow(y);
            boolean trus = true;
            b.setTgl(r1.getCell(0).getStringCellValue());
            b.setDeleted(Boolean.parseBoolean(r1.getCell(3).getStringCellValue()));
            java.util.List<achmad.rifai.erp1.entity.Absen> l2 = new java.util.LinkedList<>();
            while (trus || null == r2.getCell(0)) {
                trus = false;
                Absen a = new Absen();
                a.setS(r2.getCell(1).getStringCellValue());
                a.setL(Absen.Jenise.valueOf(r2.getCell(2).getStringCellValue()));
                l2.add(a);
                y++;
                r2 = s.getRow(y);
            }
            b.setL(l2);
            l.add(b);
            x = y + 1;
            st = s.getRow(x).getCell(0).getStringCellValue();
        }
        progAbsen.setValue(50);
        for (int c = 0; c < l.size(); c++) {
            new achmad.rifai.erp1.entity.dao.DAOBukuAbsen(d).insert(l.get(c));
            progAbsen.setValue((((1 + c) * 50) / l.size()) + 50);
        }
        d.close();
    } catch (Exception ex) {
        achmad.rifai.erp1.util.Db.hindar(ex);
    }
    progAbsen.setValue(100);
}

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

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