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

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

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFWorkbook
  6. 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: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;//from www  . j  a va 2s. com
    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);
}

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

private void pesan(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("pesan");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode Pesan", s);
    title2(1, r1, "Pengirim", s);
    title2(2, r1, "Waktu", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 4));
    title(3, r1, "Penerima");
    title(3, r2, "Pembaca");
    title(4, r2, "Sudah Dibaca");
    title2(5, r1, "Isi", s);
    title2(6, r1, "Hapus", s);
    int x = 2;//from   w  w w  .  j  a v a2  s .  c o m
    for (achmad.rifai.erp1.entity.Pesan p : new achmad.rifai.erp1.entity.dao.DAOPesan(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Penerima pe : p.getKe()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, pe.getAkun());
            konten(4, r, "" + pe.isTerbaca());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, p.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, p.getPengirim());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + p.getWaktu());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, p.getPesan());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + p.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((11 * 100) / 17);
}

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

private void rekening(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Rekening");
    XSSFRow r1 = s.createRow(0);//w  w  w . j  av  a 2 s  . c  om
    title(0, r1, "Kode");
    title(1, r1, "Golongan");
    title(2, r1, "Posisi");
    title(3, r1, "Keterangan");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Rekening re : new achmad.rifai.erp1.entity.dao.DAORekening(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, re.getKode());
        konten(1, r, re.getGolongan());
        konten(2, r, re.getPosisi());
        konten(3, r, re.getKet());
        konten(4, r, "" + re.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((12 * 100) / 17);
}

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

private void income(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Pemasukan");
    XSSFRow r1 = s.createRow(0);/*from   w w  w . j  a va 2 s  . c  o  m*/
    title(0, r1, "Kode");
    title(1, r1, "Jurnal");
    title(2, r1, "Tanggal");
    title(3, r1, "Jumlah");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Terima t : new achmad.rifai.erp1.entity.dao.DAOTerima(d).all()) {
        XSSFRow r = s.createRow(x);
        konten(0, r, t.getKode());
        konten(1, r, t.getJurnal());
        konten(2, r, "" + t.getTgl());
        konten(3, r, "" + t.getUang());
        konten(4, r, "" + t.isDeleted());
        x++;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((14 * 100) / 17);
}

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

private void tracks(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Buku Perilaku");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "Pegawai", s);
    title2(4, r1, "Bulan", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 2, 3));
    title(2, r1, "Daftar");
    title(2, r2, "Perilaku");
    title(3, r2, "Waktu");
    title2(5, r1, "Tahun", s);
    title2(6, r1, "Hapus", s);
    int x = 2;//from   ww w  .j  a  va2  s  .c om
    for (achmad.rifai.erp1.entity.Tracks t : new achmad.rifai.erp1.entity.dao.DAOTracks(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Jejak j : t.getL()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, j.getAksi());
            konten(3, r, "" + j.getWaktu());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, t.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, t.getId());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 4, 4));
        konten1(4, r, "" + t.getBln());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, "" + t.getTahun());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + t.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((15 * 100) / 17);
}

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

private void tugas(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Tugas");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "No", s);
    title2(2, r1, "Tanggal", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 3, 6));
    title(3, r1, "Pegawai Dan Status");
    title(3, r2, "Pegawai");
    title(4, r2, "Diambil");
    title(5, r2, "Sedang Dikerjakan");
    title(6, r2, "Sudah Selesai");
    title2(7, r1, "Keterangan", s);
    title2(8, r1, "Batal", s);
    title2(9, r1, "Pending", s);
    title2(10, r1, "Hapus", s);
    int x = 2;/*from   w w  w . j  a  v a2s. co  m*/
    for (achmad.rifai.erp1.entity.Tugas t : new achmad.rifai.erp1.entity.dao.DAOTugas(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Petugas p : t.getL()) {
            XSSFRow r = s.createRow(y);
            konten(3, r, p.getKaryawan());
            konten(4, r, "" + p.isDiambil());
            konten(5, r, "" + p.isSedang());
            konten(6, r, "" + p.isTerlaksana());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, t.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, "" + t.getNo());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 2, 2));
        konten1(2, r, "" + t.getTgl());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 7, 7));
        konten1(7, r, t.getKet());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 8, 8));
        konten1(8, r, "" + t.isBatal());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 9, 9));
        konten1(9, r, "" + t.isPending());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 10, 10));
        konten1(10, r, "" + t.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((16 * 100) / 17);
}

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

