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

Introduction

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

Prototype

@Override
public XSSFSheet createSheet(String sheetname) 

Source Link

Document

Create a new sheet for this Workbook and return the high level representation.

Usage

From source file:CreateExcel.java

public static void write_excel() {
    XSSFWorkbook wb = new XSSFWorkbook();
    XSSFSheet sheet = wb.createSheet("version 1");

    System.out.println("created");
    Row row = sheet.createRow((short) 0);
    Cell col = row.createCell(0);// w ww  .  j av  a  2s  .co  m
    col.setCellValue("FileName");
    row.createCell(1).setCellValue("Boc");

    System.out.println("here");
    FileOutputStream fos;
    try {
        fos = new FileOutputStream("C:\\Users\\aryan_000\\Desktop\\output.xlsx");
        wb.write(fos);
        fos.close();
    } catch (FileNotFoundException e) {
    } catch (IOException e) {
    }
}

---

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);//from  w  w  w.  j  a v  a  2s  .  c  o  m
    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;
    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);/*from   w  ww. java2  s  .c o  m*/
    title(0, r1, "Nama");
    title(1, r1, "Gaji");
    title(2, r1, "Kapasitas");
    title(3, r1, "Hapus");
    int x = 1;
    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);// w  ww  .ja  va2  s .co m
    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;
    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);//from   w  w w. j a va 2s.c  om
    title(0, r1, "Kode");
    title(1, r1, "Tanggal");
    title(2, r1, "Jurnal");
    title(3, r1, "Uang");
    title(4, r1, "Hapus");
    int x = 1;
    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);/*from w  w w  .ja  va2 s .co  m*/
    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;
    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 www.j a v  a  2 s .  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);//from  www.j  av  a2  s. c o  m
    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 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);/*from  w  ww  .  j a  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 w w .j  a va 2s  .c  om*/
    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);
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• 10
• 11
• 12
• 13
• 14
• 15
• 16
• 17
• 18
• 19
• 20
• 21
• 22
• 23
• 24
• 25
• 26
• 27
• 28
• »