Example usage for org.apache.poi.xssf.usermodel XSSFSheet 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:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java

License:Open Source License

@Override
@Transactional(readOnly = true)/*from w  ww .jav a2  s.  c o  m*/
public void hojaCalculoDepreciacion(Map<String, Object> params) {
    try {
        log.debug("Creando excel con depreciacion");
        XSSFWorkbook wb = new XSSFWorkbook();
        int rows = 0;
        if (params.containsKey("centrosDeCosto")) {
            XSSFSheet sheet = wb.createSheet("CentrosDeCosto");
            TreeSet<String> cuentas = null;
            Collection<Map<String, Object>> centrosDeCosto = (Collection<Map<String, Object>>) params
                    .get("centrosDeCosto");
            for (Map<String, Object> centroCosto : centrosDeCosto) {
                Map<String, Object> totales = (Map<String, Object>) centroCosto.get("totales");
                if (rows == 0) {
                    XSSFRow row = sheet.createRow(rows++);
                    int cols = 0;
                    row.createCell(cols++).setCellValue("Cuenta");
                    row.createCell(cols++).setCellValue("Nombre");
                    cuentas = new TreeSet<>(totales.keySet());
                    for (String cuenta : cuentas) {
                        row.createCell(cols++).setCellValue(cuenta);
                    }
                }
                int cols = 0;
                XSSFRow row = sheet.createRow(rows++);
                row.createCell(cols++).setCellValue((String) centroCosto.get("cuenta"));
                row.createCell(cols++).setCellValue((String) centroCosto.get("nombre"));
                for (String cuenta : cuentas) {
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue(((BigDecimal) totales.get(cuenta)).doubleValue());
                }
            }

            int cols = 0;
            XSSFRow row = sheet.createRow(rows++);
            row.createCell(cols++);
            row.createCell(cols++);
            List<Map<String, Object>> tiposDeActivo = (List<Map<String, Object>>) params.get("tiposDeActivo");
            for (Map<String, Object> tipoDeActivo : tiposDeActivo) {
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("total")).doubleValue());
            }
        } else {
            XSSFSheet sheet = wb.createSheet("Grupos");
            XSSFRow row = sheet.createRow(rows++);
            int cols = 0;
            row.createCell(cols++).setCellValue("CUENTA");
            row.createCell(cols++).setCellValue("NOMBRE");
            row.createCell(cols++).setCellValue("ACUMULADA");
            row.createCell(cols++).setCellValue("MENSUAL");

            List<Map<String, Object>> tiposDeActivo = (List<Map<String, Object>>) params.get("tiposDeActivo");
            for (Map<String, Object> tipoDeActivo : tiposDeActivo) {
                cols = 0;
                row = sheet.createRow(rows++);
                row.createCell(cols++).setCellValue(tipoDeActivo.get("cuenta").toString());
                row.createCell(cols++).setCellValue(tipoDeActivo.get("nombre").toString());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("ACUMULADA")).doubleValue());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("MENSUAL")).doubleValue());
            }

            cols = 0;
            row = sheet.createRow(rows++);
            row.createCell(cols++);
            row.createCell(cols++);

            Map<String, BigDecimal> totales = (Map<String, BigDecimal>) params.get("totales");
            row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                    .setCellValue((totales.get("ACUMULADA")).doubleValue());
            row.createCell(cols++, Cell.CELL_TYPE_NUMERIC).setCellValue((totales.get("MENSUAL")).doubleValue());
        }

        OutputStream out = (OutputStream) params.get("out");
        wb.write(out);
    } catch (IOException ex) {
        log.error("No se pudo crear la hoja de calculo", ex);
    }
}

---

From source file:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java

License:Open Source License

@Override
@Transactional(readOnly = true)/*w  w  w.j  a  va 2 s.  c  o m*/
public void hojaCalculoConcentradoDepreciacion(Map<String, Object> params) {
    try {
        log.debug("Creando excel con concentrado depreciacion");
        XSSFWorkbook wb = new XSSFWorkbook();
        int rows = 0;
        if (params.containsKey("centrosDeCosto")) {
            XSSFSheet sheet = wb.createSheet("CentrosDeCosto");
            List<Map<String, Object>> tiposDeActivo = (List<Map<String, Object>>) params.get("tiposDeActivo");
            Collection<Map<String, Object>> centrosDeCosto = (Collection<Map<String, Object>>) params
                    .get("centrosDeCosto");
            for (Map<String, Object> centroCosto : centrosDeCosto) {
                Map<String, Object> totales = (Map<String, Object>) centroCosto.get("totales");
                if (rows == 0) {
                    XSSFRow row = sheet.createRow(rows++);
                    int cols = 0;
                    row.createCell(cols++);
                    row.createCell(cols++);
                    for (Map<String, Object> tipoActivo : tiposDeActivo) {
                        log.debug("Creando encabezado de {}", tipoActivo.get("cuenta"));
                        row.createCell(cols++).setCellValue((String) tipoActivo.get("cuenta"));
                        row.createCell(cols++).setCellValue((String) tipoActivo.get("nombre"));
                        row.createCell(cols++);
                        row.createCell(cols++);
                        row.createCell(cols++);
                        row.createCell(cols++);
                    }
                    row = sheet.createRow(rows++);
                    cols = 0;
                    row.createCell(cols++).setCellValue("Cuenta");
                    row.createCell(cols++).setCellValue("Nombre");
                    for (Map<String, Object> tipoActivo : tiposDeActivo) {
                        log.debug("Creando columnas para {}", tipoActivo.get("cuenta"));
                        row.createCell(cols++).setCellValue("Costo");
                        row.createCell(cols++).setCellValue("Depreciacin Ao");
                        row.createCell(cols++).setCellValue("Depreciacion Anual");
                        row.createCell(cols++).setCellValue("Depreciacin Mensual");
                        row.createCell(cols++).setCellValue("Depreciacin Acumulada");
                        row.createCell(cols++).setCellValue("Valor Neto");
                    }
                }
                int cols = 0;
                XSSFRow row = sheet.createRow(rows++);
                row.createCell(cols++).setCellValue((String) centroCosto.get("cuenta"));
                row.createCell(cols++).setCellValue((String) centroCosto.get("nombre"));
                for (Map<String, Object> tipoActivo : tiposDeActivo) {
                    Map<String, BigDecimal> valores = (Map<String, BigDecimal>) totales
                            .get((String) tipoActivo.get("cuenta"));
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue((valores.get("costo")).doubleValue());
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC).setCellValue(0d);
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue((valores.get("anual")).doubleValue());
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue((valores.get("mensual")).doubleValue());
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue((valores.get("acumulada")).doubleValue());
                    row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                            .setCellValue((valores.get("valorNeto")).doubleValue());
                }
            }

            int cols = 0;
            XSSFRow row = sheet.createRow(rows++);
            row.createCell(cols++);
            row.createCell(cols++).setCellValue("TOTAL");
            for (Map<String, Object> tipoDeActivo : tiposDeActivo) {
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("costo")).doubleValue());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC).setCellValue(0d);
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("anual")).doubleValue());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("mensual")).doubleValue());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("acumulada")).doubleValue());
                row.createCell(cols++, Cell.CELL_TYPE_NUMERIC)
                        .setCellValue(((BigDecimal) tipoDeActivo.get("valorNeto")).doubleValue());
            }
        }

        OutputStream out = (OutputStream) params.get("out");
        wb.write(out);
    } catch (IOException ex) {
        log.error("No se pudo crear la hoja de calculo", ex);
    }
}

---

From source file:mymoney.Multi_cal.java

