Example usage for org.apache.poi.ss.usermodel Row cellIterator

List of usage examples for org.apache.poi.ss.usermodel Row cellIterator

  1. HOME
  2. Java
  3. org.apache.poi
  4. org.apache.poi.ss.usermodel.*
  5. Row
  6. cellIterator

Introduction

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

Prototype

Iterator<Cell> cellIterator();

Source Link

Usage

From source file:pl.ulit.xsl.handler.OgraniczenieWiekuSheet.java

@Override
public void read() {
    int kodOgraniczeniaWieku;
    int ponizejGornaGranica;
    int pomiedzyDolnaGranica;
    int pomiedzyGornaGranica;
    int powyzejDolnaGranica;
    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 4);//w  ww.  j  a  va 2  s  .  c om

    while (rowIterator.hasNext()) {

        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        kodOgraniczeniaWieku = getKodOgraniczeniaWieku(cellIterator);
        ponizejGornaGranica = getPonizejGornaGranica(cellIterator);
        pomiedzyDolnaGranica = getPomiedzyDolnaGranica(cellIterator);
        pomiedzyGornaGranica = getPomiedzyGornaGranica(cellIterator);
        powyzejDolnaGranica = getPomiedzyDolnaGranica(cellIterator);
        listaOgraniczeniaWieku.add(OgraniczenieWiekuV5.newInstance(kodOgraniczeniaWieku, ponizejGornaGranica,
                pomiedzyGornaGranica, pomiedzyDolnaGranica, powyzejDolnaGranica));
    }
    /*  for(OgraniczenieWieku ograniczenie:listaOgraniczeniaWieku){
          System.out.println(ograniczenie);
      }*/
}

From source file:pl.ulit.xsl.handler.OgraniczenieWiekuSheetv6.java

@Override
public void read() throws NoSuchElementException {
    int kodOgraniczeniaWieku;
    int ponizejGornaGranica;
    int powyzejDolnaGranica;
    String jednostka;//from   w w w .  ja  v a  2 s  . co  m
    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 4);

    while (rowIterator.hasNext()) {

        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        kodOgraniczeniaWieku = getKodOgraniczeniaWieku(cellIterator);
        ponizejGornaGranica = getPonizejGornaGranica(cellIterator);
        powyzejDolnaGranica = getPowyzejDolnaGranica(cellIterator);
        jednostka = getJednostka(cellIterator);

        listaOgraniczeniaWieku.add(OgraniczenieWiekuV6.newInstance(kodOgraniczeniaWieku, jednostka,
                ponizejGornaGranica, powyzejDolnaGranica));
    }

}

From source file:pl.ulit.xsl.handler.OgraniczenieWiekuSheetv7.java

@Override
public void read() throws NoSuchElementException {
    int kodOgraniczeniaWieku;
    int ponizejGornaGranica;
    int powyzejDolnaGranica;
    String jednostka;//from  w  w w .  ja  v a2 s .  c o  m
    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 4);

    while (rowIterator.hasNext()) {

        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        kodOgraniczeniaWieku = getKodOgraniczeniaWieku(cellIterator);
        ponizejGornaGranica = getPonizejGornaGranica(cellIterator);
        powyzejDolnaGranica = getPowyzejDolnaGranica(cellIterator);
        // jednostka = getJednostka(cellIterator);

        listaOgraniczeniaWieku.add(OgraniczenieWiekuV7.newInstance(kodOgraniczeniaWieku, ponizejGornaGranica,
                powyzejDolnaGranica));
    }

}

From source file:pl.ulit.xsl.handler.ParametryJGPSheet.java

@Override
public void read() {

    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 5);//from   w  w  w.  j a v  a 2s  .c o  m
    while (rowIterator.hasNext()) {

        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        Cell cell = cellIterator.next();
        if (isBlankCell(cell)) {
            break;
        }
        String typListy = getTypListy(cell);
        String kodListy = getKodListy(cellIterator);
        String kodJGP = getKodJGP(cellIterator);
        String kodAlgorytmu = getKodAlgorytmu(cellIterator);
        int kodPobytu = getKodPobytu(cellIterator);
        int kodWieku = getKodWieku(cellIterator);
        String kodICD9 = getKodICD9(cellIterator);
        int liczbaWystapienICD9 = getLiczbaWystapienICD9(cellIterator);
        String drugiKodICD9 = getDrugiKodICD9(cellIterator);
        int drugaLiczbaWystapienICD9 = getDrugaLiczbaWystapienICD9(cellIterator);
        String rozpoznanie = getRozpoznanie(cellIterator);
        String kodICD10 = getKodICD10(cellIterator);
        String drugiKodICD10 = getDrugiKodICD10(cellIterator);
        String plec = getPlec(cellIterator);
        int kodPrzyjecia = getKodPrzyjecia(cellIterator);
        int kodWypisu = getKodWypisu(cellIterator);
        String negatywnaListaProcedur = getNegatywnaListaProcedur(cellIterator);
        // i++;
        String negatywnaListaRozpoznan = getNegatywnaListaRozpoznan(cellIterator);
        parametry.add(ParametryJGP.newInstance(typListy, kodListy, kodJGP, kodAlgorytmu, kodPobytu, kodWieku,
                kodICD9, liczbaWystapienICD9, drugiKodICD9, drugaLiczbaWystapienICD9, rozpoznanie, kodICD10,
                drugiKodICD10, plec, kodPrzyjecia, kodWypisu, negatywnaListaProcedur, negatywnaListaRozpoznan));
    }

}

