List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook write
@SuppressWarnings("resource") public final void write(OutputStream stream) throws IOException
From source file:mvjce.Writesheet.java
public static void writesheet() { XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet spreadsheet = workbook.createSheet(sem_string + sec); XSSFRow row = spreadsheet.createRow((short) 0); XSSFCell cell = (XSSFCell) row.createCell((short) 0); cell.setCellValue("MVJ College of Bangalore- 560067"); //MEARGING CELLS spreadsheet.addMergedRegion(new CellRangeAddress(0, 0, 0, 19)); XSSFFont font = workbook.createFont(); font.setFontName("Arial"); font.setBold(true);/*from w ww . j a v a 2 s .co m*/ XSSFCellStyle style = workbook.createCellStyle(); style.setAlignment(XSSFCellStyle.ALIGN_CENTER); style.setVerticalAlignment(XSSFCellStyle.VERTICAL_CENTER); style.setWrapText(true); style.setFont(font); cell.setCellStyle(style); Excel_operations.set_subcode(); for (int i = 0; i < 8; i++) { internal_sheet.sub[i] = sub[i]; } internal_sheet.dept_name = dept_name; internal_sheet.sec = sec; internal_sheet.sem_string = sem_string; internal_sheet.internal_details(workbook); row = spreadsheet.createRow((short) 1); cell = (XSSFCell) row.createCell((short) 0); cell.setCellValue("Department of " + dept_name); spreadsheet.addMergedRegion(new CellRangeAddress(1, 1, 0, 19)); cell.setCellStyle(style); row = spreadsheet.createRow(4); row.setHeight((short) 600); cell = (XSSFCell) row.createCell((short) 1); cell.setCellValue("Semester: \n" + sem_string + sec); cell.setCellStyle(style); row = spreadsheet.createRow(5); String[] text = new String[3]; text[0] = "SI.No"; text[1] = "USN"; text[2] = "STUDENT\nNAME"; for (int i = 0; i < 3; i++) { cell = (XSSFCell) row.createCell((short) i); cell.setCellValue(text[i]); cell.setCellStyle(style); spreadsheet.addMergedRegion(new CellRangeAddress(5, 7, i, i)); } int j = 0; XSSFRow row1 = spreadsheet.createRow((short) 6); row1.setHeight((short) 1000); XSSFRow row2 = spreadsheet.createRow((short) 7); row2.setHeight((short) 1000); for (int i = 3; i < 18; i++) { cell = row1.createCell((short) i); cell.setCellValue("Total no. of classes"); cell.setCellStyle(style); cell = row2.createCell((short) i); cell.setCellValue("No.of Classes attended"); cell.setCellStyle(style); cell = row2.createCell((short) i + 1); cell.setCellValue("%"); cell.setCellStyle(style); cell = row.createCell((short) i); cell.setCellValue(sub[j]); j++; cell.setCellStyle(style); spreadsheet.addMergedRegion(new CellRangeAddress(5, 5, i, i + 1)); i++; } cell = row1.createCell((short) 19); cell.setCellValue("%"); cell.setCellStyle(style); cell = row.createCell((short) 19); cell.setCellValue("AVG"); cell.setCellStyle(style); spreadsheet.addMergedRegion(new CellRangeAddress(5, 5, 19, 19)); Excel_operations.fill_exceldata(workbook, spreadsheet); try { FileOutputStream out = new FileOutputStream(new File("test_excel.xlsx")); workbook.write(out); out.close(); } catch (Exception e) { Database.print_error("Excel_output_stream"); } System.out.println("typesofcells.xlsx written successfully"); }
From source file:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java
License:Open Source License
@SuppressWarnings("unchecked") @Override// ww w . j av a 2 s.co m public void arreglaFechas(OutputStream out) { log.debug("Arreglando fechas"); Date inicio = new Date(); XSSFWorkbook wb = new XSSFWorkbook(); CreationHelper createHelper = wb.getCreationHelper(); CellStyle cellStyle = wb.createCellStyle(); cellStyle.setDataFormat(createHelper.createDataFormat().getFormat("dd/mm/yyyy")); XSSFSheet fechas = wb.createSheet("FECHAS-ANTERIORES"); int fechasRow = 0; XSSFSheet fechas2 = wb.createSheet("FECHAS-POSTERIORES"); int fechas2Row = 0; Transaction tx = null; try { tx = currentSession().beginTransaction(); Query update = currentSession() .createQuery("update Activo set fechaCompra = :fechaCompra where id = :id"); Query query = currentSession().createQuery( "select new Activo(a.id, a.descripcion, a.fechaCompra, a.tipoActivo.cuenta.id.idCtaMayor, a.centroCosto.id.idCosto, a.codigo) from Activo a where a.fechaCompra < :fechaCompra order by a.tipoActivo.cuenta.id.idCtaMayor, a.centroCosto.id.idCosto, a.codigo"); SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy"); query.setDate("fechaCompra", sdf.parse("01/01/1970")); List<Activo> activos = query.list(); int cont = 0; for (Activo activo : activos) { Calendar cal1 = Calendar.getInstance(); cal1.setTime(activo.getFechaCompra()); if (cal1.get(Calendar.YEAR) < 10) { log.debug("Pasando al ao 2000 {} - {}", activo.getDescripcion(), activo.getFechaCompra()); cal1.add(Calendar.YEAR, 2000); update.setDate("fechaCompra", cal1.getTime()); update.setLong("id", activo.getId()); update.executeUpdate(); XSSFRow renglon = fechas.createRow(fechasRow++); renglon.createCell(0).setCellValue(activo.getTipoActivoCuenta()); renglon.createCell(1).setCellValue(activo.getCentroCostoCuenta()); renglon.createCell(2).setCellValue(activo.getCodigo()); renglon.createCell(3).setCellValue(activo.getDescripcion()); renglon.createCell(4).setCellValue(sdf.format(activo.getFechaCompra())); Cell cell = renglon.createCell(5); cell.setCellValue(cal1.getTime()); cell.setCellStyle(cellStyle); } else if (cal1.get(Calendar.YEAR) < 100) { log.debug("Pasando al ao 1900 {} - {}", activo.getDescripcion(), activo.getFechaCompra()); cal1.add(Calendar.YEAR, 1900); update.setDate("fechaCompra", cal1.getTime()); update.setLong("id", activo.getId()); update.executeUpdate(); XSSFRow renglon = fechas.createRow(fechasRow++); renglon.createCell(0).setCellValue(activo.getTipoActivoCuenta()); renglon.createCell(1).setCellValue(activo.getCentroCostoCuenta()); renglon.createCell(2).setCellValue(activo.getCodigo()); renglon.createCell(3).setCellValue(activo.getDescripcion()); renglon.createCell(4).setCellValue(sdf.format(activo.getFechaCompra())); Cell cell = renglon.createCell(5); cell.setCellValue(cal1.getTime()); cell.setCellStyle(cellStyle); } else if (cal1.get(Calendar.YEAR) >= 1900 && cal1.get(Calendar.YEAR) <= 1912) { log.debug("Pasando al ao 2000 {} - {}", activo.getDescripcion(), activo.getFechaCompra()); cal1.add(Calendar.YEAR, 100); update.setDate("fechaCompra", cal1.getTime()); update.setLong("id", activo.getId()); update.executeUpdate(); XSSFRow renglon = fechas.createRow(fechasRow++); renglon.createCell(0).setCellValue(activo.getTipoActivoCuenta()); renglon.createCell(1).setCellValue(activo.getCentroCostoCuenta()); renglon.createCell(2).setCellValue(activo.getCodigo()); renglon.createCell(3).setCellValue(activo.getDescripcion()); renglon.createCell(4).setCellValue(sdf.format(activo.getFechaCompra())); Cell cell = renglon.createCell(5); cell.setCellValue(cal1.getTime()); cell.setCellStyle(cellStyle); } cont++; } currentSession().flush(); query = currentSession().createQuery( "select new Activo(a.id, a.descripcion, a.fechaCompra, a.tipoActivo.cuenta.id.idCtaMayor, a.centroCosto.id.idCosto, a.codigo) from Activo a where a.fechaCompra > :fechaCompra order by a.tipoActivo.cuenta.id.idCtaMayor, a.centroCosto.id.idCosto, a.codigo"); query.setDate("fechaCompra", new Date()); activos = query.list(); for (Activo activo : activos) { Calendar cal1 = Calendar.getInstance(); cal1.setTime(activo.getFechaCompra()); if (cal1.get(Calendar.YEAR) < 2020) { log.debug("Quitandole 10 anios {} - {}", activo.getDescripcion(), activo.getFechaCompra()); cal1.add(Calendar.YEAR, -10); update.setDate("fechaCompra", cal1.getTime()); update.setLong("id", activo.getId()); update.executeUpdate(); XSSFRow renglon = fechas2.createRow(fechas2Row++); renglon.createCell(0).setCellValue(activo.getTipoActivoCuenta()); renglon.createCell(1).setCellValue(activo.getCentroCostoCuenta()); renglon.createCell(2).setCellValue(activo.getCodigo()); renglon.createCell(3).setCellValue(activo.getDescripcion()); renglon.createCell(4).setCellValue(sdf.format(activo.getFechaCompra())); Cell cell = renglon.createCell(5); cell.setCellValue(cal1.getTime()); cell.setCellStyle(cellStyle); } else if (cal1.get(Calendar.YEAR) >= 2020) { log.debug("Pasando al ao 1900 {} - {}", activo.getDescripcion(), activo.getFechaCompra()); cal1.add(Calendar.YEAR, -100); update.setDate("fechaCompra", cal1.getTime()); update.setLong("id", activo.getId()); update.executeUpdate(); XSSFRow renglon = fechas2.createRow(fechas2Row++); renglon.createCell(0).setCellValue(activo.getTipoActivoCuenta()); renglon.createCell(1).setCellValue(activo.getCentroCostoCuenta()); renglon.createCell(2).setCellValue(activo.getCodigo()); renglon.createCell(3).setCellValue(activo.getDescripcion()); renglon.createCell(4).setCellValue(sdf.format(activo.getFechaCompra())); Cell cell = renglon.createCell(5); cell.setCellValue(cal1.getTime()); cell.setCellStyle(cellStyle); } cont++; } currentSession().flush(); tx.commit(); log.debug("Termino actualizando {} de {} en {}", new Object[] { cont, activos.size(), ((new Date().getTime() - inicio.getTime()) / 1000) }); wb.write(out); } catch (ParseException | HibernateException | IOException e) { log.error("No se pudieron arreglar las fechas de los activos", e); tx.rollback(); throw new RuntimeException("No se pudieron arreglar las fechas de los actios", e); } }
From source file:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java
License:Open Source License
@Override @SuppressWarnings("unchecked") public void sube(byte[] datos, Usuario usuario, OutputStream out, Integer codigoInicial) { Date inicio = new Date(); int idx = 5;/*w ww . j av a 2 s . c om*/ int i = 0; SimpleDateFormat sdf = new SimpleDateFormat("dd/MM/yyyy"); SimpleDateFormat sdf2 = new SimpleDateFormat("dd/MM/yy"); SimpleDateFormat sdf3 = new SimpleDateFormat("dd-MM-yy"); MathContext mc = new MathContext(16, RoundingMode.HALF_UP); NumberFormat nf = NumberFormat.getInstance(); nf.setGroupingUsed(false); nf.setMaximumFractionDigits(0); nf.setMinimumIntegerDigits(5); Transaction tx = null; try { String ejercicioId = "001-2013"; Map<String, CentroCosto> centrosDeCosto = new HashMap<>(); Map<String, TipoActivo> tipos = new HashMap<>(); Query tipoActivoQuery = currentSession() .createQuery("select ta from TipoActivo ta " + "where ta.empresa.id = :empresaId " + "and ta.cuenta.id.ejercicio.id.idEjercicio = :ejercicioId " + "and ta.cuenta.id.ejercicio.id.organizacion.id = :organizacionId"); log.debug("empresaId: {}", usuario.getEmpresa().getId()); log.debug("ejercicioId: {}", ejercicioId); log.debug("organizacionId: {}", usuario.getEmpresa().getOrganizacion().getId()); tipoActivoQuery.setLong("empresaId", usuario.getEmpresa().getId()); tipoActivoQuery.setString("ejercicioId", ejercicioId); tipoActivoQuery.setLong("organizacionId", usuario.getEmpresa().getOrganizacion().getId()); List<TipoActivo> listaTipos = tipoActivoQuery.list(); for (TipoActivo tipoActivo : listaTipos) { tipos.put(tipoActivo.getCuenta().getId().getIdCtaMayor(), tipoActivo); } log.debug("TIPOS: {}", tipos); Query proveedorQuery = currentSession().createQuery( "select p from Proveedor p where p.empresa.id = :empresaId and p.nombre = :nombreEmpresa"); proveedorQuery.setLong("empresaId", usuario.getEmpresa().getId()); proveedorQuery.setString("nombreEmpresa", usuario.getEmpresa().getNombre()); Proveedor proveedor = (Proveedor) proveedorQuery.uniqueResult(); Query codigoDuplicadoQuery = currentSession() .createQuery("select a from Activo a where a.empresa.id = :empresaId and a.codigo = :codigo"); XSSFWorkbook workbook = new XSSFWorkbook(new ByteArrayInputStream(datos)); FormulaEvaluator evaluator = workbook.getCreationHelper().createFormulaEvaluator(); XSSFWorkbook wb = new XSSFWorkbook(); XSSFSheet ccostoFantasma = wb.createSheet("CCOSTO-FANTASMAS"); int ccostoFantasmaRow = 0; XSSFSheet sinCCosto = wb.createSheet("SIN-CCOSTO"); int sinCCostoRow = 0; XSSFSheet codigoAsignado = wb.createSheet("CODIGO-ASIGNADO"); int codigoAsignadoRow = 0; XSSFSheet fechaInvalida = wb.createSheet("FECHA-INVALIDA"); int fechaInvalidaRow = 0; XSSFSheet sinCosto = wb.createSheet("SIN-COSTO"); int sinCostoRow = 0; //tx = currentSession().beginTransaction(); for (idx = 5; idx <= 5; idx++) { XSSFSheet sheet = workbook.getSheetAt(idx); int rows = sheet.getPhysicalNumberOfRows(); for (i = 2; i < rows; i++) { log.debug("Leyendo pagina {} renglon {}", idx, i); XSSFRow row = sheet.getRow(i); if (row.getCell(0) == null) { break; } String nombreGrupo = row.getCell(0).getStringCellValue().trim(); switch (row.getCell(0).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: nombreGrupo = row.getCell(0).toString().trim(); break; case XSSFCell.CELL_TYPE_STRING: nombreGrupo = row.getCell(0).getStringCellValue().trim(); break; } TipoActivo tipoActivo = tipos.get(nombreGrupo); if (tipoActivo != null) { String cuentaCCosto = row.getCell(2).toString().trim(); if (StringUtils.isNotBlank(cuentaCCosto)) { CentroCosto centroCosto = centrosDeCosto.get(cuentaCCosto); if (centroCosto == null) { Query ccostoQuery = currentSession().createQuery("select cc from CentroCosto cc " + "where cc.id.ejercicio.id.idEjercicio = :ejercicioId " + "and cc.id.ejercicio.id.organizacion.id = :organizacionId " + "and cc.id.idCosto like :idCosto"); ccostoQuery.setString("ejercicioId", ejercicioId); ccostoQuery.setLong("organizacionId", usuario.getEmpresa().getOrganizacion().getId()); ccostoQuery.setString("idCosto", "1.01." + cuentaCCosto); ccostoQuery.setMaxResults(1); List<CentroCosto> listaCCosto = ccostoQuery.list(); if (listaCCosto != null && listaCCosto.size() > 0) { centroCosto = listaCCosto.get(0); } if (centroCosto == null) { XSSFRow renglon = ccostoFantasma.createRow(ccostoFantasmaRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9).setCellValue(row.getCell(8).toString()); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); continue; } centrosDeCosto.put(cuentaCCosto, centroCosto); } String poliza = null; switch (row.getCell(4).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: poliza = row.getCell(4).toString(); poliza = StringUtils.removeEnd(poliza, ".0"); log.debug("POLIZA-N: {}", poliza); break; case XSSFCell.CELL_TYPE_STRING: poliza = row.getCell(4).getStringCellValue().trim(); log.debug("POLIZA-S: {}", poliza); break; } Boolean seguro = false; if (row.getCell(5) != null && StringUtils.isNotBlank(row.getCell(5).toString())) { seguro = true; } Boolean garantia = false; if (row.getCell(6) != null && StringUtils.isNotBlank(row.getCell(6).toString())) { garantia = true; } Date fechaCompra = null; if (row.getCell(7) != null) { log.debug("VALIDANDO FECHA"); XSSFCell cell = row.getCell(7); switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: log.debug("ES NUMERIC"); if (DateUtil.isCellDateFormatted(cell)) { log.debug("ES FECHA"); fechaCompra = cell.getDateCellValue(); } else if (DateUtil.isCellInternalDateFormatted(cell)) { log.debug("ES FECHA INTERNAL"); fechaCompra = cell.getDateCellValue(); } else { BigDecimal bd = new BigDecimal(cell.getNumericCellValue()); bd = stripTrailingZeros(bd); log.debug("CONVIRTIENDO DOUBLE {} - {}", DateUtil.isValidExcelDate(bd.doubleValue()), bd); fechaCompra = HSSFDateUtil.getJavaDate(bd.longValue(), true); log.debug("Cal: {}", fechaCompra); } break; case Cell.CELL_TYPE_FORMULA: log.debug("ES FORMULA"); CellValue cellValue = evaluator.evaluate(cell); switch (cellValue.getCellType()) { case Cell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { fechaCompra = DateUtil.getJavaDate(cellValue.getNumberValue(), true); } } } } if (row.getCell(7) != null && fechaCompra == null) { String fechaCompraString; if (row.getCell(7).getCellType() == Cell.CELL_TYPE_STRING) { fechaCompraString = row.getCell(7).getStringCellValue(); } else { fechaCompraString = row.getCell(7).toString().trim(); } try { fechaCompra = sdf.parse(fechaCompraString); } catch (ParseException e) { try { fechaCompra = sdf2.parse(fechaCompraString); } catch (ParseException e2) { try { fechaCompra = sdf3.parse(fechaCompraString); } catch (ParseException e3) { // no se pudo convertir } } } } if (fechaCompra == null) { XSSFRow renglon = fechaInvalida.createRow(fechaInvalidaRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9).setCellValue(row.getCell(8).toString()); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); continue; } String codigo = null; switch (row.getCell(8).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: codigo = row.getCell(8).toString(); break; case XSSFCell.CELL_TYPE_STRING: codigo = row.getCell(8).getStringCellValue().trim(); break; } if (StringUtils.isBlank(codigo)) { codigo = "SIN CODIGO" + nf.format(codigoInicial); XSSFRow renglon = codigoAsignado.createRow(codigoAsignadoRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9).setCellValue("SIN CODIGO" + codigoInicial); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); codigoInicial++; } else { // busca codigo duplicado if (codigo.contains(".")) { codigo = codigo.substring(0, codigo.lastIndexOf(".")); log.debug("CODIGO: {}", codigo); } codigoDuplicadoQuery.setLong("empresaId", usuario.getEmpresa().getId()); codigoDuplicadoQuery.setString("codigo", codigo); Activo activo = (Activo) codigoDuplicadoQuery.uniqueResult(); if (activo != null) { XSSFRow renglon = codigoAsignado.createRow(codigoAsignadoRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9) .setCellValue(codigo + "-" + "SIN CODIGO" + nf.format(codigoInicial)); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); codigo = "SIN CODIGO" + nf.format(codigoInicial); codigoInicial++; } } String descripcion = null; if (row.getCell(9) != null) { switch (row.getCell(9).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: descripcion = row.getCell(9).toString(); descripcion = StringUtils.removeEnd(descripcion, ".0"); break; case XSSFCell.CELL_TYPE_STRING: descripcion = row.getCell(9).getStringCellValue().trim(); break; default: descripcion = row.getCell(9).toString().trim(); } } String marca = null; if (row.getCell(10) != null) { switch (row.getCell(10).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: marca = row.getCell(10).toString(); marca = StringUtils.removeEnd(marca, ".0"); break; case XSSFCell.CELL_TYPE_STRING: marca = row.getCell(10).getStringCellValue().trim(); break; default: marca = row.getCell(10).toString().trim(); } } String modelo = null; if (row.getCell(11) != null) { switch (row.getCell(11).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: modelo = row.getCell(11).toString(); modelo = StringUtils.removeEnd(modelo, ".0"); break; case XSSFCell.CELL_TYPE_STRING: modelo = row.getCell(11).getStringCellValue().trim(); break; default: modelo = row.getCell(11).toString().trim(); } } String serie = null; if (row.getCell(12) != null) { switch (row.getCell(12).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: serie = row.getCell(12).toString(); serie = StringUtils.removeEnd(serie, ".0"); break; case XSSFCell.CELL_TYPE_STRING: serie = row.getCell(12).getStringCellValue().trim(); break; default: serie = row.getCell(12).toString().trim(); } } String responsable = null; if (row.getCell(13) != null) { switch (row.getCell(13).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: responsable = row.getCell(13).toString(); responsable = StringUtils.removeEnd(responsable, ".0"); break; case XSSFCell.CELL_TYPE_STRING: responsable = row.getCell(13).getStringCellValue().trim(); break; default: responsable = row.getCell(13).toString().trim(); } } String ubicacion = null; if (row.getCell(14) != null) { switch (row.getCell(14).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: ubicacion = row.getCell(14).toString(); ubicacion = StringUtils.removeEnd(ubicacion, ".0"); break; case XSSFCell.CELL_TYPE_STRING: ubicacion = row.getCell(14).getStringCellValue().trim(); break; default: ubicacion = row.getCell(14).toString().trim(); } } BigDecimal costo = null; switch (row.getCell(15).getCellType()) { case XSSFCell.CELL_TYPE_NUMERIC: costo = new BigDecimal(row.getCell(15).getNumericCellValue(), mc); log.debug("COSTO-N: {} - {}", costo, row.getCell(15).getNumericCellValue()); break; case XSSFCell.CELL_TYPE_STRING: costo = new BigDecimal(row.getCell(15).toString(), mc); log.debug("COSTO-S: {} - {}", costo, row.getCell(15).toString()); break; case XSSFCell.CELL_TYPE_FORMULA: costo = new BigDecimal( evaluator.evaluateInCell(row.getCell(15)).getNumericCellValue(), mc); log.debug("COSTO-F: {}", costo); } if (costo == null) { XSSFRow renglon = sinCosto.createRow(sinCostoRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9).setCellValue(row.getCell(8).toString()); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); continue; } Activo activo = new Activo(fechaCompra, seguro, garantia, poliza, codigo, descripcion, marca, modelo, serie, responsable, ubicacion, costo, tipoActivo, centroCosto, proveedor, usuario.getEmpresa()); this.crea(activo, usuario); } else { XSSFRow renglon = sinCCosto.createRow(sinCCostoRow++); renglon.createCell(0).setCellValue(sheet.getSheetName() + ":" + (i + 1)); renglon.createCell(1).setCellValue(row.getCell(0).toString()); renglon.createCell(2).setCellValue(row.getCell(1).toString()); renglon.createCell(3).setCellValue(row.getCell(2).toString()); renglon.createCell(4).setCellValue(row.getCell(3).toString()); renglon.createCell(5).setCellValue(row.getCell(4).toString()); renglon.createCell(6).setCellValue(row.getCell(5).toString()); renglon.createCell(7).setCellValue(row.getCell(6).toString()); renglon.createCell(8).setCellValue(row.getCell(7).toString()); renglon.createCell(9).setCellValue(row.getCell(8).toString()); renglon.createCell(10).setCellValue(row.getCell(9).toString()); renglon.createCell(11).setCellValue(row.getCell(10).toString()); renglon.createCell(12).setCellValue(row.getCell(11).toString()); renglon.createCell(13).setCellValue(row.getCell(12).toString()); renglon.createCell(14).setCellValue(row.getCell(13).toString()); renglon.createCell(15).setCellValue(row.getCell(14).toString()); renglon.createCell(16).setCellValue(row.getCell(15).toString()); continue; } } else { throw new RuntimeException( "(" + idx + ":" + i + ") No se encontro el tipo de activo " + nombreGrupo); } } } //tx.commit(); log.debug("################################################"); log.debug("################################################"); log.debug("TERMINO EN {} MINS", (new Date().getTime() - inicio.getTime()) / (1000 * 60)); log.debug("################################################"); log.debug("################################################"); wb.write(out); } catch (IOException | RuntimeException e) { //if (tx != null && tx.isActive()) { //tx.rollback(); //} log.error("Hubo problemas al intentar pasar datos de archivo excel a BD (" + idx + ":" + i + ")", e); throw new RuntimeException( "Hubo problemas al intentar pasar datos de archivo excel a BD (" + idx + ":" + i + ")", e); } }
From source file:mx.edu.um.mateo.activos.dao.impl.ActivoDaoHibernate.java
License:Open Source License
@Override @Transactional(readOnly = true)/* w w w .j av a 2 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)/* ww w .j a va 2s. com*/ 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);//from w w w. j a v a 2 s . c o 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);//from ww w . j av a 2s. com 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);/*from www . ja va 2 s . com*/ 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
public static void createSpreadsheet(Service service, List<ArticleStock> articleStockList, CatalogueService catalogueService, OutputStream out) throws JAXBException, Docx4JException, IOException { XSSFWorkbook workbook = new XSSFWorkbook(); XSSFSheet worksheet = workbook.createSheet("Inventaire"); Integer rowNumber = 0;//from w w w .j a v a 2 s. c o m rowNumber = generateHeader(worksheet, workbook, rowNumber); generateLineOfStock(worksheet, workbook, articleStockList, catalogueService, rowNumber); autosize(workbook); workbook.write(out); out.flush(); out.close(); }
From source file:nc.noumea.mairie.appock.util.StockSpreadsheetExporterImporterTest.java
License:Open Source License
@Test public void test() throws Exception { AppUser appUser = authHelper.getCurrentUser(); Service service = ajouterServiceToAppUser(appUser); List<ArticleStock> listeArticleStock = genererListeArticleStock(service); File exportFile = File.createTempFile("stock_test_export-", ".xlsx"); logger.info("Export pour inventaire : " + exportFile); // Export/*from ww w . j a va 2s . c o m*/ StockSpreadsheetExporter.exportToXls(service, listeArticleStock, catalogueService, new FileOutputStream(exportFile)); XSSFWorkbook workbookExport = new XSSFWorkbook(exportFile); XSSFSheet worksheet = workbookExport.getSheet("Inventaire"); Assert.assertNotNull(worksheet); // Verif for (int i = 0; i < worksheet.getLastRowNum(); i++) { XSSFRow row = worksheet.getRow(i); int col = 0; if (i == 0) { Assert.assertEquals("Photo", row.getCell(col++).getStringCellValue()); Assert.assertEquals("Rfrence", row.getCell(col++).getStringCellValue()); Assert.assertEquals("Libell", row.getCell(col++).getStringCellValue()); Assert.assertEquals("Stock\n Appock", row.getCell(col++).getStringCellValue()); Assert.assertEquals("Stock\n rel", row.getCell(col++).getStringCellValue()); } else { col++; Assert.assertEquals("REF_" + (i - 1), row.getCell(col++).getStringCellValue()); Assert.assertEquals("ARTICLE CATALOGUE " + (i - 1), row.getCell(col++).getStringCellValue()); Assert.assertEquals(i, (long) row.getCell(col++).getNumericCellValue()); } } // Import : toutes les quantits ont t augments de 1 File importFile1 = File.createTempFile("stock_test_import1-", ".xlsx"); logger.info("Import de l'inventaire : " + importFile1); OutputStream outputStream1 = new FileOutputStream(importFile1); XSSFWorkbook workbookImport = new XSSFWorkbook(exportFile); XSSFSheet worksheetImport = workbookImport.getSheet("Inventaire"); for (int i = 1; i < worksheetImport.getLastRowNum() + 1; i++) { XSSFRow row = worksheetImport.getRow(i); if (i == 5) { // Cellule en erreur row.getCell(4).setCellValue(" 05 "); } else { row.getCell(4).setCellValue(row.getCell(3).getNumericCellValue() + 1); } } workbookImport.write(outputStream1); outputStream1.flush(); outputStream1.close(); List<String> warnings = StockSpreadsheetImporter.importFromXls(service, stockService, new FileInputStream(importFile1)); // Verif Stock stock = stockService.findOne(service.getStock().getId()); Assert.assertEquals(10, stock.getListeArticleStock().size()); Assert.assertEquals(1, warnings.size()); logger.info("Warning message : " + warnings.get(0)); for (int i = 0; i < stock.getListeArticleStock().size(); i++) { ArticleStock articleStock = stock.getListeArticleStock().get(i); int oldQunatite = i + 1; if (i == 4) { // Quantit inchange Assert.assertEquals(oldQunatite, (int) articleStock.getQuantiteStock()); } else { Assert.assertEquals(oldQunatite + 1, (int) articleStock.getQuantiteStock()); } } }