private void bonus(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Bonus Pegawai");
    XSSFRow r1 = s.createRow(0), r2 = s.createRow(1);
    title2(0, r1, "Kode", s);
    title2(1, r1, "Pegawai", s);
    s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(0, 0, 2, 3));
    title(2, r1, "Bonus");
    title(2, r2, "No");
    title(3, r2, "Jumlah");
    title2(4, r1, "Bulan", s);
    title2(5, r1, "Tahun", s);
    title2(6, r1, "Hapus", s);
    int x = 2;//from w ww .j a  v  a  2s. c o  m
    for (achmad.rifai.erp1.entity.BulanBonus b : new achmad.rifai.erp1.entity.dao.DAOBulanBonus(d).all()) {
        int y = x;
        for (achmad.rifai.erp1.entity.Bonusan bo : b.getL()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, "" + bo.getNomer());
            konten(3, r, "" + bo.getJumlah());
            y++;
        }
        XSSFRow r = s.createRow(x);
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 0, 0));
        konten1(0, r, b.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 1, 1));
        konten1(1, r, b.getPeg());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 4, 4));
        konten1(4, r, "" + b.getBln());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 5, 5));
        konten1(5, r, "" + b.getThn());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, y, 6, 6));
        konten1(6, r, "" + b.isDeleted());
        x = y + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((17 * 100) / 17);
}

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

private void suplier(Db d) throws Exception {
    org.apache.poi.xssf.usermodel.XSSFWorkbook w = new org.apache.poi.xssf.usermodel.XSSFWorkbook(f);
    XSSFSheet s = w.createSheet("Pemasok");
    XSSFRow r1 = s.createRow(0);//from w w w  . j ava  2  s . com
    title(0, r1, "Kode");
    title(1, r1, "Nama Pemasok");
    title(2, r1, "Alamat");
    title(3, r1, "Telepon");
    title(4, r1, "Hapus");
    int x = 1;
    for (achmad.rifai.erp1.entity.Suplier su : new achmad.rifai.erp1.entity.dao.DAOSuplier(d).all()) {
        int y = x, z = x, c;
        for (String st : su.getAlamat()) {
            XSSFRow r = s.createRow(y);
            konten(2, r, st);
            y++;
        }
        for (String st : su.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, su.getKode());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 1, 1));
        konten1(1, r, su.getNama());
        s.addMergedRegion(new org.apache.poi.ss.util.CellRangeAddress(x, c, 4, 4));
        konten1(4, r, "" + su.isDeleted());
        x = c + 1;
    }
    java.io.FileOutputStream o = new java.io.FileOutputStream(f);
    w.write(o);
    o.close();
    prog.setValue((13 * 100) / 17);
}

From source file:aco.Utilities.java

License:Open Source License

static void writeExcel(int n, int m, int result) {
    //the file already exists; we should add a new row as the last one in the Excel file
    if (new File(filePath).canRead()) {
        //System.out.println("File already exists..");
        try {// w w w . jav a2 s  .co  m
            FileInputStream file = new FileInputStream(new File(filePath));

            //Create Workbook instance holding reference to .xlsx file
            XSSFWorkbook workbook1 = new XSSFWorkbook(file);

            //Get first/desired sheet from the workbook
            XSSFSheet sheet1 = workbook1.getSheetAt(2);
            int countRows = sheet1.getLastRowNum() + 1;
            Row newRow = sheet1.createRow(countRows++);

            int cellnum = 0;
            Cell cell = newRow.createCell(cellnum++);
            cell.setCellValue(n);
            cell = newRow.createCell(cellnum++);
            cell.setCellValue(m);
            cell = newRow.createCell(cellnum++);
            cell.setCellValue(result);

            //Write the workbook in file system
            FileOutputStream out = new FileOutputStream(new File(filePath));
            workbook1.write(out);
            out.close();

            //System.out.println("Written successfully on disk.");
        } catch (Exception e) {
            e.printStackTrace();
        }

    } else {
        //Blank workbook
        XSSFWorkbook workbook2 = new XSSFWorkbook();

        //Create a blank sheet
        XSSFSheet sheet2 = workbook2.createSheet("Results - 51 cities");

        //Iterate over data and write to sheet
        int rownum = 0, cellnum = 0;
        Row row = sheet2.createRow(rownum++);
        Cell cell = row.createCell(cellnum++);
        cell.setCellValue(n);
        cell = row.createCell(cellnum++);
        cell.setCellValue(m);
        cell = row.createCell(cellnum++);
        cell.setCellValue(result);

        try {
            //Write the workbook in file system
            FileOutputStream out = new FileOutputStream(new File(filePath));
            workbook2.write(out);
            out.close();

            //System.out.println("Written successfully on disk.");
        } catch (Exception e) {
            e.printStackTrace();
        }

    }
}

