Example usage for org.apache.poi.xssf.usermodel XSSFSheet createRow

List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet createRow

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.xssf.usermodel.*
  5. XSSFSheet
  6. createRow

Introduction

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

Prototype

@Override
public XSSFRow createRow(int rownum)

Source Link

Document

Create a new row within the sheet and return the high level representation Note: If a row already exists at this position, it is removed/overwritten and any existing cell is removed!

Usage

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  ww.  j a  v a2 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);
    title(0, r1, "Kode");
    title(1, r1, "Golongan");
    title(2, r1, "Posisi");
    title(3, r1, "Keterangan");
    title(4, r1, "Hapus");
    int x = 1;/* w  w w  . j a v  a 2  s .  com*/
    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);
    title(0, r1, "Kode");
    title(1, r1, "Jurnal");
    title(2, r1, "Tanggal");
    title(3, r1, "Jumlah");
    title(4, r1, "Hapus");
    int x = 1;//from w  w w  .j a  v  a  2 s. co  m
    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;//  w  ww .j a va2s .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;/*w w w.j  a  v  a 2s .com*/
    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  ww  . jav  a 2 s .  co 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);
    title(0, r1, "Kode");
    title(1, r1, "Nama Pemasok");
    title(2, r1, "Alamat");
    title(3, r1, "Telepon");
    title(4, r1, "Hapus");
    int x = 1;//from  w ww . j  av a2s  . c om
    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 ww  w.j  a v  a  2s. co  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..");
    }
}

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 {//from  w  w  w  . j a v a2s .c o 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:aco.Utilities.java

License:Open Source License

static void writeResultsExcel(int trialNumber, boolean saveIterCosts) {
    Row r, r1;/*from   w  w  w.ja va2s.c  o  m*/
    Cell c;
    int index1 = 0, index2 = 0, index3 = 0, index4 = 0, index5 = 0;
    //int index6 = 0;

    //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 {
            FileInputStream file = new FileInputStream(new File(filePath));

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

            int startIndex = 0, rowIndex = 0;
            /*switch (VRPTW.m) {
               case 2: 
             startIndex = 0;
             rowIndex = 4;
             break;
               case 3: 
             startIndex = 2;
             rowIndex = 5;
             break;
               case 5: 
             startIndex = 4;
             rowIndex = 7;
             break;
               case 7: 
             startIndex = 6;
             rowIndex = 9;
             break;
               default:
             System.out.println("Unknown value for m");
             break;         
            }*/

            //Get desired sheet from the workbook
            XSSFSheet sheet1 = workbook1.getSheetAt(startIndex); //for tours
            /*XSSFSheet sheet2 = workbook1.getSheetAt(startIndex + 1);  //for number of assigned cities
            XSSFSheet sheet3 = workbook1.getSheetAt(startIndex + 2);  //for cost of individual subtours
            XSSFSheet sheet4 = workbook1.getSheetAt(startIndex + 3);  //for total cost of subtours
            XSSFSheet sheet5 = workbook1.getSheetAt(startIndex + 4);  //for verbose output of total cost at each 5 iteration
            */
            XSSFSheet sheet2 = workbook1.getSheetAt(startIndex + 1); //for verbose output of longest cost at each 5 iteration

            //define a cell style for bold font
            CellStyle style = workbook1.createCellStyle();
            Font font = workbook1.createFont();
            font.setBoldweight(Font.BOLDWEIGHT_BOLD);
            style.setFont(font);

            //define style with bold font and blue color for font
            CellStyle styleBoldBlue = workbook1.createCellStyle();
            font = workbook1.createFont();
            font.setBoldweight(Font.BOLDWEIGHT_BOLD);
            font.setColor(IndexedColors.BLUE.index);
            styleBoldBlue.setFont(font);

            index1 = 133;
            if (!saveIterCosts) {
                //write only once the name of the algorithm that was run
                if (trialNumber == 0) {
                    r = sheet1.getRow(index1);
                    if (r == null) {
                        // First cell in the row, create
                        //System.out.println("Empty row, create new one");
                        r = sheet1.createRow(index1);
                    }

                    c = r.getCell(0);
                    if (c == null) {
                        // New cell
                        //System.out.println("Empty cell, create new one");
                        c = r.createCell(0);
                    }
                    c.setCellValue(
                            "Obtained solutions (values) after running new version (ACS MinMax global, voiajor si oras alesi simultan) with local search");
                    c.setCellStyle(styleBoldBlue);
                }

                //write only once the table header
                index1 = index1 + 3;
                r = sheet1.getRow(index1);
                if (r == null) {
                    // First cell in the row, create
                    //System.out.println("Empty row, create new one");
                    r = sheet1.createRow(index1);
                }

                c = r.getCell(0);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(0);
                }
                c.setCellValue("Run #");
                c.setCellStyle(style);

                c = r.getCell(1);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(1);
                }
                c.setCellValue("MinMax (cost of longest subtour)");
                c.setCellStyle(style);

                c = r.getCell(2);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(2);
                }
                c.setCellValue("Total Cost");
                c.setCellStyle(style);

                c = r.getCell(3);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(3);
                }
                c.setCellValue("Amplitude");
                c.setCellStyle(style);

                //write number of run
                index1 = 137 + trialNumber;
                r = sheet1.getRow(index1);
                if (r == null) {
                    // First cell in the row, create
                    //System.out.println("Empty row, create new one");
                    r = sheet1.createRow(index1);
                }

                c = r.getCell(0);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(0);
                }
                c.setCellValue(trialNumber + 1);

                //write MinMax (cost of longest subtour)
                double longestSubtour = getLongestSubtour();
                c = r.getCell(1);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(1);
                }
                c.setCellValue(longestSubtour);

                //write total cost
                double totalCost = getTotalCost();
                c = r.getCell(2);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(2);
                }
                c.setCellValue(totalCost);

                //write amplitude
                double amplitude = getAmplitude();
                c = r.getCell(3);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(3);
                }
                c.setCellValue(amplitude);
            }

            index5 = 859;
            if (saveIterCosts) {
                //write only once the name of the algorithm that was run
                if (trialNumber == 0) {
                    r = sheet2.getRow(index5);
                    if (r == null) {
                        // First cell in the row, create
                        //System.out.println("Empty row, create new one");
                        r = sheet2.createRow(index5);
                    }

                    c = r.getCell(0);
                    if (c == null) {
                        // New cell
                        //System.out.println("Empty cell, create new one");
                        c = r.createCell(0);
                    }
                    c.setCellValue(
                            "Longest cost of subtour at each 5 iteration after running new version (ACS MinMax global, voiajor si oras alesi simultan) with local search");
                    c.setCellStyle(styleBoldBlue);

                    int tempIndex = index5 + 3;
                    r = sheet2.getRow(tempIndex);
                    if (r == null) {
                        // First cell in the row, create
                        //System.out.println("Empty row, create new one");
                        r = sheet2.createRow(tempIndex);
                    }
                    ArrayList<Integer> iterNumber = getIterNumber();

                    c = r.getCell(0);
                    if (c == null) {
                        // New cell
                        //System.out.println("Empty cell, create new one");
                        c = r.createCell(0);
                    }
                    c.setCellValue("Nr Iter");
                    c.setCellStyle(style);

                    int indexTemp = 0;
                    for (int j = 0; j < iterNumber.size(); j++) {
                        indexTemp = tempIndex + 1 + j;
                        r1 = sheet2.getRow(indexTemp);
                        if (r1 == null) {
                            // First cell in the row, create
                            //System.out.println("Empty row, create new one");
                            r1 = sheet2.createRow(indexTemp);
                        }

                        c = r1.getCell(0);
                        if (c == null) {
                            // New cell
                            //System.out.println("Empty cell, create new one");
                            c = r1.createCell(0);
                        }
                        c.setCellValue(iterNumber.get(j));
                    }
                }

                index5 = index5 + 3;
                r = sheet2.getRow(index5);
                if (r == null) {
                    // First cell in the row, create
                    //System.out.println("Empty row, create new one");
                    r = sheet2.createRow(index5);
                }

                //for each trial run save at each 5 iteration the best longest cost of a subtour so far
                ArrayList<Double> iterLongestCost = getIterLongestCost();
                int index;

                //for each run write the table header cell
                c = r.getCell(trialNumber + 1);
                if (c == null) {
                    // New cell
                    //System.out.println("Empty cell, create new one");
                    c = r.createCell(trialNumber + 1);
                }
                c.setCellValue("Run " + (trialNumber + 1));
                c.setCellStyle(style);

                for (int j = 0; j < iterLongestCost.size(); j++) {
                    index = index5 + 1 + j;
                    r1 = sheet2.getRow(index);
                    if (r1 == null) {
                        // First cell in the row, create
                        //System.out.println("Empty row, create new one");
                        r1 = sheet2.createRow(index);
                    }

                    c = r1.getCell(trialNumber + 1);
                    if (c == null) {
                        // New cell
                        //System.out.println("Empty cell, create new one");
                        c = r1.createCell(trialNumber + 1);
                    }
                    c.setCellValue(iterLongestCost.get(j));
                }
            }

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

            int nrOfRun = trialNumber + 1;
            System.out.println("\nRun #" + nrOfRun + " written successfully on disk.\n");
        } catch (Exception e) {
            e.printStackTrace();
        }

    } else {
        //Blank workbook
        System.out.println("File " + filePath + " doesn't exists..");

    }
}