List of usage examples for org.apache.poi.xssf.usermodel XSSFCell getNumericCellValue
@Override public double getNumericCellValue()
From source file:FenetrePrincipal.java
private static String cellToString(XSSFCell cell) { // TODO Auto-generated method stub int type;/*from w w w. j a v a 2s . com*/ Object result; if (cell == null) return (String) (result = ""); type = cell.getCellType(); switch (type) { case 0: result = cell.getNumericCellValue(); break; case 1: result = cell.getStringCellValue(); break; default: throw new RuntimeException("There are no support for this type of cell "); } return result.toString(); }
From source file:algoritmos.Recorte.java
private static ArrayList<String> buscarDni(String dni) { String dn = null;//from w w w.ja v a 2 s. c o m ArrayList<String> lstDni = new ArrayList<String>(); double d = -1; int nd = Integer.parseInt(dni); int ubigeo = 0, max = 0; try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; int v = comparaString(dn, dni); if (v > max) { lstDni = new ArrayList<String>(); lstDni.add(dn); max = v; } else if (v == max) { lstDni.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return lstDni; }
From source file:algoritmos.Recorte.java
private static int buscarUbigeo(String dni) { String dn = null;/*from w w w . ja v a 2 s . co m*/ double d = -1; int ubigeo = 0; if (tryParseInt(dni)) { int nd = Integer.parseInt(dni); try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; } if (dn != null) { if (d == nd) { if (i == 3) { double dh = cell.getNumericCellValue(); ubigeo = (int) dh; return ubigeo; } } } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } } return ubigeo; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaNombre2(String nombre) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;/*from w w w. ja v a 2 s .c o m*/ int max = 0; try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; int v = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 0) { String dh = cell.getStringCellValue(); v = comparaString(dh, nombre); } if (i == 2) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; if (v > max) { dniE = new ArrayList<String>(); dniE.add(dn); max = v; } else if (v == max) { dniE.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaApellido2(String apellido) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;// ww w . j a va2 s .c o m int max = 0; try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; int v = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 1) { String dh = cell.getStringCellValue(); v = comparaString(dh, apellido); } if (i == 2) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; if (v > max) { dniE = new ArrayList<String>(); dniE.add(dn); max = v; } else if (v == max) { dniE.add(dn); } break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaNombre(ArrayList<String> arrNomb) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;//ww w. j a v a 2s. co m try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 0) { String dh = cell.getStringCellValue(); dh = dh.toUpperCase(); for (int j = 0; j < arrNomb.size(); j++) { String nom = arrNomb.get(j).toUpperCase().trim(); if (nom.compareTo(dh) == 0) { nombresE.add(dh); gd = 1; } } if (gd != 1) break; } if (i == 2 && gd == 1) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; dniE.add(dn); break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static ArrayList<String> RevisaApellido(ArrayList<String> arrNomb) { ArrayList<String> nombresE = new ArrayList<String>(); ArrayList<String> dniE = new ArrayList<String>(); int gd = 0;/*from ww w . jav a 2s . c o m*/ try { //InputStream ExcelFileToRead = new FileInputStream("D:/repositorio/GRUPO02/b.rnv.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); while (rows.hasNext()) { gd = 0; row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 1) { String dh = cell.getStringCellValue(); dh = dh.toUpperCase(); for (int j = 0; j < arrNomb.size(); j++) { String nom = arrNomb.get(j).toUpperCase().trim(); if (nom.compareTo(dh) == 0) { nombresE.add(dh); gd = 1; } } if (gd != 1) break; } if (i == 2 && gd == 1) { double d2 = cell.getNumericCellValue(); int num = (int) d2; String dn = num + ""; dniE.add(dn); break; } i++; } i = 0; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } return dniE; }
From source file:algoritmos.Recorte.java
private static void buscarImagenes(String dni) { ImagenHuella = null;/*from w w w. j a v a 2 s .co m*/ ImagenFirma = null; String dn = null; double d = -1; if (tryParseInt(dni)) { int nd = Integer.parseInt(dni); try { // InputStream ExcelFileToRead = new FileInputStream("C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/registro.nacional.v.1.xlsx"); InputStream ExcelFileToRead = new FileInputStream(Recorte.rutaGeneral); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); row = (XSSFRow) rows.next(); int salir = 0; while (rows.hasNext()) { row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); int i = 0; while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (i == 2) { d = cell.getNumericCellValue(); int num = (int) d; dn = num + ""; // System.out.print("dni: "+num+" "); } if (dn != null) { if (d == nd) { if (i == 4) { String dh = cell.getStringCellValue(); String dr = null; dr = Recorte.rutaHuella + "/" + dh + ".jpg"; // dr=Recorte.rutaHuella+"/"+dh; File file = new File(dr); if (!file.exists()) { dr = Recorte.rutaHuella + "/" + dh + ".png"; file = new File(dr); if (!file.exists()) { dr = Recorte.rutaHuella + "/" + dh + ".jpg.png"; file = new File(dr); } ImagenHuella = ImageIO.read(file); } else { ImagenHuella = Algoritmo_Huellas.readImage(file); } // ImagenHuella= ImageIO.read(file); salir = 1; } /* if(i==4){ double dh=cell.getNumericCellValue(); int num=(int) dh; String dr=null; if(num<10){ // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/00"+num+".jpg"; dr=Recorte.rutaHuella+"/00"+num+".jpg"; } else if(num>9 && num<100){ // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/0"+num+".jpg"; dr=Recorte.rutaHuella+"/0"+num+".jpg"; } else{ System.out.println("c"); // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/huellas.jpg/"+num+".jpg"; dr=Recorte.rutaHuella+"/"+num+".jpg"; } File file = new File(dr); ImagenHuella= ImageIO.read(file); // cell=(XSSFCell) cells.next(); // i++; }*/ if (i == 5) { String dh = cell.getStringCellValue(); String dr = null; // dr="C:/Users/Raul/Desktop/inf226.2016.1._06.proyecto/firmas.jpg/"+dh+".jpg"; dr = Recorte.rutaFirma + "/" + dh + ".jpg"; // dr=Recorte.rutaFirma+"/"+dh; File file = new File(dr); if (!file.exists()) { dr = Recorte.rutaFirma + "/" + dh + ".png"; file = new File(dr); if (!file.exists()) { dr = Recorte.rutaFirma + "/" + dh + ".jpg.png"; file = new File(dr); } ImagenFirma = ImageIO.read(file); } else { ImagenFirma = Algoritmo_Huellas.readImage(file); } // ImagenFirma= ImageIO.read(file); salir = 1; } } } i++; } i = 0; if (salir == 1) break; } } catch (FileNotFoundException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(Recorte.class.getName()).log(Level.SEVERE, null, ex); } } }
From source file:CDatos.Excel.java
/** * Lee una hoja de un excel y devuelve una matriz con los datos * @return Matriz con los datos del excel *//*from w w w . j a v a 2 s. c o m*/ public ArrayList getDatosHoja() { ArrayList<ArrayList> filas = new ArrayList(); XSSFSheet sheet = workbook.getSheetAt(hoja); int numColumnas = -1; // Recorremos fila a fila for (int r = 0; r <= sheet.getLastRowNum(); r++) { ArrayList<String> celdas = new ArrayList(); XSSFRow row = sheet.getRow(r); if (row == null) break; else { // En la primera fila se leen las cabeceras, por lo que aprovechamos para // guardar el nmero de columnas porque cuando una fila tiene celdas vacas el tamao // de la lista es menor if (numColumnas == -1) numColumnas = row.getLastCellNum(); // Recorremos celda a celda for (int c = 0; c < numColumnas; c++) { XSSFCell cell = row.getCell(c); String cellValue = ""; if (cell != null) { switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: if (DateUtil.isCellDateFormatted(cell)) { SimpleDateFormat formateador = new SimpleDateFormat("yyyy-MM-dd"); //cellValue = cell.getDateCellValue().toString(); cellValue = formateador.format(cell.getDateCellValue()); } else { cellValue = (Integer.toString((int) cell.getNumericCellValue())); } break; case Cell.CELL_TYPE_STRING: cellValue = cell.getStringCellValue(); break; } } celdas.add(cellValue); } filas.add(celdas); } } return filas; }
From source file:com.appdynamics.jrbronet.projectplan.ExcelManager.java
private static void copyRow(XSSFWorkbook workbook, XSSFSheet sourceWorksheet, int sourceRowNum, XSSFSheet destinationWorksheet, int destinationRowNum) { // Get the source / new row XSSFRow newRow = destinationWorksheet.getRow(destinationRowNum); XSSFRow sourceRow = sourceWorksheet.getRow(sourceRowNum); // If the row exist in destination, push down all rows by 1 else create a new row if (newRow != null) { destinationWorksheet.shiftRows(destinationRowNum, destinationWorksheet.getLastRowNum(), 1); } else {// w ww. j a va2 s.c o m newRow = destinationWorksheet.createRow(destinationRowNum); } // Loop through source columns to add to new row for (int i = 0; i < sourceRow.getLastCellNum(); i++) { // Grab a copy of the old/new cell XSSFCell oldCell = sourceRow.getCell(i); XSSFCell newCell = newRow.createCell(i); // If the old cell is null jump to next cell if (oldCell == null) { newCell = null; continue; } // Copy style from old cell and apply to new cell XSSFCellStyle newCellStyle = workbook.createCellStyle(); newCellStyle.cloneStyleFrom(oldCell.getCellStyle()); ; newCell.setCellStyle(newCellStyle); // If there is a cell comment, copy if (oldCell.getCellComment() != null) { newCell.setCellComment(oldCell.getCellComment()); } // If there is a cell hyperlink, copy if (oldCell.getHyperlink() != null) { newCell.setHyperlink(oldCell.getHyperlink()); } // Set the cell data type newCell.setCellType(oldCell.getCellType()); //newCell.setCellValue(oldCell.getRawValue()); //newCell.setCellType(oldCell.getCellType()); // Set the cell data value switch (oldCell.getCellType()) { case Cell.CELL_TYPE_BLANK: newCell.setCellValue(oldCell.getStringCellValue()); break; case Cell.CELL_TYPE_BOOLEAN: newCell.setCellValue(oldCell.getBooleanCellValue()); break; case Cell.CELL_TYPE_ERROR: newCell.setCellErrorValue(oldCell.getErrorCellValue()); break; case Cell.CELL_TYPE_FORMULA: newCell.setCellFormula(oldCell.getCellFormula()); break; case Cell.CELL_TYPE_NUMERIC: newCell.setCellValue(oldCell.getNumericCellValue()); break; case Cell.CELL_TYPE_STRING: newCell.setCellValue(oldCell.getRichStringCellValue()); break; } } // If there are are any merged regions in the source row, copy to new row /* for (int i = 0; i < worksheet.getNumMergedRegions(); i++) { CellRangeAddress cellRangeAddress = worksheet.getMergedRegion(i); if (cellRangeAddress.getFirstRow() == sourceRow.getRowNum()) { CellRangeAddress newCellRangeAddress = new CellRangeAddress(newRow.getRowNum(), (newRow.getRowNum() + (cellRangeAddress.getLastRow() - cellRangeAddress.getFirstRow() )), cellRangeAddress.getFirstColumn(), cellRangeAddress.getLastColumn()); worksheet.addMergedRegion(newCellRangeAddress); } } */ }