private void jButton6ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton6ActionPerformed
    JFileChooser cho = new JFileChooser();
    cho.showSaveDialog(null);//  w w w.  j  av a 2  s.co  m
    File f = cho.getSelectedFile();
    String filename = f.getAbsolutePath();
    DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet("New Data");
    TreeMap<String, Object[]> data = new TreeMap<String, Object[]>();

    data.put("1", new Object[] { "DATE", "NAME", "AMOUNT", "CATEGORY", "TYPE" });
    for (int i = 0;;) {
        if (jTable1.getRowCount() != i) {
            data.put("2",
                    new Object[] { jTable1.getValueAt(0, 0).toString(), jTable1.getValueAt(0, 1).toString(),
                            jTable1.getValueAt(0, 2).toString(), jTable1.getValueAt(0, 3).toString(),
                            jTable1.getValueAt(0, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("3",
                    new Object[] { jTable1.getValueAt(1, 0).toString(), jTable1.getValueAt(1, 1).toString(),
                            jTable1.getValueAt(1, 2).toString(), jTable1.getValueAt(1, 3).toString(),
                            jTable1.getValueAt(1, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("4",
                    new Object[] { jTable1.getValueAt(2, 0).toString(), jTable1.getValueAt(2, 1).toString(),
                            jTable1.getValueAt(2, 2).toString(), jTable1.getValueAt(2, 3).toString(),
                            jTable1.getValueAt(2, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("5",
                    new Object[] { jTable1.getValueAt(3, 0).toString(), jTable1.getValueAt(3, 1).toString(),
                            jTable1.getValueAt(3, 2).toString(), jTable1.getValueAt(3, 3).toString(),
                            jTable1.getValueAt(3, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("6",
                    new Object[] { jTable1.getValueAt(4, 0).toString(), jTable1.getValueAt(4, 1).toString(),
                            jTable1.getValueAt(4, 2).toString(), jTable1.getValueAt(4, 3).toString(),
                            jTable1.getValueAt(4, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("7",
                    new Object[] { jTable1.getValueAt(5, 0).toString(), jTable1.getValueAt(5, 1).toString(),
                            jTable1.getValueAt(5, 2).toString(), jTable1.getValueAt(5, 3).toString(),
                            jTable1.getValueAt(5, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("8",
                    new Object[] { jTable1.getValueAt(6, 0).toString(), jTable1.getValueAt(6, 1).toString(),
                            jTable1.getValueAt(6, 2).toString(), jTable1.getValueAt(6, 3).toString(),
                            jTable1.getValueAt(6, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("9",
                    new Object[] { jTable1.getValueAt(7, 0).toString(), jTable1.getValueAt(7, 1).toString(),
                            jTable1.getValueAt(7, 2).toString(), jTable1.getValueAt(7, 3).toString(),
                            jTable1.getValueAt(7, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("10",
                    new Object[] { jTable1.getValueAt(8, 0).toString(), jTable1.getValueAt(8, 1).toString(),
                            jTable1.getValueAt(8, 2).toString(), jTable1.getValueAt(8, 3).toString(),
                            jTable1.getValueAt(8, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("11",
                    new Object[] { jTable1.getValueAt(9, 0).toString(), jTable1.getValueAt(9, 1).toString(),
                            jTable1.getValueAt(9, 2).toString(), jTable1.getValueAt(9, 3).toString(),
                            jTable1.getValueAt(9, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("12",
                    new Object[] { jTable1.getValueAt(10, 0).toString(), jTable1.getValueAt(10, 1).toString(),
                            jTable1.getValueAt(10, 2).toString(), jTable1.getValueAt(10, 3).toString(),
                            jTable1.getValueAt(10, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("13",
                    new Object[] { jTable1.getValueAt(11, 0).toString(), jTable1.getValueAt(11, 1).toString(),
                            jTable1.getValueAt(11, 2).toString(), jTable1.getValueAt(11, 3).toString(),
                            jTable1.getValueAt(11, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("14",
                    new Object[] { jTable1.getValueAt(12, 0).toString(), jTable1.getValueAt(12, 1).toString(),
                            jTable1.getValueAt(12, 2).toString(), jTable1.getValueAt(12, 3).toString(),
                            jTable1.getValueAt(12, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("15",
                    new Object[] { jTable1.getValueAt(13, 0).toString(), jTable1.getValueAt(13, 1).toString(),
                            jTable1.getValueAt(13, 2).toString(), jTable1.getValueAt(13, 3).toString(),
                            jTable1.getValueAt(13, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("16",
                    new Object[] { jTable1.getValueAt(14, 0).toString(), jTable1.getValueAt(14, 1).toString(),
                            jTable1.getValueAt(14, 2).toString(), jTable1.getValueAt(14, 3).toString(),
                            jTable1.getValueAt(14, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("17",
                    new Object[] { jTable1.getValueAt(15, 0).toString(), jTable1.getValueAt(15, 1).toString(),
                            jTable1.getValueAt(15, 2).toString(), jTable1.getValueAt(15, 3).toString(),
                            jTable1.getValueAt(15, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("18",
                    new Object[] { jTable1.getValueAt(16, 0).toString(), jTable1.getValueAt(16, 1).toString(),
                            jTable1.getValueAt(16, 2).toString(), jTable1.getValueAt(16, 3).toString(),
                            jTable1.getValueAt(16, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("19",
                    new Object[] { jTable1.getValueAt(17, 0).toString(), jTable1.getValueAt(17, 1).toString(),
                            jTable1.getValueAt(17, 2).toString(), jTable1.getValueAt(17, 3).toString(),
                            jTable1.getValueAt(17, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("20",
                    new Object[] { jTable1.getValueAt(18, 0).toString(), jTable1.getValueAt(18, 1).toString(),
                            jTable1.getValueAt(18, 2).toString(), jTable1.getValueAt(18, 3).toString(),
                            jTable1.getValueAt(18, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("21",
                    new Object[] { jTable1.getValueAt(19, 0).toString(), jTable1.getValueAt(19, 1).toString(),
                            jTable1.getValueAt(19, 2).toString(), jTable1.getValueAt(19, 3).toString(),
                            jTable1.getValueAt(19, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("22",
                    new Object[] { jTable1.getValueAt(20, 0).toString(), jTable1.getValueAt(20, 1).toString(),
                            jTable1.getValueAt(20, 2).toString(), jTable1.getValueAt(20, 3).toString(),
                            jTable1.getValueAt(20, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("23",
                    new Object[] { jTable1.getValueAt(21, 0).toString(), jTable1.getValueAt(21, 1).toString(),
                            jTable1.getValueAt(21, 2).toString(), jTable1.getValueAt(21, 3).toString(),
                            jTable1.getValueAt(21, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("24",
                    new Object[] { jTable1.getValueAt(22, 0).toString(), jTable1.getValueAt(22, 1).toString(),
                            jTable1.getValueAt(22, 2).toString(), jTable1.getValueAt(22, 3).toString(),
                            jTable1.getValueAt(22, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("25",
                    new Object[] { jTable1.getValueAt(23, 0).toString(), jTable1.getValueAt(23, 1).toString(),
                            jTable1.getValueAt(23, 2).toString(), jTable1.getValueAt(23, 3).toString(),
                            jTable1.getValueAt(23, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("26",
                    new Object[] { jTable1.getValueAt(24, 0).toString(), jTable1.getValueAt(24, 1).toString(),
                            jTable1.getValueAt(24, 2).toString(), jTable1.getValueAt(24, 3).toString(),
                            jTable1.getValueAt(24, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("27",
                    new Object[] { jTable1.getValueAt(25, 0).toString(), jTable1.getValueAt(25, 1).toString(),
                            jTable1.getValueAt(25, 2).toString(), jTable1.getValueAt(25, 3).toString(),
                            jTable1.getValueAt(25, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("28",
                    new Object[] { jTable1.getValueAt(26, 0).toString(), jTable1.getValueAt(26, 1).toString(),
                            jTable1.getValueAt(26, 2).toString(), jTable1.getValueAt(26, 3).toString(),
                            jTable1.getValueAt(26, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("29",
                    new Object[] { jTable1.getValueAt(27, 0).toString(), jTable1.getValueAt(27, 1).toString(),
                            jTable1.getValueAt(27, 2).toString(), jTable1.getValueAt(27, 3).toString(),
                            jTable1.getValueAt(27, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("30",
                    new Object[] { jTable1.getValueAt(28, 0).toString(), jTable1.getValueAt(28, 1).toString(),
                            jTable1.getValueAt(28, 2).toString(), jTable1.getValueAt(28, 3).toString(),
                            jTable1.getValueAt(28, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("31",
                    new Object[] { jTable1.getValueAt(29, 0).toString(), jTable1.getValueAt(29, 1).toString(),
                            jTable1.getValueAt(29, 2).toString(), jTable1.getValueAt(29, 3).toString(),
                            jTable1.getValueAt(29, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("32",
                    new Object[] { jTable1.getValueAt(30, 0).toString(), jTable1.getValueAt(30, 1).toString(),
                            jTable1.getValueAt(30, 2).toString(), jTable1.getValueAt(30, 3).toString(),
                            jTable1.getValueAt(30, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("33",
                    new Object[] { jTable1.getValueAt(31, 0).toString(), jTable1.getValueAt(31, 1).toString(),
                            jTable1.getValueAt(31, 2).toString(), jTable1.getValueAt(31, 3).toString(),
                            jTable1.getValueAt(31, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("34",
                    new Object[] { jTable1.getValueAt(32, 0).toString(), jTable1.getValueAt(32, 1).toString(),
                            jTable1.getValueAt(32, 2).toString(), jTable1.getValueAt(32, 3).toString(),
                            jTable1.getValueAt(32, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("35",
                    new Object[] { jTable1.getValueAt(33, 0).toString(), jTable1.getValueAt(33, 1).toString(),
                            jTable1.getValueAt(33, 2).toString(), jTable1.getValueAt(33, 3).toString(),
                            jTable1.getValueAt(33, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("36",
                    new Object[] { jTable1.getValueAt(34, 0).toString(), jTable1.getValueAt(34, 1).toString(),
                            jTable1.getValueAt(34, 2).toString(), jTable1.getValueAt(34, 3).toString(),
                            jTable1.getValueAt(34, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("37",
                    new Object[] { jTable1.getValueAt(35, 0).toString(), jTable1.getValueAt(35, 1).toString(),
                            jTable1.getValueAt(35, 2).toString(), jTable1.getValueAt(35, 3).toString(),
                            jTable1.getValueAt(35, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("38",
                    new Object[] { jTable1.getValueAt(36, 0).toString(), jTable1.getValueAt(36, 1).toString(),
                            jTable1.getValueAt(36, 2).toString(), jTable1.getValueAt(36, 3).toString(),
                            jTable1.getValueAt(36, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("39",
                    new Object[] { jTable1.getValueAt(37, 0).toString(), jTable1.getValueAt(37, 1).toString(),
                            jTable1.getValueAt(37, 2).toString(), jTable1.getValueAt(37, 3).toString(),
                            jTable1.getValueAt(37, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("40",
                    new Object[] { jTable1.getValueAt(38, 0).toString(), jTable1.getValueAt(38, 1).toString(),
                            jTable1.getValueAt(38, 2).toString(), jTable1.getValueAt(38, 3).toString(),
                            jTable1.getValueAt(38, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("41",
                    new Object[] { jTable1.getValueAt(39, 0).toString(), jTable1.getValueAt(39, 1).toString(),
                            jTable1.getValueAt(39, 2).toString(), jTable1.getValueAt(39, 3).toString(),
                            jTable1.getValueAt(39, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("42",
                    new Object[] { jTable1.getValueAt(40, 0).toString(), jTable1.getValueAt(40, 1).toString(),
                            jTable1.getValueAt(40, 2).toString(), jTable1.getValueAt(40, 3).toString(),
                            jTable1.getValueAt(40, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("43",
                    new Object[] { jTable1.getValueAt(41, 0).toString(), jTable1.getValueAt(41, 1).toString(),
                            jTable1.getValueAt(41, 2).toString(), jTable1.getValueAt(41, 3).toString(),
                            jTable1.getValueAt(41, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("44",
                    new Object[] { jTable1.getValueAt(42, 0).toString(), jTable1.getValueAt(42, 1).toString(),
                            jTable1.getValueAt(42, 2).toString(), jTable1.getValueAt(42, 3).toString(),
                            jTable1.getValueAt(42, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("45",
                    new Object[] { jTable1.getValueAt(43, 0).toString(), jTable1.getValueAt(43, 1).toString(),
                            jTable1.getValueAt(43, 2).toString(), jTable1.getValueAt(43, 3).toString(),
                            jTable1.getValueAt(43, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("46",
                    new Object[] { jTable1.getValueAt(44, 0).toString(), jTable1.getValueAt(44, 1).toString(),
                            jTable1.getValueAt(44, 2).toString(), jTable1.getValueAt(44, 3).toString(),
                            jTable1.getValueAt(44, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("47",
                    new Object[] { jTable1.getValueAt(45, 0).toString(), jTable1.getValueAt(45, 1).toString(),
                            jTable1.getValueAt(45, 2).toString(), jTable1.getValueAt(45, 3).toString(),
                            jTable1.getValueAt(45, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("48",
                    new Object[] { jTable1.getValueAt(46, 0).toString(), jTable1.getValueAt(46, 1).toString(),
                            jTable1.getValueAt(46, 2).toString(), jTable1.getValueAt(46, 3).toString(),
                            jTable1.getValueAt(46, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("49",
                    new Object[] { jTable1.getValueAt(47, 0).toString(), jTable1.getValueAt(47, 1).toString(),
                            jTable1.getValueAt(47, 2).toString(), jTable1.getValueAt(47, 3).toString(),
                            jTable1.getValueAt(47, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("50",
                    new Object[] { jTable1.getValueAt(48, 0).toString(), jTable1.getValueAt(48, 1).toString(),
                            jTable1.getValueAt(48, 2).toString(), jTable1.getValueAt(48, 3).toString(),
                            jTable1.getValueAt(48, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("51",
                    new Object[] { jTable1.getValueAt(49, 0).toString(), jTable1.getValueAt(49, 1).toString(),
                            jTable1.getValueAt(49, 2).toString(), jTable1.getValueAt(49, 3).toString(),
                            jTable1.getValueAt(49, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("52",
                    new Object[] { jTable1.getValueAt(50, 0).toString(), jTable1.getValueAt(50, 1).toString(),
                            jTable1.getValueAt(50, 2).toString(), jTable1.getValueAt(50, 3).toString(),
                            jTable1.getValueAt(50, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("53",
                    new Object[] { jTable1.getValueAt(51, 0).toString(), jTable1.getValueAt(51, 1).toString(),
                            jTable1.getValueAt(51, 2).toString(), jTable1.getValueAt(51, 3).toString(),
                            jTable1.getValueAt(51, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("54",
                    new Object[] { jTable1.getValueAt(52, 0).toString(), jTable1.getValueAt(52, 1).toString(),
                            jTable1.getValueAt(52, 2).toString(), jTable1.getValueAt(52, 3).toString(),
                            jTable1.getValueAt(52, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("55",
                    new Object[] { jTable1.getValueAt(53, 0).toString(), jTable1.getValueAt(53, 1).toString(),
                            jTable1.getValueAt(53, 2).toString(), jTable1.getValueAt(53, 3).toString(),
                            jTable1.getValueAt(53, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("56",
                    new Object[] { jTable1.getValueAt(54, 0).toString(), jTable1.getValueAt(54, 1).toString(),
                            jTable1.getValueAt(54, 2).toString(), jTable1.getValueAt(54, 3).toString(),
                            jTable1.getValueAt(54, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("57",
                    new Object[] { jTable1.getValueAt(55, 0).toString(), jTable1.getValueAt(55, 1).toString(),
                            jTable1.getValueAt(55, 2).toString(), jTable1.getValueAt(55, 3).toString(),
                            jTable1.getValueAt(55, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("58",
                    new Object[] { jTable1.getValueAt(56, 0).toString(), jTable1.getValueAt(56, 1).toString(),
                            jTable1.getValueAt(56, 2).toString(), jTable1.getValueAt(56, 3).toString(),
                            jTable1.getValueAt(56, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("59",
                    new Object[] { jTable1.getValueAt(57, 0).toString(), jTable1.getValueAt(57, 1).toString(),
                            jTable1.getValueAt(57, 2).toString(), jTable1.getValueAt(57, 3).toString(),
                            jTable1.getValueAt(57, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("60",
                    new Object[] { jTable1.getValueAt(58, 0).toString(), jTable1.getValueAt(58, 1).toString(),
                            jTable1.getValueAt(58, 2).toString(), jTable1.getValueAt(58, 3).toString(),
                            jTable1.getValueAt(58, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("61",
                    new Object[] { jTable1.getValueAt(59, 0).toString(), jTable1.getValueAt(59, 1).toString(),
                            jTable1.getValueAt(59, 2).toString(), jTable1.getValueAt(59, 3).toString(),
                            jTable1.getValueAt(59, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("62",
                    new Object[] { jTable1.getValueAt(60, 0).toString(), jTable1.getValueAt(60, 1).toString(),
                            jTable1.getValueAt(60, 2).toString(), jTable1.getValueAt(60, 3).toString(),
                            jTable1.getValueAt(60, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("63",
                    new Object[] { jTable1.getValueAt(61, 0).toString(), jTable1.getValueAt(61, 1).toString(),
                            jTable1.getValueAt(61, 2).toString(), jTable1.getValueAt(61, 3).toString(),
                            jTable1.getValueAt(61, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("64",
                    new Object[] { jTable1.getValueAt(62, 0).toString(), jTable1.getValueAt(62, 1).toString(),
                            jTable1.getValueAt(62, 2).toString(), jTable1.getValueAt(62, 3).toString(),
                            jTable1.getValueAt(62, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("65",
                    new Object[] { jTable1.getValueAt(63, 0).toString(), jTable1.getValueAt(63, 1).toString(),
                            jTable1.getValueAt(63, 2).toString(), jTable1.getValueAt(63, 3).toString(),
                            jTable1.getValueAt(63, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("66",
                    new Object[] { jTable1.getValueAt(64, 0).toString(), jTable1.getValueAt(64, 1).toString(),
                            jTable1.getValueAt(64, 2).toString(), jTable1.getValueAt(64, 3).toString(),
                            jTable1.getValueAt(64, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("67",
                    new Object[] { jTable1.getValueAt(65, 0).toString(), jTable1.getValueAt(65, 1).toString(),
                            jTable1.getValueAt(65, 2).toString(), jTable1.getValueAt(65, 3).toString(),
                            jTable1.getValueAt(65, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("68",
                    new Object[] { jTable1.getValueAt(66, 0).toString(), jTable1.getValueAt(66, 1).toString(),
                            jTable1.getValueAt(66, 2).toString(), jTable1.getValueAt(66, 3).toString(),
                            jTable1.getValueAt(66, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("69",
                    new Object[] { jTable1.getValueAt(67, 0).toString(), jTable1.getValueAt(67, 1).toString(),
                            jTable1.getValueAt(67, 2).toString(), jTable1.getValueAt(67, 3).toString(),
                            jTable1.getValueAt(67, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("70",
                    new Object[] { jTable1.getValueAt(68, 0).toString(), jTable1.getValueAt(68, 1).toString(),
                            jTable1.getValueAt(68, 2).toString(), jTable1.getValueAt(68, 3).toString(),
                            jTable1.getValueAt(68, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("71",
                    new Object[] { jTable1.getValueAt(69, 0).toString(), jTable1.getValueAt(69, 1).toString(),
                            jTable1.getValueAt(69, 2).toString(), jTable1.getValueAt(69, 3).toString(),
                            jTable1.getValueAt(69, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("72",
                    new Object[] { jTable1.getValueAt(70, 0).toString(), jTable1.getValueAt(70, 1).toString(),
                            jTable1.getValueAt(70, 2).toString(), jTable1.getValueAt(70, 3).toString(),
                            jTable1.getValueAt(70, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("73",
                    new Object[] { jTable1.getValueAt(71, 0).toString(), jTable1.getValueAt(71, 1).toString(),
                            jTable1.getValueAt(71, 2).toString(), jTable1.getValueAt(71, 3).toString(),
                            jTable1.getValueAt(71, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("74",
                    new Object[] { jTable1.getValueAt(72, 0).toString(), jTable1.getValueAt(72, 1).toString(),
                            jTable1.getValueAt(72, 2).toString(), jTable1.getValueAt(72, 3).toString(),
                            jTable1.getValueAt(72, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("75",
                    new Object[] { jTable1.getValueAt(73, 0).toString(), jTable1.getValueAt(73, 1).toString(),
                            jTable1.getValueAt(73, 2).toString(), jTable1.getValueAt(73, 3).toString(),
                            jTable1.getValueAt(73, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("76",
                    new Object[] { jTable1.getValueAt(74, 0).toString(), jTable1.getValueAt(74, 1).toString(),
                            jTable1.getValueAt(74, 2).toString(), jTable1.getValueAt(74, 3).toString(),
                            jTable1.getValueAt(74, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("77",
                    new Object[] { jTable1.getValueAt(75, 0).toString(), jTable1.getValueAt(75, 1).toString(),
                            jTable1.getValueAt(75, 2).toString(), jTable1.getValueAt(75, 3).toString(),
                            jTable1.getValueAt(75, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("78",
                    new Object[] { jTable1.getValueAt(76, 0).toString(), jTable1.getValueAt(76, 1).toString(),
                            jTable1.getValueAt(76, 2).toString(), jTable1.getValueAt(76, 3).toString(),
                            jTable1.getValueAt(76, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("79",
                    new Object[] { jTable1.getValueAt(77, 0).toString(), jTable1.getValueAt(77, 1).toString(),
                            jTable1.getValueAt(77, 2).toString(), jTable1.getValueAt(77, 3).toString(),
                            jTable1.getValueAt(77, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("80",
                    new Object[] { jTable1.getValueAt(78, 0).toString(), jTable1.getValueAt(78, 1).toString(),
                            jTable1.getValueAt(78, 2).toString(), jTable1.getValueAt(78, 3).toString(),
                            jTable1.getValueAt(78, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("81",
                    new Object[] { jTable1.getValueAt(79, 0).toString(), jTable1.getValueAt(79, 1).toString(),
                            jTable1.getValueAt(79, 2).toString(), jTable1.getValueAt(79, 3).toString(),
                            jTable1.getValueAt(79, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("82",
                    new Object[] { jTable1.getValueAt(80, 0).toString(), jTable1.getValueAt(80, 1).toString(),
                            jTable1.getValueAt(80, 2).toString(), jTable1.getValueAt(80, 3).toString(),
                            jTable1.getValueAt(80, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("83",
                    new Object[] { jTable1.getValueAt(81, 0).toString(), jTable1.getValueAt(81, 1).toString(),
                            jTable1.getValueAt(81, 2).toString(), jTable1.getValueAt(81, 3).toString(),
                            jTable1.getValueAt(81, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("84",
                    new Object[] { jTable1.getValueAt(82, 0).toString(), jTable1.getValueAt(82, 1).toString(),
                            jTable1.getValueAt(82, 2).toString(), jTable1.getValueAt(82, 3).toString(),
                            jTable1.getValueAt(82, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("85",
                    new Object[] { jTable1.getValueAt(83, 0).toString(), jTable1.getValueAt(83, 1).toString(),
                            jTable1.getValueAt(83, 2).toString(), jTable1.getValueAt(83, 3).toString(),
                            jTable1.getValueAt(83, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("86",
                    new Object[] { jTable1.getValueAt(84, 0).toString(), jTable1.getValueAt(84, 1).toString(),
                            jTable1.getValueAt(84, 2).toString(), jTable1.getValueAt(84, 3).toString(),
                            jTable1.getValueAt(84, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("87",
                    new Object[] { jTable1.getValueAt(85, 0).toString(), jTable1.getValueAt(85, 1).toString(),
                            jTable1.getValueAt(85, 2).toString(), jTable1.getValueAt(85, 3).toString(),
                            jTable1.getValueAt(85, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("88",
                    new Object[] { jTable1.getValueAt(86, 0).toString(), jTable1.getValueAt(86, 1).toString(),
                            jTable1.getValueAt(86, 2).toString(), jTable1.getValueAt(86, 3).toString(),
                            jTable1.getValueAt(86, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("89",
                    new Object[] { jTable1.getValueAt(87, 0).toString(), jTable1.getValueAt(87, 1).toString(),
                            jTable1.getValueAt(87, 2).toString(), jTable1.getValueAt(87, 3).toString(),
                            jTable1.getValueAt(87, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("90",
                    new Object[] { jTable1.getValueAt(88, 0).toString(), jTable1.getValueAt(88, 1).toString(),
                            jTable1.getValueAt(88, 2).toString(), jTable1.getValueAt(88, 3).toString(),
                            jTable1.getValueAt(88, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("91",
                    new Object[] { jTable1.getValueAt(89, 0).toString(), jTable1.getValueAt(89, 1).toString(),
                            jTable1.getValueAt(89, 2).toString(), jTable1.getValueAt(89, 3).toString(),
                            jTable1.getValueAt(89, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("92",
                    new Object[] { jTable1.getValueAt(90, 0).toString(), jTable1.getValueAt(90, 1).toString(),
                            jTable1.getValueAt(90, 2).toString(), jTable1.getValueAt(90, 3).toString(),
                            jTable1.getValueAt(90, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("93",
                    new Object[] { jTable1.getValueAt(91, 0).toString(), jTable1.getValueAt(91, 1).toString(),
                            jTable1.getValueAt(91, 2).toString(), jTable1.getValueAt(91, 3).toString(),
                            jTable1.getValueAt(91, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("94",
                    new Object[] { jTable1.getValueAt(92, 0).toString(), jTable1.getValueAt(92, 1).toString(),
                            jTable1.getValueAt(92, 2).toString(), jTable1.getValueAt(92, 3).toString(),
                            jTable1.getValueAt(92, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("95",
                    new Object[] { jTable1.getValueAt(93, 0).toString(), jTable1.getValueAt(93, 1).toString(),
                            jTable1.getValueAt(93, 2).toString(), jTable1.getValueAt(93, 3).toString(),
                            jTable1.getValueAt(93, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("96",
                    new Object[] { jTable1.getValueAt(94, 0).toString(), jTable1.getValueAt(94, 1).toString(),
                            jTable1.getValueAt(94, 2).toString(), jTable1.getValueAt(94, 3).toString(),
                            jTable1.getValueAt(94, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("97",
                    new Object[] { jTable1.getValueAt(95, 0).toString(), jTable1.getValueAt(95, 1).toString(),
                            jTable1.getValueAt(95, 2).toString(), jTable1.getValueAt(95, 3).toString(),
                            jTable1.getValueAt(95, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("98",
                    new Object[] { jTable1.getValueAt(96, 0).toString(), jTable1.getValueAt(96, 1).toString(),
                            jTable1.getValueAt(96, 2).toString(), jTable1.getValueAt(96, 3).toString(),
                            jTable1.getValueAt(96, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("99",
                    new Object[] { jTable1.getValueAt(97, 0).toString(), jTable1.getValueAt(97, 1).toString(),
                            jTable1.getValueAt(97, 2).toString(), jTable1.getValueAt(97, 3).toString(),
                            jTable1.getValueAt(97, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("100",
                    new Object[] { jTable1.getValueAt(98, 0).toString(), jTable1.getValueAt(98, 1).toString(),
                            jTable1.getValueAt(98, 2).toString(), jTable1.getValueAt(98, 3).toString(),
                            jTable1.getValueAt(98, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("101",
                    new Object[] { jTable1.getValueAt(99, 0).toString(), jTable1.getValueAt(99, 1).toString(),
                            jTable1.getValueAt(99, 2).toString(), jTable1.getValueAt(99, 3).toString(),
                            jTable1.getValueAt(99, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("102",
                    new Object[] { jTable1.getValueAt(100, 0).toString(), jTable1.getValueAt(100, 1).toString(),
                            jTable1.getValueAt(100, 2).toString(), jTable1.getValueAt(100, 3).toString(),
                            jTable1.getValueAt(100, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("103",
                    new Object[] { jTable1.getValueAt(101, 0).toString(), jTable1.getValueAt(101, 1).toString(),
                            jTable1.getValueAt(101, 2).toString(), jTable1.getValueAt(101, 3).toString(),
                            jTable1.getValueAt(101, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("104",
                    new Object[] { jTable1.getValueAt(102, 0).toString(), jTable1.getValueAt(102, 1).toString(),
                            jTable1.getValueAt(102, 2).toString(), jTable1.getValueAt(102, 3).toString(),
                            jTable1.getValueAt(102, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("105",
                    new Object[] { jTable1.getValueAt(103, 0).toString(), jTable1.getValueAt(103, 1).toString(),
                            jTable1.getValueAt(103, 2).toString(), jTable1.getValueAt(103, 3).toString(),
                            jTable1.getValueAt(103, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("106",
                    new Object[] { jTable1.getValueAt(104, 0).toString(), jTable1.getValueAt(104, 1).toString(),
                            jTable1.getValueAt(104, 2).toString(), jTable1.getValueAt(104, 3).toString(),
                            jTable1.getValueAt(104, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("107",
                    new Object[] { jTable1.getValueAt(105, 0).toString(), jTable1.getValueAt(105, 1).toString(),
                            jTable1.getValueAt(105, 2).toString(), jTable1.getValueAt(105, 3).toString(),
                            jTable1.getValueAt(105, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("108",
                    new Object[] { jTable1.getValueAt(106, 0).toString(), jTable1.getValueAt(106, 1).toString(),
                            jTable1.getValueAt(106, 2).toString(), jTable1.getValueAt(106, 3).toString(),
                            jTable1.getValueAt(106, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("109",
                    new Object[] { jTable1.getValueAt(107, 0).toString(), jTable1.getValueAt(107, 1).toString(),
                            jTable1.getValueAt(107, 2).toString(), jTable1.getValueAt(107, 3).toString(),
                            jTable1.getValueAt(107, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("110",
                    new Object[] { jTable1.getValueAt(108, 0).toString(), jTable1.getValueAt(108, 1).toString(),
                            jTable1.getValueAt(108, 2).toString(), jTable1.getValueAt(108, 3).toString(),
                            jTable1.getValueAt(108, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("111",
                    new Object[] { jTable1.getValueAt(109, 0).toString(), jTable1.getValueAt(109, 1).toString(),
                            jTable1.getValueAt(109, 2).toString(), jTable1.getValueAt(109, 3).toString(),
                            jTable1.getValueAt(109, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("112",
                    new Object[] { jTable1.getValueAt(110, 0).toString(), jTable1.getValueAt(110, 1).toString(),
                            jTable1.getValueAt(110, 2).toString(), jTable1.getValueAt(110, 3).toString(),
                            jTable1.getValueAt(110, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("113",
                    new Object[] { jTable1.getValueAt(111, 0).toString(), jTable1.getValueAt(111, 1).toString(),
                            jTable1.getValueAt(111, 2).toString(), jTable1.getValueAt(111, 3).toString(),
                            jTable1.getValueAt(111, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("114",
                    new Object[] { jTable1.getValueAt(112, 0).toString(), jTable1.getValueAt(112, 1).toString(),
                            jTable1.getValueAt(112, 2).toString(), jTable1.getValueAt(112, 3).toString(),
                            jTable1.getValueAt(112, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("115",
                    new Object[] { jTable1.getValueAt(113, 0).toString(), jTable1.getValueAt(113, 1).toString(),
                            jTable1.getValueAt(113, 2).toString(), jTable1.getValueAt(113, 3).toString(),
                            jTable1.getValueAt(113, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("116",
                    new Object[] { jTable1.getValueAt(114, 0).toString(), jTable1.getValueAt(114, 1).toString(),
                            jTable1.getValueAt(114, 2).toString(), jTable1.getValueAt(114, 3).toString(),
                            jTable1.getValueAt(114, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("117",
                    new Object[] { jTable1.getValueAt(115, 0).toString(), jTable1.getValueAt(115, 1).toString(),
                            jTable1.getValueAt(115, 2).toString(), jTable1.getValueAt(115, 3).toString(),
                            jTable1.getValueAt(115, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("118",
                    new Object[] { jTable1.getValueAt(116, 0).toString(), jTable1.getValueAt(116, 1).toString(),
                            jTable1.getValueAt(116, 2).toString(), jTable1.getValueAt(116, 3).toString(),
                            jTable1.getValueAt(116, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("119",
                    new Object[] { jTable1.getValueAt(117, 0).toString(), jTable1.getValueAt(117, 1).toString(),
                            jTable1.getValueAt(117, 2).toString(), jTable1.getValueAt(117, 3).toString(),
                            jTable1.getValueAt(117, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("120",
                    new Object[] { jTable1.getValueAt(118, 0).toString(), jTable1.getValueAt(118, 1).toString(),
                            jTable1.getValueAt(118, 2).toString(), jTable1.getValueAt(118, 3).toString(),
                            jTable1.getValueAt(118, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("121",
                    new Object[] { jTable1.getValueAt(119, 0).toString(), jTable1.getValueAt(119, 1).toString(),
                            jTable1.getValueAt(119, 2).toString(), jTable1.getValueAt(119, 3).toString(),
                            jTable1.getValueAt(119, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("122",
                    new Object[] { jTable1.getValueAt(120, 0).toString(), jTable1.getValueAt(120, 1).toString(),
                            jTable1.getValueAt(120, 2).toString(), jTable1.getValueAt(120, 3).toString(),
                            jTable1.getValueAt(120, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("123",
                    new Object[] { jTable1.getValueAt(121, 0).toString(), jTable1.getValueAt(121, 1).toString(),
                            jTable1.getValueAt(121, 2).toString(), jTable1.getValueAt(121, 3).toString(),
                            jTable1.getValueAt(121, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("124",
                    new Object[] { jTable1.getValueAt(122, 0).toString(), jTable1.getValueAt(122, 1).toString(),
                            jTable1.getValueAt(122, 2).toString(), jTable1.getValueAt(122, 3).toString(),
                            jTable1.getValueAt(122, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("125",
                    new Object[] { jTable1.getValueAt(123, 0).toString(), jTable1.getValueAt(123, 1).toString(),
                            jTable1.getValueAt(123, 2).toString(), jTable1.getValueAt(123, 3).toString(),
                            jTable1.getValueAt(123, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("126",
                    new Object[] { jTable1.getValueAt(124, 0).toString(), jTable1.getValueAt(124, 1).toString(),
                            jTable1.getValueAt(124, 2).toString(), jTable1.getValueAt(124, 3).toString(),
                            jTable1.getValueAt(124, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("127",
                    new Object[] { jTable1.getValueAt(125, 0).toString(), jTable1.getValueAt(125, 1).toString(),
                            jTable1.getValueAt(125, 2).toString(), jTable1.getValueAt(125, 3).toString(),
                            jTable1.getValueAt(125, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("128",
                    new Object[] { jTable1.getValueAt(126, 0).toString(), jTable1.getValueAt(126, 1).toString(),
                            jTable1.getValueAt(126, 2).toString(), jTable1.getValueAt(126, 3).toString(),
                            jTable1.getValueAt(126, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("129",
                    new Object[] { jTable1.getValueAt(127, 0).toString(), jTable1.getValueAt(127, 1).toString(),
                            jTable1.getValueAt(127, 2).toString(), jTable1.getValueAt(127, 3).toString(),
                            jTable1.getValueAt(127, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("130",
                    new Object[] { jTable1.getValueAt(128, 0).toString(), jTable1.getValueAt(128, 1).toString(),
                            jTable1.getValueAt(128, 2).toString(), jTable1.getValueAt(128, 3).toString(),
                            jTable1.getValueAt(128, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("131",
                    new Object[] { jTable1.getValueAt(129, 0).toString(), jTable1.getValueAt(129, 1).toString(),
                            jTable1.getValueAt(129, 2).toString(), jTable1.getValueAt(129, 3).toString(),
                            jTable1.getValueAt(129, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("132",
                    new Object[] { jTable1.getValueAt(130, 0).toString(), jTable1.getValueAt(130, 1).toString(),
                            jTable1.getValueAt(130, 2).toString(), jTable1.getValueAt(130, 3).toString(),
                            jTable1.getValueAt(130, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("133",
                    new Object[] { jTable1.getValueAt(131, 0).toString(), jTable1.getValueAt(131, 1).toString(),
                            jTable1.getValueAt(131, 2).toString(), jTable1.getValueAt(131, 3).toString(),
                            jTable1.getValueAt(131, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("134",
                    new Object[] { jTable1.getValueAt(132, 0).toString(), jTable1.getValueAt(132, 1).toString(),
                            jTable1.getValueAt(132, 2).toString(), jTable1.getValueAt(132, 3).toString(),
                            jTable1.getValueAt(132, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("135",
                    new Object[] { jTable1.getValueAt(133, 0).toString(), jTable1.getValueAt(133, 1).toString(),
                            jTable1.getValueAt(133, 2).toString(), jTable1.getValueAt(133, 3).toString(),
                            jTable1.getValueAt(133, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("136",
                    new Object[] { jTable1.getValueAt(134, 0).toString(), jTable1.getValueAt(134, 1).toString(),
                            jTable1.getValueAt(134, 2).toString(), jTable1.getValueAt(134, 3).toString(),
                            jTable1.getValueAt(134, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("137",
                    new Object[] { jTable1.getValueAt(135, 0).toString(), jTable1.getValueAt(135, 1).toString(),
                            jTable1.getValueAt(135, 2).toString(), jTable1.getValueAt(135, 3).toString(),
                            jTable1.getValueAt(135, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("138",
                    new Object[] { jTable1.getValueAt(136, 0).toString(), jTable1.getValueAt(136, 1).toString(),
                            jTable1.getValueAt(136, 2).toString(), jTable1.getValueAt(136, 3).toString(),
                            jTable1.getValueAt(136, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("139",
                    new Object[] { jTable1.getValueAt(137, 0).toString(), jTable1.getValueAt(137, 1).toString(),
                            jTable1.getValueAt(137, 2).toString(), jTable1.getValueAt(137, 3).toString(),
                            jTable1.getValueAt(137, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("140",
                    new Object[] { jTable1.getValueAt(138, 0).toString(), jTable1.getValueAt(138, 1).toString(),
                            jTable1.getValueAt(138, 2).toString(), jTable1.getValueAt(138, 3).toString(),
                            jTable1.getValueAt(138, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("141",
                    new Object[] { jTable1.getValueAt(139, 0).toString(), jTable1.getValueAt(139, 1).toString(),
                            jTable1.getValueAt(139, 2).toString(), jTable1.getValueAt(139, 3).toString(),
                            jTable1.getValueAt(139, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("142",
                    new Object[] { jTable1.getValueAt(140, 0).toString(), jTable1.getValueAt(140, 1).toString(),
                            jTable1.getValueAt(140, 2).toString(), jTable1.getValueAt(140, 3).toString(),
                            jTable1.getValueAt(140, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("143",
                    new Object[] { jTable1.getValueAt(141, 0).toString(), jTable1.getValueAt(141, 1).toString(),
                            jTable1.getValueAt(141, 2).toString(), jTable1.getValueAt(141, 3).toString(),
                            jTable1.getValueAt(141, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("144",
                    new Object[] { jTable1.getValueAt(142, 0).toString(), jTable1.getValueAt(142, 1).toString(),
                            jTable1.getValueAt(142, 2).toString(), jTable1.getValueAt(142, 3).toString(),
                            jTable1.getValueAt(142, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("145",
                    new Object[] { jTable1.getValueAt(143, 0).toString(), jTable1.getValueAt(143, 1).toString(),
                            jTable1.getValueAt(143, 2).toString(), jTable1.getValueAt(143, 3).toString(),
                            jTable1.getValueAt(143, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("146",
                    new Object[] { jTable1.getValueAt(144, 0).toString(), jTable1.getValueAt(144, 1).toString(),
                            jTable1.getValueAt(144, 2).toString(), jTable1.getValueAt(144, 3).toString(),
                            jTable1.getValueAt(144, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("147",
                    new Object[] { jTable1.getValueAt(145, 0).toString(), jTable1.getValueAt(145, 1).toString(),
                            jTable1.getValueAt(145, 2).toString(), jTable1.getValueAt(145, 3).toString(),
                            jTable1.getValueAt(145, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("148",
                    new Object[] { jTable1.getValueAt(146, 0).toString(), jTable1.getValueAt(146, 1).toString(),
                            jTable1.getValueAt(146, 2).toString(), jTable1.getValueAt(146, 3).toString(),
                            jTable1.getValueAt(146, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("149",
                    new Object[] { jTable1.getValueAt(147, 0).toString(), jTable1.getValueAt(147, 1).toString(),
                            jTable1.getValueAt(147, 2).toString(), jTable1.getValueAt(147, 3).toString(),
                            jTable1.getValueAt(147, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("150",
                    new Object[] { jTable1.getValueAt(148, 0).toString(), jTable1.getValueAt(148, 1).toString(),
                            jTable1.getValueAt(148, 2).toString(), jTable1.getValueAt(148, 3).toString(),
                            jTable1.getValueAt(148, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("151",
                    new Object[] { jTable1.getValueAt(149, 0).toString(), jTable1.getValueAt(149, 1).toString(),
                            jTable1.getValueAt(149, 2).toString(), jTable1.getValueAt(149, 3).toString(),
                            jTable1.getValueAt(149, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("152",
                    new Object[] { jTable1.getValueAt(150, 0).toString(), jTable1.getValueAt(150, 1).toString(),
                            jTable1.getValueAt(150, 2).toString(), jTable1.getValueAt(150, 3).toString(),
                            jTable1.getValueAt(150, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("153",
                    new Object[] { jTable1.getValueAt(151, 0).toString(), jTable1.getValueAt(151, 1).toString(),
                            jTable1.getValueAt(151, 2).toString(), jTable1.getValueAt(151, 3).toString(),
                            jTable1.getValueAt(151, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("154",
                    new Object[] { jTable1.getValueAt(152, 0).toString(), jTable1.getValueAt(152, 1).toString(),
                            jTable1.getValueAt(152, 2).toString(), jTable1.getValueAt(152, 3).toString(),
                            jTable1.getValueAt(152, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("155",
                    new Object[] { jTable1.getValueAt(153, 0).toString(), jTable1.getValueAt(153, 1).toString(),
                            jTable1.getValueAt(153, 2).toString(), jTable1.getValueAt(153, 3).toString(),
                            jTable1.getValueAt(153, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("156",
                    new Object[] { jTable1.getValueAt(154, 0).toString(), jTable1.getValueAt(154, 1).toString(),
                            jTable1.getValueAt(154, 2).toString(), jTable1.getValueAt(154, 3).toString(),
                            jTable1.getValueAt(154, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("157",
                    new Object[] { jTable1.getValueAt(155, 0).toString(), jTable1.getValueAt(155, 1).toString(),
                            jTable1.getValueAt(155, 2).toString(), jTable1.getValueAt(155, 3).toString(),
                            jTable1.getValueAt(155, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("158",
                    new Object[] { jTable1.getValueAt(156, 0).toString(), jTable1.getValueAt(156, 1).toString(),
                            jTable1.getValueAt(156, 2).toString(), jTable1.getValueAt(156, 3).toString(),
                            jTable1.getValueAt(156, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("159",
                    new Object[] { jTable1.getValueAt(157, 0).toString(), jTable1.getValueAt(157, 1).toString(),
                            jTable1.getValueAt(157, 2).toString(), jTable1.getValueAt(157, 3).toString(),
                            jTable1.getValueAt(157, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("160",
                    new Object[] { jTable1.getValueAt(158, 0).toString(), jTable1.getValueAt(158, 1).toString(),
                            jTable1.getValueAt(158, 2).toString(), jTable1.getValueAt(158, 3).toString(),
                            jTable1.getValueAt(158, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("161",
                    new Object[] { jTable1.getValueAt(159, 0).toString(), jTable1.getValueAt(159, 1).toString(),
                            jTable1.getValueAt(159, 2).toString(), jTable1.getValueAt(159, 3).toString(),
                            jTable1.getValueAt(159, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("162",
                    new Object[] { jTable1.getValueAt(160, 0).toString(), jTable1.getValueAt(160, 1).toString(),
                            jTable1.getValueAt(160, 2).toString(), jTable1.getValueAt(160, 3).toString(),
                            jTable1.getValueAt(160, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("163",
                    new Object[] { jTable1.getValueAt(161, 0).toString(), jTable1.getValueAt(161, 1).toString(),
                            jTable1.getValueAt(161, 2).toString(), jTable1.getValueAt(161, 3).toString(),
                            jTable1.getValueAt(161, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("164",
                    new Object[] { jTable1.getValueAt(162, 0).toString(), jTable1.getValueAt(162, 1).toString(),
                            jTable1.getValueAt(162, 2).toString(), jTable1.getValueAt(162, 3).toString(),
                            jTable1.getValueAt(162, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("165",
                    new Object[] { jTable1.getValueAt(163, 0).toString(), jTable1.getValueAt(163, 1).toString(),
                            jTable1.getValueAt(163, 2).toString(), jTable1.getValueAt(163, 3).toString(),
                            jTable1.getValueAt(163, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("166",
                    new Object[] { jTable1.getValueAt(164, 0).toString(), jTable1.getValueAt(164, 1).toString(),
                            jTable1.getValueAt(164, 2).toString(), jTable1.getValueAt(164, 3).toString(),
                            jTable1.getValueAt(164, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("167",
                    new Object[] { jTable1.getValueAt(165, 0).toString(), jTable1.getValueAt(165, 1).toString(),
                            jTable1.getValueAt(165, 2).toString(), jTable1.getValueAt(165, 3).toString(),
                            jTable1.getValueAt(165, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("168",
                    new Object[] { jTable1.getValueAt(166, 0).toString(), jTable1.getValueAt(166, 1).toString(),
                            jTable1.getValueAt(166, 2).toString(), jTable1.getValueAt(166, 3).toString(),
                            jTable1.getValueAt(166, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("169",
                    new Object[] { jTable1.getValueAt(167, 0).toString(), jTable1.getValueAt(167, 1).toString(),
                            jTable1.getValueAt(167, 2).toString(), jTable1.getValueAt(167, 3).toString(),
                            jTable1.getValueAt(167, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("170",
                    new Object[] { jTable1.getValueAt(168, 0).toString(), jTable1.getValueAt(168, 1).toString(),
                            jTable1.getValueAt(168, 2).toString(), jTable1.getValueAt(168, 3).toString(),
                            jTable1.getValueAt(168, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("171",
                    new Object[] { jTable1.getValueAt(169, 0).toString(), jTable1.getValueAt(169, 1).toString(),
                            jTable1.getValueAt(169, 2).toString(), jTable1.getValueAt(169, 3).toString(),
                            jTable1.getValueAt(169, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("172",
                    new Object[] { jTable1.getValueAt(170, 0).toString(), jTable1.getValueAt(170, 1).toString(),
                            jTable1.getValueAt(170, 2).toString(), jTable1.getValueAt(170, 3).toString(),
                            jTable1.getValueAt(170, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("173",
                    new Object[] { jTable1.getValueAt(171, 0).toString(), jTable1.getValueAt(171, 1).toString(),
                            jTable1.getValueAt(171, 2).toString(), jTable1.getValueAt(171, 3).toString(),
                            jTable1.getValueAt(171, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("174",
                    new Object[] { jTable1.getValueAt(172, 0).toString(), jTable1.getValueAt(172, 1).toString(),
                            jTable1.getValueAt(172, 2).toString(), jTable1.getValueAt(172, 3).toString(),
                            jTable1.getValueAt(172, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("175",
                    new Object[] { jTable1.getValueAt(173, 0).toString(), jTable1.getValueAt(173, 1).toString(),
                            jTable1.getValueAt(173, 2).toString(), jTable1.getValueAt(173, 3).toString(),
                            jTable1.getValueAt(173, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("176",
                    new Object[] { jTable1.getValueAt(174, 0).toString(), jTable1.getValueAt(174, 1).toString(),
                            jTable1.getValueAt(174, 2).toString(), jTable1.getValueAt(174, 3).toString(),
                            jTable1.getValueAt(174, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("177",
                    new Object[] { jTable1.getValueAt(175, 0).toString(), jTable1.getValueAt(175, 1).toString(),
                            jTable1.getValueAt(175, 2).toString(), jTable1.getValueAt(175, 3).toString(),
                            jTable1.getValueAt(175, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("178",
                    new Object[] { jTable1.getValueAt(176, 0).toString(), jTable1.getValueAt(176, 1).toString(),
                            jTable1.getValueAt(176, 2).toString(), jTable1.getValueAt(176, 3).toString(),
                            jTable1.getValueAt(176, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("179",
                    new Object[] { jTable1.getValueAt(177, 0).toString(), jTable1.getValueAt(177, 1).toString(),
                            jTable1.getValueAt(177, 2).toString(), jTable1.getValueAt(177, 3).toString(),
                            jTable1.getValueAt(177, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("180",
                    new Object[] { jTable1.getValueAt(178, 0).toString(), jTable1.getValueAt(178, 1).toString(),
                            jTable1.getValueAt(178, 2).toString(), jTable1.getValueAt(178, 3).toString(),
                            jTable1.getValueAt(178, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("181",
                    new Object[] { jTable1.getValueAt(179, 0).toString(), jTable1.getValueAt(179, 1).toString(),
                            jTable1.getValueAt(179, 2).toString(), jTable1.getValueAt(179, 3).toString(),
                            jTable1.getValueAt(179, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("182",
                    new Object[] { jTable1.getValueAt(180, 0).toString(), jTable1.getValueAt(180, 1).toString(),
                            jTable1.getValueAt(180, 2).toString(), jTable1.getValueAt(180, 3).toString(),
                            jTable1.getValueAt(180, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("183",
                    new Object[] { jTable1.getValueAt(181, 0).toString(), jTable1.getValueAt(181, 1).toString(),
                            jTable1.getValueAt(181, 2).toString(), jTable1.getValueAt(181, 3).toString(),
                            jTable1.getValueAt(181, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("184",
                    new Object[] { jTable1.getValueAt(182, 0).toString(), jTable1.getValueAt(182, 1).toString(),
                            jTable1.getValueAt(182, 2).toString(), jTable1.getValueAt(182, 3).toString(),
                            jTable1.getValueAt(182, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("185",
                    new Object[] { jTable1.getValueAt(183, 0).toString(), jTable1.getValueAt(183, 1).toString(),
                            jTable1.getValueAt(183, 2).toString(), jTable1.getValueAt(183, 3).toString(),
                            jTable1.getValueAt(183, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("186",
                    new Object[] { jTable1.getValueAt(184, 0).toString(), jTable1.getValueAt(184, 1).toString(),
                            jTable1.getValueAt(184, 2).toString(), jTable1.getValueAt(184, 3).toString(),
                            jTable1.getValueAt(184, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("187",
                    new Object[] { jTable1.getValueAt(185, 0).toString(), jTable1.getValueAt(185, 1).toString(),
                            jTable1.getValueAt(185, 2).toString(), jTable1.getValueAt(185, 3).toString(),
                            jTable1.getValueAt(185, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("188",
                    new Object[] { jTable1.getValueAt(186, 0).toString(), jTable1.getValueAt(186, 1).toString(),
                            jTable1.getValueAt(186, 2).toString(), jTable1.getValueAt(186, 3).toString(),
                            jTable1.getValueAt(186, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("189",
                    new Object[] { jTable1.getValueAt(187, 0).toString(), jTable1.getValueAt(187, 1).toString(),
                            jTable1.getValueAt(187, 2).toString(), jTable1.getValueAt(187, 3).toString(),
                            jTable1.getValueAt(187, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("190",
                    new Object[] { jTable1.getValueAt(188, 0).toString(), jTable1.getValueAt(188, 1).toString(),
                            jTable1.getValueAt(188, 2).toString(), jTable1.getValueAt(188, 3).toString(),
                            jTable1.getValueAt(188, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("191",
                    new Object[] { jTable1.getValueAt(189, 0).toString(), jTable1.getValueAt(189, 1).toString(),
                            jTable1.getValueAt(189, 2).toString(), jTable1.getValueAt(189, 3).toString(),
                            jTable1.getValueAt(189, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("192",
                    new Object[] { jTable1.getValueAt(190, 0).toString(), jTable1.getValueAt(190, 1).toString(),
                            jTable1.getValueAt(190, 2).toString(), jTable1.getValueAt(190, 3).toString(),
                            jTable1.getValueAt(190, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("193",
                    new Object[] { jTable1.getValueAt(191, 0).toString(), jTable1.getValueAt(191, 1).toString(),
                            jTable1.getValueAt(191, 2).toString(), jTable1.getValueAt(191, 3).toString(),
                            jTable1.getValueAt(191, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("194",
                    new Object[] { jTable1.getValueAt(192, 0).toString(), jTable1.getValueAt(192, 1).toString(),
                            jTable1.getValueAt(192, 2).toString(), jTable1.getValueAt(192, 3).toString(),
                            jTable1.getValueAt(192, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("195",
                    new Object[] { jTable1.getValueAt(193, 0).toString(), jTable1.getValueAt(193, 1).toString(),
                            jTable1.getValueAt(193, 2).toString(), jTable1.getValueAt(193, 3).toString(),
                            jTable1.getValueAt(193, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("196",
                    new Object[] { jTable1.getValueAt(194, 0).toString(), jTable1.getValueAt(194, 1).toString(),
                            jTable1.getValueAt(194, 2).toString(), jTable1.getValueAt(194, 3).toString(),
                            jTable1.getValueAt(194, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("197",
                    new Object[] { jTable1.getValueAt(195, 0).toString(), jTable1.getValueAt(195, 1).toString(),
                            jTable1.getValueAt(195, 2).toString(), jTable1.getValueAt(195, 3).toString(),
                            jTable1.getValueAt(195, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("198",
                    new Object[] { jTable1.getValueAt(196, 0).toString(), jTable1.getValueAt(196, 1).toString(),
                            jTable1.getValueAt(196, 2).toString(), jTable1.getValueAt(196, 3).toString(),
                            jTable1.getValueAt(196, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("199",
                    new Object[] { jTable1.getValueAt(197, 0).toString(), jTable1.getValueAt(197, 1).toString(),
                            jTable1.getValueAt(197, 2).toString(), jTable1.getValueAt(197, 3).toString(),
                            jTable1.getValueAt(197, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("200",
                    new Object[] { jTable1.getValueAt(198, 0).toString(), jTable1.getValueAt(198, 1).toString(),
                            jTable1.getValueAt(198, 2).toString(), jTable1.getValueAt(198, 3).toString(),
                            jTable1.getValueAt(198, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("201",
                    new Object[] { jTable1.getValueAt(199, 0).toString(), jTable1.getValueAt(199, 1).toString(),
                            jTable1.getValueAt(199, 2).toString(), jTable1.getValueAt(199, 3).toString(),
                            jTable1.getValueAt(199, 4).toString() });
            i++;
        }

        else
            break;

    }

    Set<String> keyset = data.keySet();
    int rownum = 0;
    for (String key : keyset) {
        Row row = sheet.createRow(rownum++);
        Object[] objArr = data.get(key);
        int cellnum = 0;
        for (Object obj : objArr) {
            XSSFCell cell = (XSSFCell) row.createCell(cellnum++);
            if (obj instanceof String)
                cell.setCellValue((String) obj);
            else if (obj instanceof Integer)
                cell.setCellValue((Integer) obj);
        }
    }
    try {
        //Write the workbook in file system

        FileOutputStream out = new FileOutputStream(new File(filename + ".xlsx"));
        workbook.write(out);
        out.close();
        JOptionPane.showMessageDialog(null, "Data exported to excel sheet");
    } catch (Exception e) {
        e.printStackTrace();
    }
}

---

From source file:mymoney.view.java

private void jButton5ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton5ActionPerformed
    JFileChooser cho = new JFileChooser();
    cho.showSaveDialog(null);//ww  w  .  j  a  v a2s . co m
    File f = cho.getSelectedFile();
    String filename = f.getAbsolutePath();
    DefaultTableModel model = (DefaultTableModel) jTable1.getModel();
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet("New Data");
    TreeMap<String, Object[]> data = new TreeMap<String, Object[]>();

    data.put("1", new Object[] { "DATE", "NAME", "AMOUNT", "CATEGORY", "TYPE" });
    for (int i = 0;;) {
        if (jTable1.getRowCount() != i) {
            data.put("2",
                    new Object[] { jTable1.getValueAt(0, 0).toString(), jTable1.getValueAt(0, 1).toString(),
                            jTable1.getValueAt(0, 2).toString(), jTable1.getValueAt(0, 3).toString(),
                            jTable1.getValueAt(0, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("3",
                    new Object[] { jTable1.getValueAt(1, 0).toString(), jTable1.getValueAt(1, 1).toString(),
                            jTable1.getValueAt(1, 2).toString(), jTable1.getValueAt(1, 3).toString(),
                            jTable1.getValueAt(1, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("4",
                    new Object[] { jTable1.getValueAt(2, 0).toString(), jTable1.getValueAt(2, 1).toString(),
                            jTable1.getValueAt(2, 2).toString(), jTable1.getValueAt(2, 3).toString(),
                            jTable1.getValueAt(2, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("5",
                    new Object[] { jTable1.getValueAt(3, 0).toString(), jTable1.getValueAt(3, 1).toString(),
                            jTable1.getValueAt(3, 2).toString(), jTable1.getValueAt(3, 3).toString(),
                            jTable1.getValueAt(3, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("6",
                    new Object[] { jTable1.getValueAt(4, 0).toString(), jTable1.getValueAt(4, 1).toString(),
                            jTable1.getValueAt(4, 2).toString(), jTable1.getValueAt(4, 3).toString(),
                            jTable1.getValueAt(4, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("7",
                    new Object[] { jTable1.getValueAt(5, 0).toString(), jTable1.getValueAt(5, 1).toString(),
                            jTable1.getValueAt(5, 2).toString(), jTable1.getValueAt(5, 3).toString(),
                            jTable1.getValueAt(5, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("8",
                    new Object[] { jTable1.getValueAt(6, 0).toString(), jTable1.getValueAt(6, 1).toString(),
                            jTable1.getValueAt(6, 2).toString(), jTable1.getValueAt(6, 3).toString(),
                            jTable1.getValueAt(6, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("9",
                    new Object[] { jTable1.getValueAt(7, 0).toString(), jTable1.getValueAt(7, 1).toString(),
                            jTable1.getValueAt(7, 2).toString(), jTable1.getValueAt(7, 3).toString(),
                            jTable1.getValueAt(7, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("10",
                    new Object[] { jTable1.getValueAt(8, 0).toString(), jTable1.getValueAt(8, 1).toString(),
                            jTable1.getValueAt(8, 2).toString(), jTable1.getValueAt(8, 3).toString(),
                            jTable1.getValueAt(8, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("11",
                    new Object[] { jTable1.getValueAt(9, 0).toString(), jTable1.getValueAt(9, 1).toString(),
                            jTable1.getValueAt(9, 2).toString(), jTable1.getValueAt(9, 3).toString(),
                            jTable1.getValueAt(9, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("12",
                    new Object[] { jTable1.getValueAt(10, 0).toString(), jTable1.getValueAt(10, 1).toString(),
                            jTable1.getValueAt(10, 2).toString(), jTable1.getValueAt(10, 3).toString(),
                            jTable1.getValueAt(10, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("13",
                    new Object[] { jTable1.getValueAt(11, 0).toString(), jTable1.getValueAt(11, 1).toString(),
                            jTable1.getValueAt(11, 2).toString(), jTable1.getValueAt(11, 3).toString(),
                            jTable1.getValueAt(11, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("14",
                    new Object[] { jTable1.getValueAt(12, 0).toString(), jTable1.getValueAt(12, 1).toString(),
                            jTable1.getValueAt(12, 2).toString(), jTable1.getValueAt(12, 3).toString(),
                            jTable1.getValueAt(12, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("15",
                    new Object[] { jTable1.getValueAt(13, 0).toString(), jTable1.getValueAt(13, 1).toString(),
                            jTable1.getValueAt(13, 2).toString(), jTable1.getValueAt(13, 3).toString(),
                            jTable1.getValueAt(13, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("16",
                    new Object[] { jTable1.getValueAt(14, 0).toString(), jTable1.getValueAt(14, 1).toString(),
                            jTable1.getValueAt(14, 2).toString(), jTable1.getValueAt(14, 3).toString(),
                            jTable1.getValueAt(14, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("17",
                    new Object[] { jTable1.getValueAt(15, 0).toString(), jTable1.getValueAt(15, 1).toString(),
                            jTable1.getValueAt(15, 2).toString(), jTable1.getValueAt(15, 3).toString(),
                            jTable1.getValueAt(15, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("18",
                    new Object[] { jTable1.getValueAt(16, 0).toString(), jTable1.getValueAt(16, 1).toString(),
                            jTable1.getValueAt(16, 2).toString(), jTable1.getValueAt(16, 3).toString(),
                            jTable1.getValueAt(16, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("19",
                    new Object[] { jTable1.getValueAt(17, 0).toString(), jTable1.getValueAt(17, 1).toString(),
                            jTable1.getValueAt(17, 2).toString(), jTable1.getValueAt(17, 3).toString(),
                            jTable1.getValueAt(17, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("20",
                    new Object[] { jTable1.getValueAt(18, 0).toString(), jTable1.getValueAt(18, 1).toString(),
                            jTable1.getValueAt(18, 2).toString(), jTable1.getValueAt(18, 3).toString(),
                            jTable1.getValueAt(18, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("21",
                    new Object[] { jTable1.getValueAt(19, 0).toString(), jTable1.getValueAt(19, 1).toString(),
                            jTable1.getValueAt(19, 2).toString(), jTable1.getValueAt(19, 3).toString(),
                            jTable1.getValueAt(19, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("22",
                    new Object[] { jTable1.getValueAt(20, 0).toString(), jTable1.getValueAt(20, 1).toString(),
                            jTable1.getValueAt(20, 2).toString(), jTable1.getValueAt(20, 3).toString(),
                            jTable1.getValueAt(20, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("23",
                    new Object[] { jTable1.getValueAt(21, 0).toString(), jTable1.getValueAt(21, 1).toString(),
                            jTable1.getValueAt(21, 2).toString(), jTable1.getValueAt(21, 3).toString(),
                            jTable1.getValueAt(21, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("24",
                    new Object[] { jTable1.getValueAt(22, 0).toString(), jTable1.getValueAt(22, 1).toString(),
                            jTable1.getValueAt(22, 2).toString(), jTable1.getValueAt(22, 3).toString(),
                            jTable1.getValueAt(22, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("25",
                    new Object[] { jTable1.getValueAt(23, 0).toString(), jTable1.getValueAt(23, 1).toString(),
                            jTable1.getValueAt(23, 2).toString(), jTable1.getValueAt(23, 3).toString(),
                            jTable1.getValueAt(23, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("26",
                    new Object[] { jTable1.getValueAt(24, 0).toString(), jTable1.getValueAt(24, 1).toString(),
                            jTable1.getValueAt(24, 2).toString(), jTable1.getValueAt(24, 3).toString(),
                            jTable1.getValueAt(24, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("27",
                    new Object[] { jTable1.getValueAt(25, 0).toString(), jTable1.getValueAt(25, 1).toString(),
                            jTable1.getValueAt(25, 2).toString(), jTable1.getValueAt(25, 3).toString(),
                            jTable1.getValueAt(25, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("28",
                    new Object[] { jTable1.getValueAt(26, 0).toString(), jTable1.getValueAt(26, 1).toString(),
                            jTable1.getValueAt(26, 2).toString(), jTable1.getValueAt(26, 3).toString(),
                            jTable1.getValueAt(26, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("29",
                    new Object[] { jTable1.getValueAt(27, 0).toString(), jTable1.getValueAt(27, 1).toString(),
                            jTable1.getValueAt(27, 2).toString(), jTable1.getValueAt(27, 3).toString(),
                            jTable1.getValueAt(27, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("30",
                    new Object[] { jTable1.getValueAt(28, 0).toString(), jTable1.getValueAt(28, 1).toString(),
                            jTable1.getValueAt(28, 2).toString(), jTable1.getValueAt(28, 3).toString(),
                            jTable1.getValueAt(28, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("31",
                    new Object[] { jTable1.getValueAt(29, 0).toString(), jTable1.getValueAt(29, 1).toString(),
                            jTable1.getValueAt(29, 2).toString(), jTable1.getValueAt(29, 3).toString(),
                            jTable1.getValueAt(29, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("32",
                    new Object[] { jTable1.getValueAt(30, 0).toString(), jTable1.getValueAt(30, 1).toString(),
                            jTable1.getValueAt(30, 2).toString(), jTable1.getValueAt(30, 3).toString(),
                            jTable1.getValueAt(30, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("33",
                    new Object[] { jTable1.getValueAt(31, 0).toString(), jTable1.getValueAt(31, 1).toString(),
                            jTable1.getValueAt(31, 2).toString(), jTable1.getValueAt(31, 3).toString(),
                            jTable1.getValueAt(31, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("34",
                    new Object[] { jTable1.getValueAt(32, 0).toString(), jTable1.getValueAt(32, 1).toString(),
                            jTable1.getValueAt(32, 2).toString(), jTable1.getValueAt(32, 3).toString(),
                            jTable1.getValueAt(32, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("35",
                    new Object[] { jTable1.getValueAt(33, 0).toString(), jTable1.getValueAt(33, 1).toString(),
                            jTable1.getValueAt(33, 2).toString(), jTable1.getValueAt(33, 3).toString(),
                            jTable1.getValueAt(33, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("36",
                    new Object[] { jTable1.getValueAt(34, 0).toString(), jTable1.getValueAt(34, 1).toString(),
                            jTable1.getValueAt(34, 2).toString(), jTable1.getValueAt(34, 3).toString(),
                            jTable1.getValueAt(34, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("37",
                    new Object[] { jTable1.getValueAt(35, 0).toString(), jTable1.getValueAt(35, 1).toString(),
                            jTable1.getValueAt(35, 2).toString(), jTable1.getValueAt(35, 3).toString(),
                            jTable1.getValueAt(35, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("38",
                    new Object[] { jTable1.getValueAt(36, 0).toString(), jTable1.getValueAt(36, 1).toString(),
                            jTable1.getValueAt(36, 2).toString(), jTable1.getValueAt(36, 3).toString(),
                            jTable1.getValueAt(36, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("39",
                    new Object[] { jTable1.getValueAt(37, 0).toString(), jTable1.getValueAt(37, 1).toString(),
                            jTable1.getValueAt(37, 2).toString(), jTable1.getValueAt(37, 3).toString(),
                            jTable1.getValueAt(37, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("40",
                    new Object[] { jTable1.getValueAt(38, 0).toString(), jTable1.getValueAt(38, 1).toString(),
                            jTable1.getValueAt(38, 2).toString(), jTable1.getValueAt(38, 3).toString(),
                            jTable1.getValueAt(38, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("41",
                    new Object[] { jTable1.getValueAt(39, 0).toString(), jTable1.getValueAt(39, 1).toString(),
                            jTable1.getValueAt(39, 2).toString(), jTable1.getValueAt(39, 3).toString(),
                            jTable1.getValueAt(39, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("42",
                    new Object[] { jTable1.getValueAt(40, 0).toString(), jTable1.getValueAt(40, 1).toString(),
                            jTable1.getValueAt(40, 2).toString(), jTable1.getValueAt(40, 3).toString(),
                            jTable1.getValueAt(40, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("43",
                    new Object[] { jTable1.getValueAt(41, 0).toString(), jTable1.getValueAt(41, 1).toString(),
                            jTable1.getValueAt(41, 2).toString(), jTable1.getValueAt(41, 3).toString(),
                            jTable1.getValueAt(41, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("44",
                    new Object[] { jTable1.getValueAt(42, 0).toString(), jTable1.getValueAt(42, 1).toString(),
                            jTable1.getValueAt(42, 2).toString(), jTable1.getValueAt(42, 3).toString(),
                            jTable1.getValueAt(42, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("45",
                    new Object[] { jTable1.getValueAt(43, 0).toString(), jTable1.getValueAt(43, 1).toString(),
                            jTable1.getValueAt(43, 2).toString(), jTable1.getValueAt(43, 3).toString(),
                            jTable1.getValueAt(43, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("46",
                    new Object[] { jTable1.getValueAt(44, 0).toString(), jTable1.getValueAt(44, 1).toString(),
                            jTable1.getValueAt(44, 2).toString(), jTable1.getValueAt(44, 3).toString(),
                            jTable1.getValueAt(44, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("47",
                    new Object[] { jTable1.getValueAt(45, 0).toString(), jTable1.getValueAt(45, 1).toString(),
                            jTable1.getValueAt(45, 2).toString(), jTable1.getValueAt(45, 3).toString(),
                            jTable1.getValueAt(45, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("48",
                    new Object[] { jTable1.getValueAt(46, 0).toString(), jTable1.getValueAt(46, 1).toString(),
                            jTable1.getValueAt(46, 2).toString(), jTable1.getValueAt(46, 3).toString(),
                            jTable1.getValueAt(46, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("49",
                    new Object[] { jTable1.getValueAt(47, 0).toString(), jTable1.getValueAt(47, 1).toString(),
                            jTable1.getValueAt(47, 2).toString(), jTable1.getValueAt(47, 3).toString(),
                            jTable1.getValueAt(47, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("50",
                    new Object[] { jTable1.getValueAt(48, 0).toString(), jTable1.getValueAt(48, 1).toString(),
                            jTable1.getValueAt(48, 2).toString(), jTable1.getValueAt(48, 3).toString(),
                            jTable1.getValueAt(48, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("51",
                    new Object[] { jTable1.getValueAt(49, 0).toString(), jTable1.getValueAt(49, 1).toString(),
                            jTable1.getValueAt(49, 2).toString(), jTable1.getValueAt(49, 3).toString(),
                            jTable1.getValueAt(49, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("52",
                    new Object[] { jTable1.getValueAt(50, 0).toString(), jTable1.getValueAt(50, 1).toString(),
                            jTable1.getValueAt(50, 2).toString(), jTable1.getValueAt(50, 3).toString(),
                            jTable1.getValueAt(50, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("53",
                    new Object[] { jTable1.getValueAt(51, 0).toString(), jTable1.getValueAt(51, 1).toString(),
                            jTable1.getValueAt(51, 2).toString(), jTable1.getValueAt(51, 3).toString(),
                            jTable1.getValueAt(51, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("54",
                    new Object[] { jTable1.getValueAt(52, 0).toString(), jTable1.getValueAt(52, 1).toString(),
                            jTable1.getValueAt(52, 2).toString(), jTable1.getValueAt(52, 3).toString(),
                            jTable1.getValueAt(52, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("55",
                    new Object[] { jTable1.getValueAt(53, 0).toString(), jTable1.getValueAt(53, 1).toString(),
                            jTable1.getValueAt(53, 2).toString(), jTable1.getValueAt(53, 3).toString(),
                            jTable1.getValueAt(53, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("56",
                    new Object[] { jTable1.getValueAt(54, 0).toString(), jTable1.getValueAt(54, 1).toString(),
                            jTable1.getValueAt(54, 2).toString(), jTable1.getValueAt(54, 3).toString(),
                            jTable1.getValueAt(54, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("57",
                    new Object[] { jTable1.getValueAt(55, 0).toString(), jTable1.getValueAt(55, 1).toString(),
                            jTable1.getValueAt(55, 2).toString(), jTable1.getValueAt(55, 3).toString(),
                            jTable1.getValueAt(55, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("58",
                    new Object[] { jTable1.getValueAt(56, 0).toString(), jTable1.getValueAt(56, 1).toString(),
                            jTable1.getValueAt(56, 2).toString(), jTable1.getValueAt(56, 3).toString(),
                            jTable1.getValueAt(56, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("59",
                    new Object[] { jTable1.getValueAt(57, 0).toString(), jTable1.getValueAt(57, 1).toString(),
                            jTable1.getValueAt(57, 2).toString(), jTable1.getValueAt(57, 3).toString(),
                            jTable1.getValueAt(57, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("60",
                    new Object[] { jTable1.getValueAt(58, 0).toString(), jTable1.getValueAt(58, 1).toString(),
                            jTable1.getValueAt(58, 2).toString(), jTable1.getValueAt(58, 3).toString(),
                            jTable1.getValueAt(58, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("61",
                    new Object[] { jTable1.getValueAt(59, 0).toString(), jTable1.getValueAt(59, 1).toString(),
                            jTable1.getValueAt(59, 2).toString(), jTable1.getValueAt(59, 3).toString(),
                            jTable1.getValueAt(59, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("62",
                    new Object[] { jTable1.getValueAt(60, 0).toString(), jTable1.getValueAt(60, 1).toString(),
                            jTable1.getValueAt(60, 2).toString(), jTable1.getValueAt(60, 3).toString(),
                            jTable1.getValueAt(60, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("63",
                    new Object[] { jTable1.getValueAt(61, 0).toString(), jTable1.getValueAt(61, 1).toString(),
                            jTable1.getValueAt(61, 2).toString(), jTable1.getValueAt(61, 3).toString(),
                            jTable1.getValueAt(61, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("64",
                    new Object[] { jTable1.getValueAt(62, 0).toString(), jTable1.getValueAt(62, 1).toString(),
                            jTable1.getValueAt(62, 2).toString(), jTable1.getValueAt(62, 3).toString(),
                            jTable1.getValueAt(62, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("65",
                    new Object[] { jTable1.getValueAt(63, 0).toString(), jTable1.getValueAt(63, 1).toString(),
                            jTable1.getValueAt(63, 2).toString(), jTable1.getValueAt(63, 3).toString(),
                            jTable1.getValueAt(63, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("66",
                    new Object[] { jTable1.getValueAt(64, 0).toString(), jTable1.getValueAt(64, 1).toString(),
                            jTable1.getValueAt(64, 2).toString(), jTable1.getValueAt(64, 3).toString(),
                            jTable1.getValueAt(64, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("67",
                    new Object[] { jTable1.getValueAt(65, 0).toString(), jTable1.getValueAt(65, 1).toString(),
                            jTable1.getValueAt(65, 2).toString(), jTable1.getValueAt(65, 3).toString(),
                            jTable1.getValueAt(65, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("68",
                    new Object[] { jTable1.getValueAt(66, 0).toString(), jTable1.getValueAt(66, 1).toString(),
                            jTable1.getValueAt(66, 2).toString(), jTable1.getValueAt(66, 3).toString(),
                            jTable1.getValueAt(66, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("69",
                    new Object[] { jTable1.getValueAt(67, 0).toString(), jTable1.getValueAt(67, 1).toString(),
                            jTable1.getValueAt(67, 2).toString(), jTable1.getValueAt(67, 3).toString(),
                            jTable1.getValueAt(67, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("70",
                    new Object[] { jTable1.getValueAt(68, 0).toString(), jTable1.getValueAt(68, 1).toString(),
                            jTable1.getValueAt(68, 2).toString(), jTable1.getValueAt(68, 3).toString(),
                            jTable1.getValueAt(68, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("71",
                    new Object[] { jTable1.getValueAt(69, 0).toString(), jTable1.getValueAt(69, 1).toString(),
                            jTable1.getValueAt(69, 2).toString(), jTable1.getValueAt(69, 3).toString(),
                            jTable1.getValueAt(69, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("72",
                    new Object[] { jTable1.getValueAt(70, 0).toString(), jTable1.getValueAt(70, 1).toString(),
                            jTable1.getValueAt(70, 2).toString(), jTable1.getValueAt(70, 3).toString(),
                            jTable1.getValueAt(70, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("73",
                    new Object[] { jTable1.getValueAt(71, 0).toString(), jTable1.getValueAt(71, 1).toString(),
                            jTable1.getValueAt(71, 2).toString(), jTable1.getValueAt(71, 3).toString(),
                            jTable1.getValueAt(71, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("74",
                    new Object[] { jTable1.getValueAt(72, 0).toString(), jTable1.getValueAt(72, 1).toString(),
                            jTable1.getValueAt(72, 2).toString(), jTable1.getValueAt(72, 3).toString(),
                            jTable1.getValueAt(72, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("75",
                    new Object[] { jTable1.getValueAt(73, 0).toString(), jTable1.getValueAt(73, 1).toString(),
                            jTable1.getValueAt(73, 2).toString(), jTable1.getValueAt(73, 3).toString(),
                            jTable1.getValueAt(73, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("76",
                    new Object[] { jTable1.getValueAt(74, 0).toString(), jTable1.getValueAt(74, 1).toString(),
                            jTable1.getValueAt(74, 2).toString(), jTable1.getValueAt(74, 3).toString(),
                            jTable1.getValueAt(74, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("77",
                    new Object[] { jTable1.getValueAt(75, 0).toString(), jTable1.getValueAt(75, 1).toString(),
                            jTable1.getValueAt(75, 2).toString(), jTable1.getValueAt(75, 3).toString(),
                            jTable1.getValueAt(75, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("78",
                    new Object[] { jTable1.getValueAt(76, 0).toString(), jTable1.getValueAt(76, 1).toString(),
                            jTable1.getValueAt(76, 2).toString(), jTable1.getValueAt(76, 3).toString(),
                            jTable1.getValueAt(76, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("79",
                    new Object[] { jTable1.getValueAt(77, 0).toString(), jTable1.getValueAt(77, 1).toString(),
                            jTable1.getValueAt(77, 2).toString(), jTable1.getValueAt(77, 3).toString(),
                            jTable1.getValueAt(77, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("80",
                    new Object[] { jTable1.getValueAt(78, 0).toString(), jTable1.getValueAt(78, 1).toString(),
                            jTable1.getValueAt(78, 2).toString(), jTable1.getValueAt(78, 3).toString(),
                            jTable1.getValueAt(78, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("81",
                    new Object[] { jTable1.getValueAt(79, 0).toString(), jTable1.getValueAt(79, 1).toString(),
                            jTable1.getValueAt(79, 2).toString(), jTable1.getValueAt(79, 3).toString(),
                            jTable1.getValueAt(79, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("82",
                    new Object[] { jTable1.getValueAt(80, 0).toString(), jTable1.getValueAt(80, 1).toString(),
                            jTable1.getValueAt(80, 2).toString(), jTable1.getValueAt(80, 3).toString(),
                            jTable1.getValueAt(80, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("83",
                    new Object[] { jTable1.getValueAt(81, 0).toString(), jTable1.getValueAt(81, 1).toString(),
                            jTable1.getValueAt(81, 2).toString(), jTable1.getValueAt(81, 3).toString(),
                            jTable1.getValueAt(81, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("84",
                    new Object[] { jTable1.getValueAt(82, 0).toString(), jTable1.getValueAt(82, 1).toString(),
                            jTable1.getValueAt(82, 2).toString(), jTable1.getValueAt(82, 3).toString(),
                            jTable1.getValueAt(82, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("85",
                    new Object[] { jTable1.getValueAt(83, 0).toString(), jTable1.getValueAt(83, 1).toString(),
                            jTable1.getValueAt(83, 2).toString(), jTable1.getValueAt(83, 3).toString(),
                            jTable1.getValueAt(83, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("86",
                    new Object[] { jTable1.getValueAt(84, 0).toString(), jTable1.getValueAt(84, 1).toString(),
                            jTable1.getValueAt(84, 2).toString(), jTable1.getValueAt(84, 3).toString(),
                            jTable1.getValueAt(84, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("87",
                    new Object[] { jTable1.getValueAt(85, 0).toString(), jTable1.getValueAt(85, 1).toString(),
                            jTable1.getValueAt(85, 2).toString(), jTable1.getValueAt(85, 3).toString(),
                            jTable1.getValueAt(85, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("88",
                    new Object[] { jTable1.getValueAt(86, 0).toString(), jTable1.getValueAt(86, 1).toString(),
                            jTable1.getValueAt(86, 2).toString(), jTable1.getValueAt(86, 3).toString(),
                            jTable1.getValueAt(86, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("89",
                    new Object[] { jTable1.getValueAt(87, 0).toString(), jTable1.getValueAt(87, 1).toString(),
                            jTable1.getValueAt(87, 2).toString(), jTable1.getValueAt(87, 3).toString(),
                            jTable1.getValueAt(87, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("90",
                    new Object[] { jTable1.getValueAt(88, 0).toString(), jTable1.getValueAt(88, 1).toString(),
                            jTable1.getValueAt(88, 2).toString(), jTable1.getValueAt(88, 3).toString(),
                            jTable1.getValueAt(88, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("91",
                    new Object[] { jTable1.getValueAt(89, 0).toString(), jTable1.getValueAt(89, 1).toString(),
                            jTable1.getValueAt(89, 2).toString(), jTable1.getValueAt(89, 3).toString(),
                            jTable1.getValueAt(89, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("92",
                    new Object[] { jTable1.getValueAt(90, 0).toString(), jTable1.getValueAt(90, 1).toString(),
                            jTable1.getValueAt(90, 2).toString(), jTable1.getValueAt(90, 3).toString(),
                            jTable1.getValueAt(90, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("93",
                    new Object[] { jTable1.getValueAt(91, 0).toString(), jTable1.getValueAt(91, 1).toString(),
                            jTable1.getValueAt(91, 2).toString(), jTable1.getValueAt(91, 3).toString(),
                            jTable1.getValueAt(91, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("94",
                    new Object[] { jTable1.getValueAt(92, 0).toString(), jTable1.getValueAt(92, 1).toString(),
                            jTable1.getValueAt(92, 2).toString(), jTable1.getValueAt(92, 3).toString(),
                            jTable1.getValueAt(92, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("95",
                    new Object[] { jTable1.getValueAt(93, 0).toString(), jTable1.getValueAt(93, 1).toString(),
                            jTable1.getValueAt(93, 2).toString(), jTable1.getValueAt(93, 3).toString(),
                            jTable1.getValueAt(93, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("96",
                    new Object[] { jTable1.getValueAt(94, 0).toString(), jTable1.getValueAt(94, 1).toString(),
                            jTable1.getValueAt(94, 2).toString(), jTable1.getValueAt(94, 3).toString(),
                            jTable1.getValueAt(94, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("97",
                    new Object[] { jTable1.getValueAt(95, 0).toString(), jTable1.getValueAt(95, 1).toString(),
                            jTable1.getValueAt(95, 2).toString(), jTable1.getValueAt(95, 3).toString(),
                            jTable1.getValueAt(95, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("98",
                    new Object[] { jTable1.getValueAt(96, 0).toString(), jTable1.getValueAt(96, 1).toString(),
                            jTable1.getValueAt(96, 2).toString(), jTable1.getValueAt(96, 3).toString(),
                            jTable1.getValueAt(96, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("99",
                    new Object[] { jTable1.getValueAt(97, 0).toString(), jTable1.getValueAt(97, 1).toString(),
                            jTable1.getValueAt(97, 2).toString(), jTable1.getValueAt(97, 3).toString(),
                            jTable1.getValueAt(97, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("100",
                    new Object[] { jTable1.getValueAt(98, 0).toString(), jTable1.getValueAt(98, 1).toString(),
                            jTable1.getValueAt(98, 2).toString(), jTable1.getValueAt(98, 3).toString(),
                            jTable1.getValueAt(98, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("101",
                    new Object[] { jTable1.getValueAt(99, 0).toString(), jTable1.getValueAt(99, 1).toString(),
                            jTable1.getValueAt(99, 2).toString(), jTable1.getValueAt(99, 3).toString(),
                            jTable1.getValueAt(99, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("102",
                    new Object[] { jTable1.getValueAt(100, 0).toString(), jTable1.getValueAt(100, 1).toString(),
                            jTable1.getValueAt(100, 2).toString(), jTable1.getValueAt(100, 3).toString(),
                            jTable1.getValueAt(100, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("103",
                    new Object[] { jTable1.getValueAt(101, 0).toString(), jTable1.getValueAt(101, 1).toString(),
                            jTable1.getValueAt(101, 2).toString(), jTable1.getValueAt(101, 3).toString(),
                            jTable1.getValueAt(101, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("104",
                    new Object[] { jTable1.getValueAt(102, 0).toString(), jTable1.getValueAt(102, 1).toString(),
                            jTable1.getValueAt(102, 2).toString(), jTable1.getValueAt(102, 3).toString(),
                            jTable1.getValueAt(102, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("105",
                    new Object[] { jTable1.getValueAt(103, 0).toString(), jTable1.getValueAt(103, 1).toString(),
                            jTable1.getValueAt(103, 2).toString(), jTable1.getValueAt(103, 3).toString(),
                            jTable1.getValueAt(103, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("106",
                    new Object[] { jTable1.getValueAt(104, 0).toString(), jTable1.getValueAt(104, 1).toString(),
                            jTable1.getValueAt(104, 2).toString(), jTable1.getValueAt(104, 3).toString(),
                            jTable1.getValueAt(104, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("107",
                    new Object[] { jTable1.getValueAt(105, 0).toString(), jTable1.getValueAt(105, 1).toString(),
                            jTable1.getValueAt(105, 2).toString(), jTable1.getValueAt(105, 3).toString(),
                            jTable1.getValueAt(105, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("108",
                    new Object[] { jTable1.getValueAt(106, 0).toString(), jTable1.getValueAt(106, 1).toString(),
                            jTable1.getValueAt(106, 2).toString(), jTable1.getValueAt(106, 3).toString(),
                            jTable1.getValueAt(106, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("109",
                    new Object[] { jTable1.getValueAt(107, 0).toString(), jTable1.getValueAt(107, 1).toString(),
                            jTable1.getValueAt(107, 2).toString(), jTable1.getValueAt(107, 3).toString(),
                            jTable1.getValueAt(107, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("110",
                    new Object[] { jTable1.getValueAt(108, 0).toString(), jTable1.getValueAt(108, 1).toString(),
                            jTable1.getValueAt(108, 2).toString(), jTable1.getValueAt(108, 3).toString(),
                            jTable1.getValueAt(108, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("111",
                    new Object[] { jTable1.getValueAt(109, 0).toString(), jTable1.getValueAt(109, 1).toString(),
                            jTable1.getValueAt(109, 2).toString(), jTable1.getValueAt(109, 3).toString(),
                            jTable1.getValueAt(109, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("112",
                    new Object[] { jTable1.getValueAt(110, 0).toString(), jTable1.getValueAt(110, 1).toString(),
                            jTable1.getValueAt(110, 2).toString(), jTable1.getValueAt(110, 3).toString(),
                            jTable1.getValueAt(110, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("113",
                    new Object[] { jTable1.getValueAt(111, 0).toString(), jTable1.getValueAt(111, 1).toString(),
                            jTable1.getValueAt(111, 2).toString(), jTable1.getValueAt(111, 3).toString(),
                            jTable1.getValueAt(111, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("114",
                    new Object[] { jTable1.getValueAt(112, 0).toString(), jTable1.getValueAt(112, 1).toString(),
                            jTable1.getValueAt(112, 2).toString(), jTable1.getValueAt(112, 3).toString(),
                            jTable1.getValueAt(112, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("115",
                    new Object[] { jTable1.getValueAt(113, 0).toString(), jTable1.getValueAt(113, 1).toString(),
                            jTable1.getValueAt(113, 2).toString(), jTable1.getValueAt(113, 3).toString(),
                            jTable1.getValueAt(113, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("116",
                    new Object[] { jTable1.getValueAt(114, 0).toString(), jTable1.getValueAt(114, 1).toString(),
                            jTable1.getValueAt(114, 2).toString(), jTable1.getValueAt(114, 3).toString(),
                            jTable1.getValueAt(114, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("117",
                    new Object[] { jTable1.getValueAt(115, 0).toString(), jTable1.getValueAt(115, 1).toString(),
                            jTable1.getValueAt(115, 2).toString(), jTable1.getValueAt(115, 3).toString(),
                            jTable1.getValueAt(115, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("118",
                    new Object[] { jTable1.getValueAt(116, 0).toString(), jTable1.getValueAt(116, 1).toString(),
                            jTable1.getValueAt(116, 2).toString(), jTable1.getValueAt(116, 3).toString(),
                            jTable1.getValueAt(116, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("119",
                    new Object[] { jTable1.getValueAt(117, 0).toString(), jTable1.getValueAt(117, 1).toString(),
                            jTable1.getValueAt(117, 2).toString(), jTable1.getValueAt(117, 3).toString(),
                            jTable1.getValueAt(117, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("120",
                    new Object[] { jTable1.getValueAt(118, 0).toString(), jTable1.getValueAt(118, 1).toString(),
                            jTable1.getValueAt(118, 2).toString(), jTable1.getValueAt(118, 3).toString(),
                            jTable1.getValueAt(118, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("121",
                    new Object[] { jTable1.getValueAt(119, 0).toString(), jTable1.getValueAt(119, 1).toString(),
                            jTable1.getValueAt(119, 2).toString(), jTable1.getValueAt(119, 3).toString(),
                            jTable1.getValueAt(119, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("122",
                    new Object[] { jTable1.getValueAt(120, 0).toString(), jTable1.getValueAt(120, 1).toString(),
                            jTable1.getValueAt(120, 2).toString(), jTable1.getValueAt(120, 3).toString(),
                            jTable1.getValueAt(120, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("123",
                    new Object[] { jTable1.getValueAt(121, 0).toString(), jTable1.getValueAt(121, 1).toString(),
                            jTable1.getValueAt(121, 2).toString(), jTable1.getValueAt(121, 3).toString(),
                            jTable1.getValueAt(121, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("124",
                    new Object[] { jTable1.getValueAt(122, 0).toString(), jTable1.getValueAt(122, 1).toString(),
                            jTable1.getValueAt(122, 2).toString(), jTable1.getValueAt(122, 3).toString(),
                            jTable1.getValueAt(122, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("125",
                    new Object[] { jTable1.getValueAt(123, 0).toString(), jTable1.getValueAt(123, 1).toString(),
                            jTable1.getValueAt(123, 2).toString(), jTable1.getValueAt(123, 3).toString(),
                            jTable1.getValueAt(123, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("126",
                    new Object[] { jTable1.getValueAt(124, 0).toString(), jTable1.getValueAt(124, 1).toString(),
                            jTable1.getValueAt(124, 2).toString(), jTable1.getValueAt(124, 3).toString(),
                            jTable1.getValueAt(124, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("127",
                    new Object[] { jTable1.getValueAt(125, 0).toString(), jTable1.getValueAt(125, 1).toString(),
                            jTable1.getValueAt(125, 2).toString(), jTable1.getValueAt(125, 3).toString(),
                            jTable1.getValueAt(125, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("128",
                    new Object[] { jTable1.getValueAt(126, 0).toString(), jTable1.getValueAt(126, 1).toString(),
                            jTable1.getValueAt(126, 2).toString(), jTable1.getValueAt(126, 3).toString(),
                            jTable1.getValueAt(126, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("129",
                    new Object[] { jTable1.getValueAt(127, 0).toString(), jTable1.getValueAt(127, 1).toString(),
                            jTable1.getValueAt(127, 2).toString(), jTable1.getValueAt(127, 3).toString(),
                            jTable1.getValueAt(127, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("130",
                    new Object[] { jTable1.getValueAt(128, 0).toString(), jTable1.getValueAt(128, 1).toString(),
                            jTable1.getValueAt(128, 2).toString(), jTable1.getValueAt(128, 3).toString(),
                            jTable1.getValueAt(128, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("131",
                    new Object[] { jTable1.getValueAt(129, 0).toString(), jTable1.getValueAt(129, 1).toString(),
                            jTable1.getValueAt(129, 2).toString(), jTable1.getValueAt(129, 3).toString(),
                            jTable1.getValueAt(129, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("132",
                    new Object[] { jTable1.getValueAt(130, 0).toString(), jTable1.getValueAt(130, 1).toString(),
                            jTable1.getValueAt(130, 2).toString(), jTable1.getValueAt(130, 3).toString(),
                            jTable1.getValueAt(130, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("133",
                    new Object[] { jTable1.getValueAt(131, 0).toString(), jTable1.getValueAt(131, 1).toString(),
                            jTable1.getValueAt(131, 2).toString(), jTable1.getValueAt(131, 3).toString(),
                            jTable1.getValueAt(131, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("134",
                    new Object[] { jTable1.getValueAt(132, 0).toString(), jTable1.getValueAt(132, 1).toString(),
                            jTable1.getValueAt(132, 2).toString(), jTable1.getValueAt(132, 3).toString(),
                            jTable1.getValueAt(132, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("135",
                    new Object[] { jTable1.getValueAt(133, 0).toString(), jTable1.getValueAt(133, 1).toString(),
                            jTable1.getValueAt(133, 2).toString(), jTable1.getValueAt(133, 3).toString(),
                            jTable1.getValueAt(133, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("136",
                    new Object[] { jTable1.getValueAt(134, 0).toString(), jTable1.getValueAt(134, 1).toString(),
                            jTable1.getValueAt(134, 2).toString(), jTable1.getValueAt(134, 3).toString(),
                            jTable1.getValueAt(134, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("137",
                    new Object[] { jTable1.getValueAt(135, 0).toString(), jTable1.getValueAt(135, 1).toString(),
                            jTable1.getValueAt(135, 2).toString(), jTable1.getValueAt(135, 3).toString(),
                            jTable1.getValueAt(135, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("138",
                    new Object[] { jTable1.getValueAt(136, 0).toString(), jTable1.getValueAt(136, 1).toString(),
                            jTable1.getValueAt(136, 2).toString(), jTable1.getValueAt(136, 3).toString(),
                            jTable1.getValueAt(136, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("139",
                    new Object[] { jTable1.getValueAt(137, 0).toString(), jTable1.getValueAt(137, 1).toString(),
                            jTable1.getValueAt(137, 2).toString(), jTable1.getValueAt(137, 3).toString(),
                            jTable1.getValueAt(137, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("140",
                    new Object[] { jTable1.getValueAt(138, 0).toString(), jTable1.getValueAt(138, 1).toString(),
                            jTable1.getValueAt(138, 2).toString(), jTable1.getValueAt(138, 3).toString(),
                            jTable1.getValueAt(138, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("141",
                    new Object[] { jTable1.getValueAt(139, 0).toString(), jTable1.getValueAt(139, 1).toString(),
                            jTable1.getValueAt(139, 2).toString(), jTable1.getValueAt(139, 3).toString(),
                            jTable1.getValueAt(139, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("142",
                    new Object[] { jTable1.getValueAt(140, 0).toString(), jTable1.getValueAt(140, 1).toString(),
                            jTable1.getValueAt(140, 2).toString(), jTable1.getValueAt(140, 3).toString(),
                            jTable1.getValueAt(140, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("143",
                    new Object[] { jTable1.getValueAt(141, 0).toString(), jTable1.getValueAt(141, 1).toString(),
                            jTable1.getValueAt(141, 2).toString(), jTable1.getValueAt(141, 3).toString(),
                            jTable1.getValueAt(141, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("144",
                    new Object[] { jTable1.getValueAt(142, 0).toString(), jTable1.getValueAt(142, 1).toString(),
                            jTable1.getValueAt(142, 2).toString(), jTable1.getValueAt(142, 3).toString(),
                            jTable1.getValueAt(142, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("145",
                    new Object[] { jTable1.getValueAt(143, 0).toString(), jTable1.getValueAt(143, 1).toString(),
                            jTable1.getValueAt(143, 2).toString(), jTable1.getValueAt(143, 3).toString(),
                            jTable1.getValueAt(143, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("146",
                    new Object[] { jTable1.getValueAt(144, 0).toString(), jTable1.getValueAt(144, 1).toString(),
                            jTable1.getValueAt(144, 2).toString(), jTable1.getValueAt(144, 3).toString(),
                            jTable1.getValueAt(144, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("147",
                    new Object[] { jTable1.getValueAt(145, 0).toString(), jTable1.getValueAt(145, 1).toString(),
                            jTable1.getValueAt(145, 2).toString(), jTable1.getValueAt(145, 3).toString(),
                            jTable1.getValueAt(145, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("148",
                    new Object[] { jTable1.getValueAt(146, 0).toString(), jTable1.getValueAt(146, 1).toString(),
                            jTable1.getValueAt(146, 2).toString(), jTable1.getValueAt(146, 3).toString(),
                            jTable1.getValueAt(146, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("149",
                    new Object[] { jTable1.getValueAt(147, 0).toString(), jTable1.getValueAt(147, 1).toString(),
                            jTable1.getValueAt(147, 2).toString(), jTable1.getValueAt(147, 3).toString(),
                            jTable1.getValueAt(147, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("150",
                    new Object[] { jTable1.getValueAt(148, 0).toString(), jTable1.getValueAt(148, 1).toString(),
                            jTable1.getValueAt(148, 2).toString(), jTable1.getValueAt(148, 3).toString(),
                            jTable1.getValueAt(148, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("151",
                    new Object[] { jTable1.getValueAt(149, 0).toString(), jTable1.getValueAt(149, 1).toString(),
                            jTable1.getValueAt(149, 2).toString(), jTable1.getValueAt(149, 3).toString(),
                            jTable1.getValueAt(149, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("152",
                    new Object[] { jTable1.getValueAt(150, 0).toString(), jTable1.getValueAt(150, 1).toString(),
                            jTable1.getValueAt(150, 2).toString(), jTable1.getValueAt(150, 3).toString(),
                            jTable1.getValueAt(150, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("153",
                    new Object[] { jTable1.getValueAt(151, 0).toString(), jTable1.getValueAt(151, 1).toString(),
                            jTable1.getValueAt(151, 2).toString(), jTable1.getValueAt(151, 3).toString(),
                            jTable1.getValueAt(151, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("154",
                    new Object[] { jTable1.getValueAt(152, 0).toString(), jTable1.getValueAt(152, 1).toString(),
                            jTable1.getValueAt(152, 2).toString(), jTable1.getValueAt(152, 3).toString(),
                            jTable1.getValueAt(152, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("155",
                    new Object[] { jTable1.getValueAt(153, 0).toString(), jTable1.getValueAt(153, 1).toString(),
                            jTable1.getValueAt(153, 2).toString(), jTable1.getValueAt(153, 3).toString(),
                            jTable1.getValueAt(153, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("156",
                    new Object[] { jTable1.getValueAt(154, 0).toString(), jTable1.getValueAt(154, 1).toString(),
                            jTable1.getValueAt(154, 2).toString(), jTable1.getValueAt(154, 3).toString(),
                            jTable1.getValueAt(154, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("157",
                    new Object[] { jTable1.getValueAt(155, 0).toString(), jTable1.getValueAt(155, 1).toString(),
                            jTable1.getValueAt(155, 2).toString(), jTable1.getValueAt(155, 3).toString(),
                            jTable1.getValueAt(155, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("158",
                    new Object[] { jTable1.getValueAt(156, 0).toString(), jTable1.getValueAt(156, 1).toString(),
                            jTable1.getValueAt(156, 2).toString(), jTable1.getValueAt(156, 3).toString(),
                            jTable1.getValueAt(156, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("159",
                    new Object[] { jTable1.getValueAt(157, 0).toString(), jTable1.getValueAt(157, 1).toString(),
                            jTable1.getValueAt(157, 2).toString(), jTable1.getValueAt(157, 3).toString(),
                            jTable1.getValueAt(157, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("160",
                    new Object[] { jTable1.getValueAt(158, 0).toString(), jTable1.getValueAt(158, 1).toString(),
                            jTable1.getValueAt(158, 2).toString(), jTable1.getValueAt(158, 3).toString(),
                            jTable1.getValueAt(158, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("161",
                    new Object[] { jTable1.getValueAt(159, 0).toString(), jTable1.getValueAt(159, 1).toString(),
                            jTable1.getValueAt(159, 2).toString(), jTable1.getValueAt(159, 3).toString(),
                            jTable1.getValueAt(159, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("162",
                    new Object[] { jTable1.getValueAt(160, 0).toString(), jTable1.getValueAt(160, 1).toString(),
                            jTable1.getValueAt(160, 2).toString(), jTable1.getValueAt(160, 3).toString(),
                            jTable1.getValueAt(160, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("163",
                    new Object[] { jTable1.getValueAt(161, 0).toString(), jTable1.getValueAt(161, 1).toString(),
                            jTable1.getValueAt(161, 2).toString(), jTable1.getValueAt(161, 3).toString(),
                            jTable1.getValueAt(161, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("164",
                    new Object[] { jTable1.getValueAt(162, 0).toString(), jTable1.getValueAt(162, 1).toString(),
                            jTable1.getValueAt(162, 2).toString(), jTable1.getValueAt(162, 3).toString(),
                            jTable1.getValueAt(162, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("165",
                    new Object[] { jTable1.getValueAt(163, 0).toString(), jTable1.getValueAt(163, 1).toString(),
                            jTable1.getValueAt(163, 2).toString(), jTable1.getValueAt(163, 3).toString(),
                            jTable1.getValueAt(163, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("166",
                    new Object[] { jTable1.getValueAt(164, 0).toString(), jTable1.getValueAt(164, 1).toString(),
                            jTable1.getValueAt(164, 2).toString(), jTable1.getValueAt(164, 3).toString(),
                            jTable1.getValueAt(164, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("167",
                    new Object[] { jTable1.getValueAt(165, 0).toString(), jTable1.getValueAt(165, 1).toString(),
                            jTable1.getValueAt(165, 2).toString(), jTable1.getValueAt(165, 3).toString(),
                            jTable1.getValueAt(165, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("168",
                    new Object[] { jTable1.getValueAt(166, 0).toString(), jTable1.getValueAt(166, 1).toString(),
                            jTable1.getValueAt(166, 2).toString(), jTable1.getValueAt(166, 3).toString(),
                            jTable1.getValueAt(166, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("169",
                    new Object[] { jTable1.getValueAt(167, 0).toString(), jTable1.getValueAt(167, 1).toString(),
                            jTable1.getValueAt(167, 2).toString(), jTable1.getValueAt(167, 3).toString(),
                            jTable1.getValueAt(167, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("170",
                    new Object[] { jTable1.getValueAt(168, 0).toString(), jTable1.getValueAt(168, 1).toString(),
                            jTable1.getValueAt(168, 2).toString(), jTable1.getValueAt(168, 3).toString(),
                            jTable1.getValueAt(168, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("171",
                    new Object[] { jTable1.getValueAt(169, 0).toString(), jTable1.getValueAt(169, 1).toString(),
                            jTable1.getValueAt(169, 2).toString(), jTable1.getValueAt(169, 3).toString(),
                            jTable1.getValueAt(169, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("172",
                    new Object[] { jTable1.getValueAt(170, 0).toString(), jTable1.getValueAt(170, 1).toString(),
                            jTable1.getValueAt(170, 2).toString(), jTable1.getValueAt(170, 3).toString(),
                            jTable1.getValueAt(170, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("173",
                    new Object[] { jTable1.getValueAt(171, 0).toString(), jTable1.getValueAt(171, 1).toString(),
                            jTable1.getValueAt(171, 2).toString(), jTable1.getValueAt(171, 3).toString(),
                            jTable1.getValueAt(171, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("174",
                    new Object[] { jTable1.getValueAt(172, 0).toString(), jTable1.getValueAt(172, 1).toString(),
                            jTable1.getValueAt(172, 2).toString(), jTable1.getValueAt(172, 3).toString(),
                            jTable1.getValueAt(172, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("175",
                    new Object[] { jTable1.getValueAt(173, 0).toString(), jTable1.getValueAt(173, 1).toString(),
                            jTable1.getValueAt(173, 2).toString(), jTable1.getValueAt(173, 3).toString(),
                            jTable1.getValueAt(173, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("176",
                    new Object[] { jTable1.getValueAt(174, 0).toString(), jTable1.getValueAt(174, 1).toString(),
                            jTable1.getValueAt(174, 2).toString(), jTable1.getValueAt(174, 3).toString(),
                            jTable1.getValueAt(174, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("177",
                    new Object[] { jTable1.getValueAt(175, 0).toString(), jTable1.getValueAt(175, 1).toString(),
                            jTable1.getValueAt(175, 2).toString(), jTable1.getValueAt(175, 3).toString(),
                            jTable1.getValueAt(175, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("178",
                    new Object[] { jTable1.getValueAt(176, 0).toString(), jTable1.getValueAt(176, 1).toString(),
                            jTable1.getValueAt(176, 2).toString(), jTable1.getValueAt(176, 3).toString(),
                            jTable1.getValueAt(176, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("179",
                    new Object[] { jTable1.getValueAt(177, 0).toString(), jTable1.getValueAt(177, 1).toString(),
                            jTable1.getValueAt(177, 2).toString(), jTable1.getValueAt(177, 3).toString(),
                            jTable1.getValueAt(177, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("180",
                    new Object[] { jTable1.getValueAt(178, 0).toString(), jTable1.getValueAt(178, 1).toString(),
                            jTable1.getValueAt(178, 2).toString(), jTable1.getValueAt(178, 3).toString(),
                            jTable1.getValueAt(178, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("181",
                    new Object[] { jTable1.getValueAt(179, 0).toString(), jTable1.getValueAt(179, 1).toString(),
                            jTable1.getValueAt(179, 2).toString(), jTable1.getValueAt(179, 3).toString(),
                            jTable1.getValueAt(179, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("182",
                    new Object[] { jTable1.getValueAt(180, 0).toString(), jTable1.getValueAt(180, 1).toString(),
                            jTable1.getValueAt(180, 2).toString(), jTable1.getValueAt(180, 3).toString(),
                            jTable1.getValueAt(180, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("183",
                    new Object[] { jTable1.getValueAt(181, 0).toString(), jTable1.getValueAt(181, 1).toString(),
                            jTable1.getValueAt(181, 2).toString(), jTable1.getValueAt(181, 3).toString(),
                            jTable1.getValueAt(181, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("184",
                    new Object[] { jTable1.getValueAt(182, 0).toString(), jTable1.getValueAt(182, 1).toString(),
                            jTable1.getValueAt(182, 2).toString(), jTable1.getValueAt(182, 3).toString(),
                            jTable1.getValueAt(182, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("185",
                    new Object[] { jTable1.getValueAt(183, 0).toString(), jTable1.getValueAt(183, 1).toString(),
                            jTable1.getValueAt(183, 2).toString(), jTable1.getValueAt(183, 3).toString(),
                            jTable1.getValueAt(183, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("186",
                    new Object[] { jTable1.getValueAt(184, 0).toString(), jTable1.getValueAt(184, 1).toString(),
                            jTable1.getValueAt(184, 2).toString(), jTable1.getValueAt(184, 3).toString(),
                            jTable1.getValueAt(184, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("187",
                    new Object[] { jTable1.getValueAt(185, 0).toString(), jTable1.getValueAt(185, 1).toString(),
                            jTable1.getValueAt(185, 2).toString(), jTable1.getValueAt(185, 3).toString(),
                            jTable1.getValueAt(185, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("188",
                    new Object[] { jTable1.getValueAt(186, 0).toString(), jTable1.getValueAt(186, 1).toString(),
                            jTable1.getValueAt(186, 2).toString(), jTable1.getValueAt(186, 3).toString(),
                            jTable1.getValueAt(186, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("189",
                    new Object[] { jTable1.getValueAt(187, 0).toString(), jTable1.getValueAt(187, 1).toString(),
                            jTable1.getValueAt(187, 2).toString(), jTable1.getValueAt(187, 3).toString(),
                            jTable1.getValueAt(187, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("190",
                    new Object[] { jTable1.getValueAt(188, 0).toString(), jTable1.getValueAt(188, 1).toString(),
                            jTable1.getValueAt(188, 2).toString(), jTable1.getValueAt(188, 3).toString(),
                            jTable1.getValueAt(188, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("191",
                    new Object[] { jTable1.getValueAt(189, 0).toString(), jTable1.getValueAt(189, 1).toString(),
                            jTable1.getValueAt(189, 2).toString(), jTable1.getValueAt(189, 3).toString(),
                            jTable1.getValueAt(189, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("192",
                    new Object[] { jTable1.getValueAt(190, 0).toString(), jTable1.getValueAt(190, 1).toString(),
                            jTable1.getValueAt(190, 2).toString(), jTable1.getValueAt(190, 3).toString(),
                            jTable1.getValueAt(190, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("193",
                    new Object[] { jTable1.getValueAt(191, 0).toString(), jTable1.getValueAt(191, 1).toString(),
                            jTable1.getValueAt(191, 2).toString(), jTable1.getValueAt(191, 3).toString(),
                            jTable1.getValueAt(191, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("194",
                    new Object[] { jTable1.getValueAt(192, 0).toString(), jTable1.getValueAt(192, 1).toString(),
                            jTable1.getValueAt(192, 2).toString(), jTable1.getValueAt(192, 3).toString(),
                            jTable1.getValueAt(192, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("195",
                    new Object[] { jTable1.getValueAt(193, 0).toString(), jTable1.getValueAt(193, 1).toString(),
                            jTable1.getValueAt(193, 2).toString(), jTable1.getValueAt(193, 3).toString(),
                            jTable1.getValueAt(193, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("196",
                    new Object[] { jTable1.getValueAt(194, 0).toString(), jTable1.getValueAt(194, 1).toString(),
                            jTable1.getValueAt(194, 2).toString(), jTable1.getValueAt(194, 3).toString(),
                            jTable1.getValueAt(194, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("197",
                    new Object[] { jTable1.getValueAt(195, 0).toString(), jTable1.getValueAt(195, 1).toString(),
                            jTable1.getValueAt(195, 2).toString(), jTable1.getValueAt(195, 3).toString(),
                            jTable1.getValueAt(195, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("198",
                    new Object[] { jTable1.getValueAt(196, 0).toString(), jTable1.getValueAt(196, 1).toString(),
                            jTable1.getValueAt(196, 2).toString(), jTable1.getValueAt(196, 3).toString(),
                            jTable1.getValueAt(196, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("199",
                    new Object[] { jTable1.getValueAt(197, 0).toString(), jTable1.getValueAt(197, 1).toString(),
                            jTable1.getValueAt(197, 2).toString(), jTable1.getValueAt(197, 3).toString(),
                            jTable1.getValueAt(197, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("200",
                    new Object[] { jTable1.getValueAt(198, 0).toString(), jTable1.getValueAt(198, 1).toString(),
                            jTable1.getValueAt(198, 2).toString(), jTable1.getValueAt(198, 3).toString(),
                            jTable1.getValueAt(198, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable1.getRowCount() != i) {
            data.put("201",
                    new Object[] { jTable1.getValueAt(199, 0).toString(), jTable1.getValueAt(199, 1).toString(),
                            jTable1.getValueAt(199, 2).toString(), jTable1.getValueAt(199, 3).toString(),
                            jTable1.getValueAt(199, 4).toString() });
            i++;
        }

        else
            break;

    }

    Set<String> keyset = data.keySet();
    int rownum = 0;
    for (String key : keyset) {
        Row row = sheet.createRow(rownum++);
        Object[] objArr = data.get(key);
        int cellnum = 0;
        for (Object obj : objArr) {
            XSSFCell cell = (XSSFCell) row.createCell(cellnum++);
            if (obj instanceof String)
                cell.setCellValue((String) obj);
            else if (obj instanceof Integer)
                cell.setCellValue((Integer) obj);
        }
    }
    try {
        //Write the workbook in file system

        FileOutputStream out = new FileOutputStream(new File(filename + ".xlsx"));
        workbook.write(out);
        out.close();
        JOptionPane.showMessageDialog(null, "Data exported to excel sheet");
    } catch (Exception e) {
        e.printStackTrace();
    }
}

---

From source file:mymoney.view.java

private void jButton9ActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_jButton9ActionPerformed
    JFileChooser cho = new JFileChooser();
    cho.showSaveDialog(null);// ww  w . j  av a 2s .  c o m
    File f = cho.getSelectedFile();
    String filename = f.getAbsolutePath();
    DefaultTableModel model = (DefaultTableModel) jTable2.getModel();
    XSSFWorkbook workbook = new XSSFWorkbook();
    XSSFSheet sheet = workbook.createSheet("New Data");
    TreeMap<String, Object[]> data = new TreeMap<String, Object[]>();

    data.put("1", new Object[] { "DATE", "NAME", "AMOUNT", "CATEGORY", "TYPE" });
    for (int i = 0;;) {
        if (jTable2.getRowCount() != i) {
            data.put("2",
                    new Object[] { jTable2.getValueAt(0, 0).toString(), jTable2.getValueAt(0, 1).toString(),
                            jTable2.getValueAt(0, 2).toString(), jTable2.getValueAt(0, 3).toString(),
                            jTable2.getValueAt(0, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("3",
                    new Object[] { jTable2.getValueAt(1, 0).toString(), jTable2.getValueAt(1, 1).toString(),
                            jTable2.getValueAt(1, 2).toString(), jTable2.getValueAt(1, 3).toString(),
                            jTable2.getValueAt(1, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("4",
                    new Object[] { jTable2.getValueAt(2, 0).toString(), jTable2.getValueAt(2, 1).toString(),
                            jTable2.getValueAt(2, 2).toString(), jTable2.getValueAt(2, 3).toString(),
                            jTable2.getValueAt(2, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("5",
                    new Object[] { jTable2.getValueAt(3, 0).toString(), jTable2.getValueAt(3, 1).toString(),
                            jTable2.getValueAt(3, 2).toString(), jTable2.getValueAt(3, 3).toString(),
                            jTable2.getValueAt(3, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("6",
                    new Object[] { jTable2.getValueAt(4, 0).toString(), jTable2.getValueAt(4, 1).toString(),
                            jTable2.getValueAt(4, 2).toString(), jTable2.getValueAt(4, 3).toString(),
                            jTable2.getValueAt(4, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("7",
                    new Object[] { jTable2.getValueAt(5, 0).toString(), jTable2.getValueAt(5, 1).toString(),
                            jTable2.getValueAt(5, 2).toString(), jTable2.getValueAt(5, 3).toString(),
                            jTable2.getValueAt(5, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("8",
                    new Object[] { jTable2.getValueAt(6, 0).toString(), jTable2.getValueAt(6, 1).toString(),
                            jTable2.getValueAt(6, 2).toString(), jTable2.getValueAt(6, 3).toString(),
                            jTable2.getValueAt(6, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("9",
                    new Object[] { jTable2.getValueAt(7, 0).toString(), jTable2.getValueAt(7, 1).toString(),
                            jTable2.getValueAt(7, 2).toString(), jTable2.getValueAt(7, 3).toString(),
                            jTable2.getValueAt(7, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("10",
                    new Object[] { jTable2.getValueAt(8, 0).toString(), jTable2.getValueAt(8, 1).toString(),
                            jTable2.getValueAt(8, 2).toString(), jTable2.getValueAt(8, 3).toString(),
                            jTable2.getValueAt(8, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("11",
                    new Object[] { jTable2.getValueAt(9, 0).toString(), jTable2.getValueAt(9, 1).toString(),
                            jTable2.getValueAt(9, 2).toString(), jTable2.getValueAt(9, 3).toString(),
                            jTable2.getValueAt(9, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("12",
                    new Object[] { jTable2.getValueAt(10, 0).toString(), jTable2.getValueAt(10, 1).toString(),
                            jTable2.getValueAt(10, 2).toString(), jTable2.getValueAt(10, 3).toString(),
                            jTable2.getValueAt(10, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("13",
                    new Object[] { jTable2.getValueAt(11, 0).toString(), jTable2.getValueAt(11, 1).toString(),
                            jTable2.getValueAt(11, 2).toString(), jTable2.getValueAt(11, 3).toString(),
                            jTable2.getValueAt(11, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("14",
                    new Object[] { jTable2.getValueAt(12, 0).toString(), jTable2.getValueAt(12, 1).toString(),
                            jTable2.getValueAt(12, 2).toString(), jTable2.getValueAt(12, 3).toString(),
                            jTable2.getValueAt(12, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("15",
                    new Object[] { jTable2.getValueAt(13, 0).toString(), jTable2.getValueAt(13, 1).toString(),
                            jTable2.getValueAt(13, 2).toString(), jTable2.getValueAt(13, 3).toString(),
                            jTable2.getValueAt(13, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("16",
                    new Object[] { jTable2.getValueAt(14, 0).toString(), jTable2.getValueAt(14, 1).toString(),
                            jTable2.getValueAt(14, 2).toString(), jTable2.getValueAt(14, 3).toString(),
                            jTable2.getValueAt(14, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("17",
                    new Object[] { jTable2.getValueAt(15, 0).toString(), jTable2.getValueAt(15, 1).toString(),
                            jTable2.getValueAt(15, 2).toString(), jTable2.getValueAt(15, 3).toString(),
                            jTable2.getValueAt(15, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("18",
                    new Object[] { jTable2.getValueAt(16, 0).toString(), jTable2.getValueAt(16, 1).toString(),
                            jTable2.getValueAt(16, 2).toString(), jTable2.getValueAt(16, 3).toString(),
                            jTable2.getValueAt(16, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("19",
                    new Object[] { jTable2.getValueAt(17, 0).toString(), jTable2.getValueAt(17, 1).toString(),
                            jTable2.getValueAt(17, 2).toString(), jTable2.getValueAt(17, 3).toString(),
                            jTable2.getValueAt(17, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("20",
                    new Object[] { jTable2.getValueAt(18, 0).toString(), jTable2.getValueAt(18, 1).toString(),
                            jTable2.getValueAt(18, 2).toString(), jTable2.getValueAt(18, 3).toString(),
                            jTable2.getValueAt(18, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("21",
                    new Object[] { jTable2.getValueAt(19, 0).toString(), jTable2.getValueAt(19, 1).toString(),
                            jTable2.getValueAt(19, 2).toString(), jTable2.getValueAt(19, 3).toString(),
                            jTable2.getValueAt(19, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("22",
                    new Object[] { jTable2.getValueAt(20, 0).toString(), jTable2.getValueAt(20, 1).toString(),
                            jTable2.getValueAt(20, 2).toString(), jTable2.getValueAt(20, 3).toString(),
                            jTable2.getValueAt(20, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("23",
                    new Object[] { jTable2.getValueAt(21, 0).toString(), jTable2.getValueAt(21, 1).toString(),
                            jTable2.getValueAt(21, 2).toString(), jTable2.getValueAt(21, 3).toString(),
                            jTable2.getValueAt(21, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("24",
                    new Object[] { jTable2.getValueAt(22, 0).toString(), jTable2.getValueAt(22, 1).toString(),
                            jTable2.getValueAt(22, 2).toString(), jTable2.getValueAt(22, 3).toString(),
                            jTable2.getValueAt(22, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("25",
                    new Object[] { jTable2.getValueAt(23, 0).toString(), jTable2.getValueAt(23, 1).toString(),
                            jTable2.getValueAt(23, 2).toString(), jTable2.getValueAt(23, 3).toString(),
                            jTable2.getValueAt(23, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("26",
                    new Object[] { jTable2.getValueAt(24, 0).toString(), jTable2.getValueAt(24, 1).toString(),
                            jTable2.getValueAt(24, 2).toString(), jTable2.getValueAt(24, 3).toString(),
                            jTable2.getValueAt(24, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("27",
                    new Object[] { jTable2.getValueAt(25, 0).toString(), jTable2.getValueAt(25, 1).toString(),
                            jTable2.getValueAt(25, 2).toString(), jTable2.getValueAt(25, 3).toString(),
                            jTable2.getValueAt(25, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("28",
                    new Object[] { jTable2.getValueAt(26, 0).toString(), jTable2.getValueAt(26, 1).toString(),
                            jTable2.getValueAt(26, 2).toString(), jTable2.getValueAt(26, 3).toString(),
                            jTable2.getValueAt(26, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("29",
                    new Object[] { jTable2.getValueAt(27, 0).toString(), jTable2.getValueAt(27, 1).toString(),
                            jTable2.getValueAt(27, 2).toString(), jTable2.getValueAt(27, 3).toString(),
                            jTable2.getValueAt(27, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("30",
                    new Object[] { jTable2.getValueAt(28, 0).toString(), jTable2.getValueAt(28, 1).toString(),
                            jTable2.getValueAt(28, 2).toString(), jTable2.getValueAt(28, 3).toString(),
                            jTable2.getValueAt(28, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("31",
                    new Object[] { jTable2.getValueAt(29, 0).toString(), jTable2.getValueAt(29, 1).toString(),
                            jTable2.getValueAt(29, 2).toString(), jTable2.getValueAt(29, 3).toString(),
                            jTable2.getValueAt(29, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("32",
                    new Object[] { jTable2.getValueAt(30, 0).toString(), jTable2.getValueAt(30, 1).toString(),
                            jTable2.getValueAt(30, 2).toString(), jTable2.getValueAt(30, 3).toString(),
                            jTable2.getValueAt(30, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("33",
                    new Object[] { jTable2.getValueAt(31, 0).toString(), jTable2.getValueAt(31, 1).toString(),
                            jTable2.getValueAt(31, 2).toString(), jTable2.getValueAt(31, 3).toString(),
                            jTable2.getValueAt(31, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("34",
                    new Object[] { jTable2.getValueAt(32, 0).toString(), jTable2.getValueAt(32, 1).toString(),
                            jTable2.getValueAt(32, 2).toString(), jTable2.getValueAt(32, 3).toString(),
                            jTable2.getValueAt(32, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("35",
                    new Object[] { jTable2.getValueAt(33, 0).toString(), jTable2.getValueAt(33, 1).toString(),
                            jTable2.getValueAt(33, 2).toString(), jTable2.getValueAt(33, 3).toString(),
                            jTable2.getValueAt(33, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("36",
                    new Object[] { jTable2.getValueAt(34, 0).toString(), jTable2.getValueAt(34, 1).toString(),
                            jTable2.getValueAt(34, 2).toString(), jTable2.getValueAt(34, 3).toString(),
                            jTable2.getValueAt(34, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("37",
                    new Object[] { jTable2.getValueAt(35, 0).toString(), jTable2.getValueAt(35, 1).toString(),
                            jTable2.getValueAt(35, 2).toString(), jTable2.getValueAt(35, 3).toString(),
                            jTable2.getValueAt(35, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("38",
                    new Object[] { jTable2.getValueAt(36, 0).toString(), jTable2.getValueAt(36, 1).toString(),
                            jTable2.getValueAt(36, 2).toString(), jTable2.getValueAt(36, 3).toString(),
                            jTable2.getValueAt(36, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("39",
                    new Object[] { jTable2.getValueAt(37, 0).toString(), jTable2.getValueAt(37, 1).toString(),
                            jTable2.getValueAt(37, 2).toString(), jTable2.getValueAt(37, 3).toString(),
                            jTable2.getValueAt(37, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("40",
                    new Object[] { jTable2.getValueAt(38, 0).toString(), jTable2.getValueAt(38, 1).toString(),
                            jTable2.getValueAt(38, 2).toString(), jTable2.getValueAt(38, 3).toString(),
                            jTable2.getValueAt(38, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("41",
                    new Object[] { jTable2.getValueAt(39, 0).toString(), jTable2.getValueAt(39, 1).toString(),
                            jTable2.getValueAt(39, 2).toString(), jTable2.getValueAt(39, 3).toString(),
                            jTable2.getValueAt(39, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("42",
                    new Object[] { jTable2.getValueAt(40, 0).toString(), jTable2.getValueAt(40, 1).toString(),
                            jTable2.getValueAt(40, 2).toString(), jTable2.getValueAt(40, 3).toString(),
                            jTable2.getValueAt(40, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("43",
                    new Object[] { jTable2.getValueAt(41, 0).toString(), jTable2.getValueAt(41, 1).toString(),
                            jTable2.getValueAt(41, 2).toString(), jTable2.getValueAt(41, 3).toString(),
                            jTable2.getValueAt(41, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("44",
                    new Object[] { jTable2.getValueAt(42, 0).toString(), jTable2.getValueAt(42, 1).toString(),
                            jTable2.getValueAt(42, 2).toString(), jTable2.getValueAt(42, 3).toString(),
                            jTable2.getValueAt(42, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("45",
                    new Object[] { jTable2.getValueAt(43, 0).toString(), jTable2.getValueAt(43, 1).toString(),
                            jTable2.getValueAt(43, 2).toString(), jTable2.getValueAt(43, 3).toString(),
                            jTable2.getValueAt(43, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("46",
                    new Object[] { jTable2.getValueAt(44, 0).toString(), jTable2.getValueAt(44, 1).toString(),
                            jTable2.getValueAt(44, 2).toString(), jTable2.getValueAt(44, 3).toString(),
                            jTable2.getValueAt(44, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("47",
                    new Object[] { jTable2.getValueAt(45, 0).toString(), jTable2.getValueAt(45, 1).toString(),
                            jTable2.getValueAt(45, 2).toString(), jTable2.getValueAt(45, 3).toString(),
                            jTable2.getValueAt(45, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("48",
                    new Object[] { jTable2.getValueAt(46, 0).toString(), jTable2.getValueAt(46, 1).toString(),
                            jTable2.getValueAt(46, 2).toString(), jTable2.getValueAt(46, 3).toString(),
                            jTable2.getValueAt(46, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("49",
                    new Object[] { jTable2.getValueAt(47, 0).toString(), jTable2.getValueAt(47, 1).toString(),
                            jTable2.getValueAt(47, 2).toString(), jTable2.getValueAt(47, 3).toString(),
                            jTable2.getValueAt(47, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("50",
                    new Object[] { jTable2.getValueAt(48, 0).toString(), jTable2.getValueAt(48, 1).toString(),
                            jTable2.getValueAt(48, 2).toString(), jTable2.getValueAt(48, 3).toString(),
                            jTable2.getValueAt(48, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("51",
                    new Object[] { jTable2.getValueAt(49, 0).toString(), jTable2.getValueAt(49, 1).toString(),
                            jTable2.getValueAt(49, 2).toString(), jTable2.getValueAt(49, 3).toString(),
                            jTable2.getValueAt(49, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("52",
                    new Object[] { jTable2.getValueAt(50, 0).toString(), jTable2.getValueAt(50, 1).toString(),
                            jTable2.getValueAt(50, 2).toString(), jTable2.getValueAt(50, 3).toString(),
                            jTable2.getValueAt(50, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("53",
                    new Object[] { jTable2.getValueAt(51, 0).toString(), jTable2.getValueAt(51, 1).toString(),
                            jTable2.getValueAt(51, 2).toString(), jTable2.getValueAt(51, 3).toString(),
                            jTable2.getValueAt(51, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("54",
                    new Object[] { jTable2.getValueAt(52, 0).toString(), jTable2.getValueAt(52, 1).toString(),
                            jTable2.getValueAt(52, 2).toString(), jTable2.getValueAt(52, 3).toString(),
                            jTable2.getValueAt(52, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("55",
                    new Object[] { jTable2.getValueAt(53, 0).toString(), jTable2.getValueAt(53, 1).toString(),
                            jTable2.getValueAt(53, 2).toString(), jTable2.getValueAt(53, 3).toString(),
                            jTable2.getValueAt(53, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("56",
                    new Object[] { jTable2.getValueAt(54, 0).toString(), jTable2.getValueAt(54, 1).toString(),
                            jTable2.getValueAt(54, 2).toString(), jTable2.getValueAt(54, 3).toString(),
                            jTable2.getValueAt(54, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("57",
                    new Object[] { jTable2.getValueAt(55, 0).toString(), jTable2.getValueAt(55, 1).toString(),
                            jTable2.getValueAt(55, 2).toString(), jTable2.getValueAt(55, 3).toString(),
                            jTable2.getValueAt(55, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("58",
                    new Object[] { jTable2.getValueAt(56, 0).toString(), jTable2.getValueAt(56, 1).toString(),
                            jTable2.getValueAt(56, 2).toString(), jTable2.getValueAt(56, 3).toString(),
                            jTable2.getValueAt(56, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("59",
                    new Object[] { jTable2.getValueAt(57, 0).toString(), jTable2.getValueAt(57, 1).toString(),
                            jTable2.getValueAt(57, 2).toString(), jTable2.getValueAt(57, 3).toString(),
                            jTable2.getValueAt(57, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("60",
                    new Object[] { jTable2.getValueAt(58, 0).toString(), jTable2.getValueAt(58, 1).toString(),
                            jTable2.getValueAt(58, 2).toString(), jTable2.getValueAt(58, 3).toString(),
                            jTable2.getValueAt(58, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("61",
                    new Object[] { jTable2.getValueAt(59, 0).toString(), jTable2.getValueAt(59, 1).toString(),
                            jTable2.getValueAt(59, 2).toString(), jTable2.getValueAt(59, 3).toString(),
                            jTable2.getValueAt(59, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("62",
                    new Object[] { jTable2.getValueAt(60, 0).toString(), jTable2.getValueAt(60, 1).toString(),
                            jTable2.getValueAt(60, 2).toString(), jTable2.getValueAt(60, 3).toString(),
                            jTable2.getValueAt(60, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("63",
                    new Object[] { jTable2.getValueAt(61, 0).toString(), jTable2.getValueAt(61, 1).toString(),
                            jTable2.getValueAt(61, 2).toString(), jTable2.getValueAt(61, 3).toString(),
                            jTable2.getValueAt(61, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("64",
                    new Object[] { jTable2.getValueAt(62, 0).toString(), jTable2.getValueAt(62, 1).toString(),
                            jTable2.getValueAt(62, 2).toString(), jTable2.getValueAt(62, 3).toString(),
                            jTable2.getValueAt(62, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("65",
                    new Object[] { jTable2.getValueAt(63, 0).toString(), jTable2.getValueAt(63, 1).toString(),
                            jTable2.getValueAt(63, 2).toString(), jTable2.getValueAt(63, 3).toString(),
                            jTable2.getValueAt(63, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("66",
                    new Object[] { jTable2.getValueAt(64, 0).toString(), jTable2.getValueAt(64, 1).toString(),
                            jTable2.getValueAt(64, 2).toString(), jTable2.getValueAt(64, 3).toString(),
                            jTable2.getValueAt(64, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("67",
                    new Object[] { jTable2.getValueAt(65, 0).toString(), jTable2.getValueAt(65, 1).toString(),
                            jTable2.getValueAt(65, 2).toString(), jTable2.getValueAt(65, 3).toString(),
                            jTable2.getValueAt(65, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("68",
                    new Object[] { jTable2.getValueAt(66, 0).toString(), jTable2.getValueAt(66, 1).toString(),
                            jTable2.getValueAt(66, 2).toString(), jTable2.getValueAt(66, 3).toString(),
                            jTable2.getValueAt(66, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("69",
                    new Object[] { jTable2.getValueAt(67, 0).toString(), jTable2.getValueAt(67, 1).toString(),
                            jTable2.getValueAt(67, 2).toString(), jTable2.getValueAt(67, 3).toString(),
                            jTable2.getValueAt(67, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("70",
                    new Object[] { jTable2.getValueAt(68, 0).toString(), jTable2.getValueAt(68, 1).toString(),
                            jTable2.getValueAt(68, 2).toString(), jTable2.getValueAt(68, 3).toString(),
                            jTable2.getValueAt(68, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("71",
                    new Object[] { jTable2.getValueAt(69, 0).toString(), jTable2.getValueAt(69, 1).toString(),
                            jTable2.getValueAt(69, 2).toString(), jTable2.getValueAt(69, 3).toString(),
                            jTable2.getValueAt(69, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("72",
                    new Object[] { jTable2.getValueAt(70, 0).toString(), jTable2.getValueAt(70, 1).toString(),
                            jTable2.getValueAt(70, 2).toString(), jTable2.getValueAt(70, 3).toString(),
                            jTable2.getValueAt(70, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("73",
                    new Object[] { jTable2.getValueAt(71, 0).toString(), jTable2.getValueAt(71, 1).toString(),
                            jTable2.getValueAt(71, 2).toString(), jTable2.getValueAt(71, 3).toString(),
                            jTable2.getValueAt(71, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("74",
                    new Object[] { jTable2.getValueAt(72, 0).toString(), jTable2.getValueAt(72, 1).toString(),
                            jTable2.getValueAt(72, 2).toString(), jTable2.getValueAt(72, 3).toString(),
                            jTable2.getValueAt(72, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("75",
                    new Object[] { jTable2.getValueAt(73, 0).toString(), jTable2.getValueAt(73, 1).toString(),
                            jTable2.getValueAt(73, 2).toString(), jTable2.getValueAt(73, 3).toString(),
                            jTable2.getValueAt(73, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("76",
                    new Object[] { jTable2.getValueAt(74, 0).toString(), jTable2.getValueAt(74, 1).toString(),
                            jTable2.getValueAt(74, 2).toString(), jTable2.getValueAt(74, 3).toString(),
                            jTable2.getValueAt(74, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("77",
                    new Object[] { jTable2.getValueAt(75, 0).toString(), jTable2.getValueAt(75, 1).toString(),
                            jTable2.getValueAt(75, 2).toString(), jTable2.getValueAt(75, 3).toString(),
                            jTable2.getValueAt(75, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("78",
                    new Object[] { jTable2.getValueAt(76, 0).toString(), jTable2.getValueAt(76, 1).toString(),
                            jTable2.getValueAt(76, 2).toString(), jTable2.getValueAt(76, 3).toString(),
                            jTable2.getValueAt(76, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("79",
                    new Object[] { jTable2.getValueAt(77, 0).toString(), jTable2.getValueAt(77, 1).toString(),
                            jTable2.getValueAt(77, 2).toString(), jTable2.getValueAt(77, 3).toString(),
                            jTable2.getValueAt(77, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("80",
                    new Object[] { jTable2.getValueAt(78, 0).toString(), jTable2.getValueAt(78, 1).toString(),
                            jTable2.getValueAt(78, 2).toString(), jTable2.getValueAt(78, 3).toString(),
                            jTable2.getValueAt(78, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("81",
                    new Object[] { jTable2.getValueAt(79, 0).toString(), jTable2.getValueAt(79, 1).toString(),
                            jTable2.getValueAt(79, 2).toString(), jTable2.getValueAt(79, 3).toString(),
                            jTable2.getValueAt(79, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("82",
                    new Object[] { jTable2.getValueAt(80, 0).toString(), jTable2.getValueAt(80, 1).toString(),
                            jTable2.getValueAt(80, 2).toString(), jTable2.getValueAt(80, 3).toString(),
                            jTable2.getValueAt(80, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("83",
                    new Object[] { jTable2.getValueAt(81, 0).toString(), jTable2.getValueAt(81, 1).toString(),
                            jTable2.getValueAt(81, 2).toString(), jTable2.getValueAt(81, 3).toString(),
                            jTable2.getValueAt(81, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("84",
                    new Object[] { jTable2.getValueAt(82, 0).toString(), jTable2.getValueAt(82, 1).toString(),
                            jTable2.getValueAt(82, 2).toString(), jTable2.getValueAt(82, 3).toString(),
                            jTable2.getValueAt(82, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("85",
                    new Object[] { jTable2.getValueAt(83, 0).toString(), jTable2.getValueAt(83, 1).toString(),
                            jTable2.getValueAt(83, 2).toString(), jTable2.getValueAt(83, 3).toString(),
                            jTable2.getValueAt(83, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("86",
                    new Object[] { jTable2.getValueAt(84, 0).toString(), jTable2.getValueAt(84, 1).toString(),
                            jTable2.getValueAt(84, 2).toString(), jTable2.getValueAt(84, 3).toString(),
                            jTable2.getValueAt(84, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("87",
                    new Object[] { jTable2.getValueAt(85, 0).toString(), jTable2.getValueAt(85, 1).toString(),
                            jTable2.getValueAt(85, 2).toString(), jTable2.getValueAt(85, 3).toString(),
                            jTable2.getValueAt(85, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("88",
                    new Object[] { jTable2.getValueAt(86, 0).toString(), jTable2.getValueAt(86, 1).toString(),
                            jTable2.getValueAt(86, 2).toString(), jTable2.getValueAt(86, 3).toString(),
                            jTable2.getValueAt(86, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("89",
                    new Object[] { jTable2.getValueAt(87, 0).toString(), jTable2.getValueAt(87, 1).toString(),
                            jTable2.getValueAt(87, 2).toString(), jTable2.getValueAt(87, 3).toString(),
                            jTable2.getValueAt(87, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("90",
                    new Object[] { jTable2.getValueAt(88, 0).toString(), jTable2.getValueAt(88, 1).toString(),
                            jTable2.getValueAt(88, 2).toString(), jTable2.getValueAt(88, 3).toString(),
                            jTable2.getValueAt(88, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("91",
                    new Object[] { jTable2.getValueAt(89, 0).toString(), jTable2.getValueAt(89, 1).toString(),
                            jTable2.getValueAt(89, 2).toString(), jTable2.getValueAt(89, 3).toString(),
                            jTable2.getValueAt(89, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("92",
                    new Object[] { jTable2.getValueAt(90, 0).toString(), jTable2.getValueAt(90, 1).toString(),
                            jTable2.getValueAt(90, 2).toString(), jTable2.getValueAt(90, 3).toString(),
                            jTable2.getValueAt(90, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("93",
                    new Object[] { jTable2.getValueAt(91, 0).toString(), jTable2.getValueAt(91, 1).toString(),
                            jTable2.getValueAt(91, 2).toString(), jTable2.getValueAt(91, 3).toString(),
                            jTable2.getValueAt(91, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("94",
                    new Object[] { jTable2.getValueAt(92, 0).toString(), jTable2.getValueAt(92, 1).toString(),
                            jTable2.getValueAt(92, 2).toString(), jTable2.getValueAt(92, 3).toString(),
                            jTable2.getValueAt(92, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("95",
                    new Object[] { jTable2.getValueAt(93, 0).toString(), jTable2.getValueAt(93, 1).toString(),
                            jTable2.getValueAt(93, 2).toString(), jTable2.getValueAt(93, 3).toString(),
                            jTable2.getValueAt(93, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("96",
                    new Object[] { jTable2.getValueAt(94, 0).toString(), jTable2.getValueAt(94, 1).toString(),
                            jTable2.getValueAt(94, 2).toString(), jTable2.getValueAt(94, 3).toString(),
                            jTable2.getValueAt(94, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("97",
                    new Object[] { jTable2.getValueAt(95, 0).toString(), jTable2.getValueAt(95, 1).toString(),
                            jTable2.getValueAt(95, 2).toString(), jTable2.getValueAt(95, 3).toString(),
                            jTable2.getValueAt(95, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("98",
                    new Object[] { jTable2.getValueAt(96, 0).toString(), jTable2.getValueAt(96, 1).toString(),
                            jTable2.getValueAt(96, 2).toString(), jTable2.getValueAt(96, 3).toString(),
                            jTable2.getValueAt(96, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("99",
                    new Object[] { jTable2.getValueAt(97, 0).toString(), jTable2.getValueAt(97, 1).toString(),
                            jTable2.getValueAt(97, 2).toString(), jTable2.getValueAt(97, 3).toString(),
                            jTable2.getValueAt(97, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("100",
                    new Object[] { jTable2.getValueAt(98, 0).toString(), jTable2.getValueAt(98, 1).toString(),
                            jTable2.getValueAt(98, 2).toString(), jTable2.getValueAt(98, 3).toString(),
                            jTable2.getValueAt(98, 4).toString() });
            i++;
        }

        else
            break;
        if (jTable2.getRowCount() != i) {
            data.put("101",
                    new Object[] { jTable2.getValueAt(99, 0).toString(), jTable2.getValueAt(99, 1).toString(),
                            jTable2.getValueAt(99, 2).toString(), jTable2.getValueAt(99, 3).toString(),
                            jTable2.getValueAt(99, 4).toString() });
            i++;
        }

        else
            break;

    }

    Set<String> keyset = data.keySet();
    int rownum = 0;
    for (String key : keyset) {
        Row row = sheet.createRow(rownum++);
        Object[] objArr = data.get(key);
        int cellnum = 0;
        for (Object obj : objArr) {
            XSSFCell cell = (XSSFCell) row.createCell(cellnum++);
            if (obj instanceof String)
                cell.setCellValue((String) obj);
            else if (obj instanceof Integer)
                cell.setCellValue((Integer) obj);
        }
    }
    try {
        //Write the workbook in file system

        FileOutputStream out = new FileOutputStream(new File(filename + ".xlsx"));
        workbook.write(out);
        out.close();
        JOptionPane.showMessageDialog(null, "Data exported to excel sheet");
    } catch (Exception e) {
        e.printStackTrace();
    } // TODO add your handling code here:
}

---

From source file:nc.noumea.mairie.appock.util.StockSpreadsheetExporter.java

License:Open Source License

private static int createTitle(XSSFWorkbook workbook, XSSFSheet worksheet, Service service) {

    XSSFCellStyle titleStyle = workbook.createCellStyle();
    titleStyle.setAlignment(HorizontalAlignment.CENTER);
    titleStyle.setVerticalAlignment(VerticalAlignment.CENTER);

    XSSFFont txtFont = workbook.createFont();
    txtFont.setFontName("calibri");
    txtFont.setFontHeightInPoints((short) 11);
    txtFont.setBold(true);//from  w  w  w.ja v  a  2  s . co m
    titleStyle.setFont(txtFont);

    XSSFRow row = worksheet.createRow(0);

    XSSFCell cell = row.createCell(0);
    cell.setCellValue(
            "Inventaire " + service.getDirection().getLibelleCourt() + " - " + service.getLibelleCourt());
    cell.setCellStyle(titleStyle);

    worksheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 5));

    return 2;
}

---

From source file:nc.noumea.mairie.appock.util.StockSpreadsheetExporter.java

License:Open Source License

private static int generateHeader(XSSFSheet worksheet, XSSFWorkbook workbook, int rowNum) {
    // Now add//from   w  w  w .j  a  va 2 s. c  o  m
    XSSFRow row = worksheet.createRow(rowNum);
    XSSFCell cell;

    XSSFCellStyle headerStyle = workbook.createCellStyle();
    headerStyle.setFillForegroundColor(IndexedColors.LIGHT_BLUE.index);
    headerStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
    headerStyle.setBorderBottom(BorderStyle.MEDIUM);
    headerStyle.setBorderLeft(BorderStyle.MEDIUM);
    headerStyle.setBorderRight(BorderStyle.MEDIUM);
    headerStyle.setBorderTop(BorderStyle.MEDIUM);
    headerStyle.setAlignment(HorizontalAlignment.CENTER);
    headerStyle.setVerticalAlignment(VerticalAlignment.CENTER);

    XSSFFont txtFont = workbook.createFont();
    txtFont.setFontName("calibri");
    txtFont.setFontHeightInPoints((short) 9);
    txtFont.setBold(true);
    headerStyle.setFont(txtFont);

    cell = row.createCell(0);
    cell.setCellValue("Photo");
    cell.setCellStyle(headerStyle);
    worksheet.setColumnWidth(0, ConvertImageUnits.pixel2WidthUnits(COLUMN_WIDTH_PX));//4387

    cell = row.createCell(1);
    cell.setCellValue("Rfrence");
    cell.setCellStyle(headerStyle);

    cell = row.createCell(2);
    cell.setCellValue("Libell");
    cell.setCellStyle(headerStyle);

    cell = row.createCell(3);
    cell.setCellValue("Stock\n Appock");
    cell.setCellStyle(headerStyle);
    cell.getCellStyle().setWrapText(true);

    cell = row.createCell(4);
    cell.setCellValue("Stock\n rel");
    cell.setCellStyle(headerStyle);
    cell.getCellStyle().setWrapText(true);

    row.setHeight((short) 600);

    return rowNum + 1;
}

---

From source file:nc.noumea.mairie.appock.util.StockSpreadsheetExporter.java

License:Open Source License

private static void createRow(XSSFSheet worksheet, XSSFWorkbook workbook, ArticleStock article,
        CatalogueService catalogueService, int rowNumber) throws IOException {

    int col = 0;//from  w ww  .  j a v a 2 s .  co  m
    XSSFCellStyle cellStyle = workbook.createCellStyle();
    cellStyle.setBorderBottom(BorderStyle.THIN);
    cellStyle.setBorderLeft(BorderStyle.THIN);
    cellStyle.setBorderRight(BorderStyle.THIN);
    cellStyle.setVerticalAlignment(VerticalAlignment.CENTER);

    XSSFCellStyle cellImageStyle = workbook.createCellStyle();
    cellImageStyle.setBorderBottom(BorderStyle.THIN);
    cellImageStyle.setBorderLeft(BorderStyle.THIN);
    cellImageStyle.setBorderRight(BorderStyle.THIN);
    cellImageStyle.setVerticalAlignment(VerticalAlignment.CENTER);
    cellImageStyle.setAlignment(HorizontalAlignment.CENTER);

    if (rowNumber != 1) {
        cellStyle.setBorderTop(BorderStyle.THIN);
    }

    XSSFFont txtFont = workbook.createFont();
    txtFont.setFontName("calibri");
    txtFont.setFontHeightInPoints((short) 9);
    txtFont.setBold(false);
    cellStyle.setFont(txtFont);

    XSSFRow row = worksheet.createRow(rowNumber);
    row.setHeight((short) ROW_HEIGHT_TWIPS);//80px 1600
    // Photo
    File image = null;

    try {
        image = catalogueService.getFilePieceJointe(article.getArticleCatalogue().getPhotoArticleCatalogue());
    } catch (IllegalArgumentException e) {
        log.warn("No image to display for article " + article.getArticleCatalogue().getLibelle());
    }
    XSSFCell cell = row.createCell(col);
    cell.setCellStyle(cellImageStyle);

    if (image != null)
        addImage(workbook, worksheet, image, rowNumber);
    col = col + 1;

    // Rfrence
    cell = row.createCell(col);
    cell.setCellStyle(cellStyle);
    col = col + 1;
    cell.setCellValue(article.getReferenceArticleStock());

    // Libell
    cell = row.createCell(col);
    cell.setCellStyle(cellStyle);
    col = col + 1;
    cell.setCellValue(article.getArticleCatalogue().getLibelle());

    // Appock Stock
    cell = row.createCell(col);
    cell.setCellStyle(cellStyle);
    col = col + 1;
    cell.setCellValue(article.getQuantiteStock());
    cell.setCellType(CellType.NUMERIC);

    // Stock reel
    cell = row.createCell(col);
    cell.setCellStyle(cellStyle);
    cell.setCellType(CellType.NUMERIC);

}

---

From source file:net.clementlevallois.gradingpics.io.Excel.java

public void writeFGradeForOneStudent(String name, String grade) throws FileNotFoundException, IOException {
    XSSFWorkbook workbook;//from   w w  w .ja v  a2 s  .c om
    FileInputStream file = null;
    if (Files.exists(Paths.get("grades_2018.xlsx"))) {
        file = new FileInputStream(new File("grades_2018.xlsx"));
        workbook = new XSSFWorkbook(file);
    } else {
        workbook = new XSSFWorkbook();
    }
    while (workbook.getNumberOfSheets() < 4) {
        workbook.createSheet(String.valueOf(String.valueOf(workbook.getNumberOfSheets() + 1)));
    }
    XSSFSheet sheet = workbook.getSheetAt(1);
    int lastRowNumber = sheet.getLastRowNum();
    //Create a new row in current sheet
    XSSFRow row = sheet.createRow(lastRowNumber + 1);
    //Create a new cell in current row
    XSSFCell cellName = row.createCell(0);
    //Set value to new value
    cellName.setCellValue(name);
    XSSFCell cellGrade = row.createCell(1);
    cellGrade.setCellValue(grade);

    //close the excel file when done        
    if (file != null) {
        file.close();
    }
    FileOutputStream fos = new FileOutputStream(new File("grades_2018.xlsx"));
    workbook.write(fos);
    fos.close();
}

---

From source file:net.mcnewfamily.rmcnew.model.excel.RowEssence.java

License:Open Source License

public XSSFRow toXSSFRow(XSSFSheet xssfSheet, int rowIndex) {
    XSSFRow xssfRow = null;//from ww  w  . j  a v a  2s . c  o m
    if (xssfSheet != null && rowIndex >= 0) {
        xssfRow = xssfSheet.createRow(rowIndex);
        int cellIndex = 0;
        for (CellEssence cellEssence : cellEssences) {
            cellEssence.toXSSFCell(xssfRow, cellIndex++);
        }
    } else {
        throw new IllegalArgumentException(
                "Cannot create XSSFRow on null XSSFSheet or using invalid row index!");
    }
    return xssfRow;
}

---

• «
• 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
• 29
• 30
• 31
• 32
• 33
• 34
• 35
• 36
• 37
• 38
• 39
• 40
• 41
• 42
• 43
• 44
• »