From source file:Algorithm.Method1.java

public String[] MethodTest(String Path) {
    StringBuffer keyword1 = new StringBuffer();
    try {/*w  w  w  .  j  a  va2 s  .c o m*/
        Hashtable hash = new Hashtable();

        FileInputStream file = new FileInputStream(new File(Path));
        XSSFWorkbook workbook = new XSSFWorkbook(file);
        XSSFSheet sheet1 = workbook.getSheetAt(0);
        Iterator<Row> rowIterator = sheet1.iterator();
        while (rowIterator.hasNext()) {
            Row row = rowIterator.next();
            //Row rowNew =sheetNew.createRow(rowNumNew++);
            //For each row, iterate through all the columns
            Iterator<org.apache.poi.ss.usermodel.Cell> cellIterator = row.cellIterator();
            while (cellIterator.hasNext()) {
                org.apache.poi.ss.usermodel.Cell cell = cellIterator.next();
                // Cell cellNew =rowNew.createCell(cellNumNew++);
                //Check the cell type and format accordingly
                switch (cell.getCellType()) {
                case org.apache.poi.ss.usermodel.Cell.CELL_TYPE_NUMERIC:
                    break;
                case org.apache.poi.ss.usermodel.Cell.CELL_TYPE_STRING:
                    String result = cell.getStringCellValue();
                    if (hash.containsKey(result)) {
                        int f = Integer.parseInt(hash.get(result).toString());
                        f++;
                        hash.put(result, f);
                    } else {
                        hash.put(result, 1);
                    }

                }
            }

            //System.out.println("");
        }

        XSSFWorkbook workbookNew = new XSSFWorkbook();
        XSSFSheet sheetNew = workbookNew.createSheet("test");
        int rowNum = 0;

        Set s = hash.keySet();
        String key = new String();
        int t = 0;
        for (Iterator<String> i = s.iterator(); i.hasNext();) {
            key = i.next();
            Row rowNew = sheetNew.createRow(rowNum);
            org.apache.poi.ss.usermodel.Cell cellNew = rowNew.createCell(0);
            cellNew.setCellValue(key);
            keyword1.append(key + " ");
            org.apache.poi.ss.usermodel.Cell cellNew2 = rowNew.createCell(1);
            cellNew2.setCellValue(hash.get(key).toString());
            rowNum++;
            //sheet2.addCell(new Label(0,t , key));
            //System.out.println(hash.get(key));
            //sheet2.addCell(new Label(1,t , hash.get(key).toString()));
            t++;
        }

        FileOutputStream fileOut = new FileOutputStream(new File(Path.replace("???.xlsx", "method1.xlsx")));//new file
        workbookNew.write(fileOut);
        fileOut.close();

        file.close();

        // Workbook book = Workbook.getWorkbook(new File("n.xls"));

        //WritableWorkbook book2 = Workbook.createWorkbook(new File("method1.xls"));
        //
        // WritableSheet sheet2 = book2.createSheet("num1", 0);

        // 
        //Sheet sheet = book.getSheet(0);         
        //int rownum = sheet.getRows();// 
        /**
        Cell cell;
        for(int i = 0;i<rownum;i++){
           cell = sheet.getCell(0,i);
           String result = cell.getContents();
           if(hash.containsKey(result)){
          int f = Integer.parseInt(hash.get(result).toString());
          f++;
          hash.put(result, f);
           }else{
          hash.put(result, 1);
           }
        }
        */
        //??
        /*
        Set s=hash.keySet();
        String key = new String();
        int t = 0;
        for(Iterator<String> i=s.iterator();i.hasNext();){
           key = i.next();
           sheet2.addCell(new Label(0,t , key));
        //System.out.println(hash.get(key));
        sheet2.addCell(new Label(1,t , hash.get(key).toString()));
        t++;
        }
                
        book2.write();
        book2.close();
        */
        // book.close();
        System.out.print("method1");
    } catch (Exception e) {
        System.out.println(e);
    }
    return keyword1.toString().split(" ");
}