List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook write
@SuppressWarnings("resource") public final void write(OutputStream stream) throws IOException
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;//ww w . java2 s.co m 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); }
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 w w w . ja va2s .c o m 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;/*w w w. j a va 2 s. c om*/ 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 a v a 2 s .co m*/ 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);// w w w.java2s . 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 w w w .ja v a 2 s . c o m 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;//ww w .j av a 2s . c o 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;/* w w w . j ava 2 s . c om*/ 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 ww w . j ava2 s . c o m 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 writeInputDataPoints() { //the file already exists if (new File(filePath3).canRead()) { //System.out.println("File already exists.."); try {/*from w w w . j a v a 2 s .c o m*/ FileInputStream file = new FileInputStream(new File(filePath3)); //Create Workbook instance holding reference to .xlsx file XSSFWorkbook workbook1 = new XSSFWorkbook(file); //Get first/desired sheet from the workbook XSSFSheet sheet1 = workbook1.getSheetAt(11); //define a cell style for bold font CellStyle style = workbook1.createCellStyle(); Font font = workbook1.createFont(); font.setBoldweight(Font.BOLDWEIGHT_BOLD); style.setFont(font); Row r1 = sheet1.getRow(0); if (r1 == null) { // First cell in the row, create r1 = sheet1.createRow(0); } Cell c = r1.getCell(0); if (c == null) { c = r1.createCell(0); } c.setCellValue("VRPTW instance - " + VRPTW.instance.name + "; data point coordinates corresponding to customers' requests"); c.setCellStyle(style); Row r = sheet1.getRow(2); if (r == null) { // First cell in the row, create r = sheet1.createRow(2); } Cell c1 = r.getCell(0); if (c1 == null) { c1 = r.createCell(0); } c1.setCellValue("Point #"); c1.setCellStyle(style); c1 = r.getCell(1); if (c1 == null) { c1 = r.createCell(1); } c1.setCellValue("X Coord"); c1.setCellStyle(style); c1 = r.getCell(2); if (c1 == null) { c1 = r.createCell(2); } c1.setCellValue("Y Coord"); c1.setCellStyle(style); int size = VRPTW.instance.nodes.length; int rowIndex = 3; double x, y; for (int i = 0; i < size; i++) { x = VRPTW.instance.nodes[i].x; y = VRPTW.instance.nodes[i].y; r = sheet1.getRow(rowIndex + i); if (r == null) { // First cell in the row, create //System.out.println("Empty row, create new one"); r = sheet1.createRow(rowIndex + i); } c1 = r.getCell(0); if (c1 == null) { // New cell //System.out.println("Empty cell, create new one"); c1 = r.createCell(0); } c1.setCellValue(i); c1 = r.getCell(1); if (c1 == null) { // New cell //System.out.println("Empty cell, create new one"); c1 = r.createCell(1); } c1.setCellValue(x); c1 = r.getCell(2); if (c1 == null) { // New cell //System.out.println("Empty cell, create new one"); c1 = r.createCell(2); } c1.setCellValue(y); } //Write the workbook in file system FileOutputStream out = new FileOutputStream(new File(filePath3)); workbook1.write(out); out.close(); //System.out.println("Written successfully on disk."); } catch (Exception e) { e.printStackTrace(); } } else { System.out.println("File not exists.."); } }