From source file:pl.ulit.xsl.handler.SpecjalnosciKomorek.java

@Override
public void read() throws IllegalStateException {

    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 3);/*from   w w w. j a  va  2 s  .c  o  m*/
    while (rowIterator.hasNext()) {
        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        Cell cell;
        cell = cellIterator.next();
        String kod = getKodKomorki(cell);
        logger.info("Kod: " + kod);
        if (kod.equals("")) {
            break;
        }
        cell = cellIterator.next();
        String nazwa = cell.getStringCellValue();
        komorki.add(KomorkaOrg.newInstance(kod, nazwa));
    }

}

From source file:pl.ulit.xsl.handler.WersjaJGP.java

@Override
public void read() {

    int i = 1;// www.jav a2  s . c  o  m
    int walg = 0;
    int wicd = 0;
    int roko = 0;
    int msod = 0;
    int msdo = 0;
    Cell cell;
    Iterator<Row> rowIterator = sheet.iterator();
    skipRows(rowIterator, 1);

    while (rowIterator.hasNext()) {
        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();
        cellIterator.next();
        while (cellIterator.hasNext()) {
            switch (i) {
            case 1:
                cell = cellIterator.next();
                wicd = numericCelltoInt(cell);
                break;
            case 2:
                cell = cellIterator.next();
                walg = numericCelltoInt(cell);
                break;
            case 3:
                cell = cellIterator.next();
                wprm = numericCelltoInt(cell);
                break;
            case 4:
                cell = cellIterator.next();
                roko = numericCelltoInt(cell);
                break;
            case 5:
                cell = cellIterator.next();
                msod = numericCelltoInt(cell);
                break;
            case 6:
                cell = cellIterator.next();
                msdo = numericCelltoInt(cell);
                break;
            default:
                break;

            }

        }
        i++;
    }

    wrjgp = new Wrjgp(wprm, walg, wicd, roko, msod, msdo);

}

From source file:pl.ulit.xsl.handler.ZakresyJGP.java

@Override
public void read() {

    Iterator<Row> rowIterator = sheet.iterator();
    rowIterator.next();//w  w  w  . j  ava2 s . c o m
    rowIterator.next();
    rowIterator.next();
    while (rowIterator.hasNext()) {
        Row row = rowIterator.next();
        Iterator<Cell> cellIterator = row.cellIterator();

        Cell cell;
        Double d;
        String kodProduktu;

        cell = cellIterator.next();
        kodProduktu = cell.getStringCellValue();
        cell = cellIterator.next();
        String kod = cell.getStringCellValue();
        cell = cellIterator.next();
        String nazwa = cell.getStringCellValue();
        cell = cellIterator.next();
        d = new Double(cell.getNumericCellValue());
        int wph = d.intValue();
        cell = cellIterator.next();
        d = new Double(cell.getNumericCellValue());
        int wphp = d.intValue();
        cell = cellIterator.next();
        d = new Double(cell.getNumericCellValue());
        int l1d = d.intValue();
        grupyJGP.add(GrupaJGP.newInstance(kod, kodProduktu, nazwa, wph, wphp, l1d));

    }

    //mechanizm osobodni

    sh = new MechanizmOsobodni(this.sheetMechOsob, grupyJGP);
    //  sh.start();
    /* for(GrupaJGP grupa:grupyJGP){
    logger.info(grupa.toString());
            
     }*/
}

From source file:poi.ReadExcel.java

