Example usage for org.apache.poi.xssf.usermodel XSSFRow cellIterator

Introduction

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

Prototype

@Override
@SuppressWarnings("unchecked")
public Iterator<Cell> cellIterator() 

Source Link

Document

Cell iterator over the physically defined cells:

 for (Iterator it = row.cellIterator(); it.hasNext(); ) { Cell cell = it.next(); ... 
Usage
From source file:leerArchivos.java
public leerArchivos(File fileName) {
    List cellData = new ArrayList();

    try {/*from www  .ja v  a 2  s.com*/
        FileInputStream fileInputStream = new FileInputStream(fileName);
        XSSFWorkbook workBook = new XSSFWorkbook(fileInputStream);
        XSSFSheet hssfSheet = workBook.getSheetAt(0);
        Iterator rowIterator = hssfSheet.rowIterator();

        while (rowIterator.hasNext()) {
            XSSFRow hssfRow = (XSSFRow) rowIterator.next();
            Iterator iterator = hssfRow.cellIterator();
            List cellTemp = new ArrayList();
            while (iterator.hasNext()) {
                XSSFCell hssfCell = (XSSFCell) iterator.next();
                cellTemp.add(hssfCell);
            }
            cellData.add(cellTemp);
        }

    } catch (Exception e) {
    }
    obtener(cellData);
}
From source file:algoritmos.Recorte.java
private static ArrayList<String> buscarDni(String dni) {
    String dn = null;//from   w  ww  . ja  v  a 2s.  co 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.j  a  va  2s. c om
    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 . co  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;/* w  ww  . ja  va 2  s.co 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;/*www .  j a v a2  s.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 == 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   w w  w.j av 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   ww  w .j a  v a2s  .  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:at.nhmwien.schema_mapping_tool.schemaReaders.XlsxConverter.java
License:Apache License
public LinkedHashMap<String, LinkedHashMap> parseFile(InputStream inputFile) {
    LinkedHashMap<String, LinkedHashMap> fields = null;

    try {/*from   w  w w  .j  ava 2s. c om*/

        XSSFWorkbook workbook = new XSSFWorkbook(inputFile);
        XSSFSheet sheet = workbook.getSheetAt(0);
        XSSFRow row = sheet.getRow(0);

        Iterator<Cell> cellIt = row.cellIterator();

        fields = new LinkedHashMap();

        while (cellIt.hasNext()) {
            Cell currCell = cellIt.next();

            // Ignore any non-string cells (because they are not suitable as headers)
            if (currCell.getCellType() != Cell.CELL_TYPE_STRING)
                continue;

            LinkedHashMap fieldInfo = new LinkedHashMap();
            fieldInfo.put("name", currCell.getStringCellValue());
            fieldInfo.put("subfields", null);

            fields.put(currCell.getStringCellValue(), fieldInfo);
        }

    } catch (Exception e) {
        e.printStackTrace();
    }

    return fields;
}
From source file:br.unesp.rc.desafio.utils.Spreadsheet.java
public static ArrayList<String> ReadXlsxSpreadsheet(File spreadsheet) {

    /*//from   w  w  w.ja v a  2s  .co  m
    Constructing File
    */
    ArrayList values = new ArrayList<String>();
    FileInputStream inputStr = null;
    try {
        inputStr = new FileInputStream(spreadsheet);
    } catch (FileNotFoundException ex) {
        Logger.getLogger(Spreadsheet.class.getName()).log(Level.SEVERE, null, ex);
    }

    Workbook currentSpreadsheetFile = null;

    try {
        XSSFRow row1;
        currentSpreadsheetFile = new XSSFWorkbook(inputStr);
    } catch (IOException ex) {
        Logger.getLogger(Spreadsheet.class.getName()).log(Level.SEVERE, null, ex);
    }

    Sheet sheet = currentSpreadsheetFile.getSheetAt(0);
    Iterator<Row> rowItr = sheet.rowIterator();

    while (rowItr.hasNext()) {
        row1 = (XSSFRow) rowItr.next();
        Iterator<Cell> cellIterator = row1.cellIterator();
        while (cellIterator.hasNext()) {
            String cellValue = "";
            Cell cell = cellIterator.next();

            switch (cell.getCellTypeEnum()) {
            default:
                cellValue = cell.getCellFormula();
                cell.setCellType(CellType.STRING);
                cell.setCellValue(cellValue);
                break;
            case BLANK:
                break;
            case STRING:
                break;
            }
            values.add(cell.getStringCellValue());
            System.out.print(cell.getStringCellValue() + " \t\t ");
        }
        System.out.println();
    }
    try {
        inputStr.close();
    } catch (IOException ex) {
        Logger.getLogger(Spreadsheet.class.getName()).log(Level.SEVERE, null, ex);
    }

    return values;
}
«
1
2
3
4
5
6
7
»