public void StartRead() {
    int p = 1, l = 1;
    WriteExcel write = new WriteExcel();
    WriteExcel write1 = new WriteExcel();
    String arr[] = new String[55];
    String g[];//from  w ww  . j  a  v a  2 s  .  c  o  m
    String temp[];
    //write.Write(arr);
    int cellnum = 0;
    int rownum = 0;
    //FileInputStream file = new FileInputStream(new File("Student Master-MM-15.1.xlsx"));
    Iterator<Row> rowIterator = sheet.iterator();
    int i = 0;
    while (rowIterator.hasNext()) {
        if (i == 9)
            break;
        i++;
        Row row = rowIterator.next();
    }

    while (rowIterator.hasNext()) {
        cellnum = 0;

        Row row = rowIterator.next();
        //For each row, iterate through all the columns
        Iterator<Cell> cellIterator = row.cellIterator();

        while (cellIterator.hasNext()) {
            Cell cell = cellIterator.next();
            //Check the cell type and format accordingly
            switch (cell.getCellType()) {
            case Cell.CELL_TYPE_NUMERIC:
                //System.out.print(cell.getNumericCellValue() + "\t");
                arr[cellnum] = "" + cell.getNumericCellValue();
                break;
            case Cell.CELL_TYPE_STRING:
                //System.out.print(cell.getStringCellValue() + "\t");
                arr[cellnum] = cell.getStringCellValue();
                break;
            }
            cellnum++;
        }
        l++;
        System.out.println(" " + l);
        String a = arr[8];
        String o = arr[0];
        arr = Correct.correct(arr);
        write.Write(arr, p++, rownum++);
        //write.Write(arr,p++,rownum++);
        a = Correct.CorrectPhone(a);
        g = Correct.getGuard();
        if (a != null && a.indexOf(' ') == -1) {
            for (int t = 0; t < arr.length; t++) {
                arr[t] = " ";
            }
            temp = arr;
            arr[0] = o.substring(0, o.length() - 2);
            arr[49] = a;
            arr[50] = "Home";
            write.Write(arr, p++, rownum++);
            temp[0] = o.substring(0, o.length() - 2);
            temp[1] = g[0];
            temp[2] = g[1];
            temp[3] = g[2];
            write.Write(temp, p++, rownum++);

        }
        System.out.println("" + g[0]);
        System.out.println("" + g[1]);
        System.out.println("" + g[2]);
        System.out.println("" + g[3]);
        //                        if(!g[0].equals("")){
        //                            for(int t = 0;t<arr.length;t++){
        //                                arr[t] = " ";
        //                            }
        //                        }
        //Guardian data insertion
        //                        for(int t = 0;t<arr.length;t++)
        //                                arr[t] = " ";
        //                        }// Reset array for employees
        //                        String[] Temp = Correct.getGuard();
        //arr[1]="";
        //                        arr[2]=Temp[1];
        //write1.Write(arr,p++,rownum++);

    }
}

From source file:projetrdf.ExcelManager.java

public Datas extractData() throws FileNotFoundException, IOException, InvalidFormatException {
    FileInputStream fip = new FileInputStream(new File(path));
    Workbook workbook = WorkbookFactory.create(fip);
    Sheet firstSheet = workbook.getSheet(sheet);
    Iterator<Row> iterator = firstSheet.iterator();
    List<Individu> li = new ArrayList<>();
    while (iterator.hasNext()) {
        Row nextRow = iterator.next();
        Iterator<Cell> cellIterator = nextRow.cellIterator();
        double[] tabIndividu = new double[nextRow.getLastCellNum()];
        String nomIndividu = "";
        int cpt = 0;
        while (cellIterator.hasNext()) {

            Cell cell = cellIterator.next();
            if (cpt == 0) {
                nomIndividu = cell.getStringCellValue();
            } else {
                tabIndividu[cpt - 1] = Double.parseDouble(cell.getStringCellValue());
            }/*  w  w w  .  j  av a2 s. com*/
            cpt++;
            if (cell.getStringCellValue().equals("")) {
                break;
            }
        }
        int classe = 0;
        String[] nom = nomIndividu.split("\\.");
        classe = Integer.parseInt(nom[0]) / 100;
        li.add(new Individu(nomIndividu, tabIndividu, classe));
    }
    return new Datas(li);
}

From source file:py.gov.datos.XlsToCsvConverter.java

License:GNU General Public License

/**
 * Convierte una fila de una hoja XLSX a un archivo .csv
 *
 * @param row fila a convertir.//from  ww  w  . jav  a 2  s .  c o m
 * @return fila del archivo .csv.
 */
private StringBuffer convertRow(Row row) {
    StringBuffer data = new StringBuffer();
    Iterator<Cell> cellIterator = row.cellIterator();

    while (cellIterator.hasNext()) {
        StringBuffer cellBuffer = convertCell(cellIterator.next());
        data.append(cellBuffer);
    }
    if (data.length() > 0) {
        data = data.deleteCharAt(data.length() - 1);
    }
    data.append("\r\n");
    return data;
}