Example usage for org.apache.poi.xssf.usermodel XSSFSheet rowIterator

Introduction

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

Prototype

@Override
@SuppressWarnings("unchecked")
public Iterator<Row> rowIterator() 

Source Link

Usage

From source file:database.scanners.Scanner.java

protected Iterator GetSheetIterator(String databaseName) throws IOException {
    InputStream input = new BufferedInputStream(new FileInputStream(databaseName));
    XSSFWorkbook wb = new XSSFWorkbook(input);
    XSSFSheet sheet = wb.getSheetAt(0);
    input.close();//from   w w w  .j a v  a  2 s. c o m
    return sheet.rowIterator();
}

---

From source file:dias.Load.java

public Matrix load(Matrix matrice, String filename) throws FileNotFoundException, IOException {

    FileInputStream fis = null;/*from www .j  av  a 2  s.  co m*/
    try {

        String fileName = DIAS.excelFilePath + "\\" + filepath + "\\" + filename + ".xlsx";
        fis = new FileInputStream(fileName);
        XSSFWorkbook calismaKitap = new XSSFWorkbook(fis);
        XSSFSheet sheet = calismaKitap.getSheetAt(0);
        Iterator rows = sheet.rowIterator();
        int ih = 0;
        int jh = 0;

        while (rows.hasNext()) {
            XSSFRow row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            ih++;
            while (cells.hasNext()) {
                XSSFCell cell = (XSSFCell) cells.next();
                jh++;
                //     matrice=createnewMatrix(ih,jh, matrice);
                matrice.set(ih - 1, jh - 1, cell.getNumericCellValue());
            }
            jh = 0;
        }
        ih = 0;
        jh = 0;
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

    return matrice;
}

---

From source file:dias.Load.java

public double[][][] load3D(double[][][] matrice3d, String filename, int kj)
        throws FileNotFoundException, IOException {
    Matrix matrice = new Matrix(matrice3d.length, matrice3d[0].length);

    FileInputStream fis = null;/*from  w  ww.jav  a2 s.com*/

    for (int t = 0; t < kj; t++) {

        try {

            String fileName = "D:\\Phd\\Research\\Kamuran`s Code\\" + filepath + "\\" + filename + t + ".xlsx";
            fis = new FileInputStream(fileName);
            XSSFWorkbook calismaKitap = new XSSFWorkbook(fis);
            XSSFSheet sheet = calismaKitap.getSheetAt(0);
            Iterator rows = sheet.rowIterator();
            int ih = 0;
            int jh = 0;

            while (rows.hasNext()) {
                XSSFRow row = (XSSFRow) rows.next();
                Iterator cells = row.cellIterator();
                ih++;
                while (cells.hasNext()) {
                    XSSFCell cell = (XSSFCell) cells.next();
                    jh++;
                    //           matrice=createnewMatrix(ih,jh, matrice);
                    matrice.set(ih - 1, jh - 1, cell.getNumericCellValue());
                }
                jh = 0;
            }
            ih = 0;
            jh = 0;
        } catch (FileNotFoundException e) {
            e.printStackTrace();
        } catch (IOException e) {
            e.printStackTrace();
        }
        matrice3D = new double[matrice.getRowDimension()][matrice.getColumnDimension()][kj];

        for (int i = 0; i < matrice.getRowDimension(); i++)
            for (int j = 0; j < matrice.getColumnDimension(); j++)
                matrice3D[i][j][t] = matrice.get(i, j);
    }

    return matrice3D;
}

---

From source file:dias.Load.java

public double loaddouble(String filename) throws FileNotFoundException, IOException {
    ///  double[][] matrice=new double[150][150];
    double matrice = 0;
    FileInputStream fis = null;/* w  ww  . j  a va  2  s . co m*/
    try {

        String fileName = "D:\\Phd\\Research\\Kamuran`s Code\\" + filepath + "\\" + filename + ".xlsx";
        fis = new FileInputStream(fileName);
        XSSFWorkbook calismaKitap = new XSSFWorkbook(fis);
        XSSFSheet sheet = calismaKitap.getSheetAt(0);
        Iterator rows = sheet.rowIterator();
        int ih = 0;
        int jh = 0;

        while (rows.hasNext()) {
            XSSFRow row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            ih++;
            while (cells.hasNext()) {
                XSSFCell cell = (XSSFCell) cells.next();
                jh++;
                matrice = cell.getNumericCellValue();
            }
            jh = 0;
        }
        ih = 0;
        jh = 0;
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

    return matrice;
}

---

From source file:dias.Load.java

public String[] loadString(String filename, int kj) throws FileNotFoundException, IOException {
    ///  double[][] matrice=new double[150][150];
    String[] matrice = new String[kj];
    FileInputStream fis = null;// w  w w. ja  v a 2 s.c  om
    try {

        String fileName = "D:\\Phd\\Research\\Kamuran`s Code\\" + filepath + "\\" + filename + ".xlsx";
        fis = new FileInputStream(fileName);
        XSSFWorkbook calismaKitap = new XSSFWorkbook(fis);
        XSSFSheet sheet = calismaKitap.getSheetAt(0);
        Iterator rows = sheet.rowIterator();
        int ih = 0;
        int jh = 0;

        while (rows.hasNext()) {
            XSSFRow row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            ih++;
            while (cells.hasNext()) {
                XSSFCell cell = (XSSFCell) cells.next();
                jh++;
                matrice[ih - 1] = cell.getStringCellValue();
            }
            jh = 0;
        }
        ih = 0;
        jh = 0;
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

    return matrice;
}

---

From source file:dias.load_plsdata730_R_12_withcluster.java

public Matrix loadwithsheetname(String filename, String Sheetname) throws FileNotFoundException, IOException {
    FileInputStream fis = null;/*from  www  .  jav  a 2  s. co  m*/
    try {

        String fileName = DIAS.excelFilePath + filename + ".xlsx";
        //////////////////////////////////////////////////Optimization of memory usage/////////////////////////////////////////////////////////////////////////////

        if (Sheetname.equals("x_cluster1")) {
            matrix = new Matrix(1899, 37);
        } else if (Sheetname.equals("x_cluster2")) {
            matrix = new Matrix(1865, 37);
        } else if (Sheetname.equals("x_cluster3")) {
            matrix = new Matrix(1844, 37);
        } else if (Sheetname.equals("x_cluster4")) {
            matrix = new Matrix(1876, 37);
        } else if (Sheetname.equals("x_cluster5")) {
            matrix = new Matrix(2238, 37);
        } else if (Sheetname.equals("y_cluster1")) {
            matrix = new Matrix(1899, 37);
        } else if (Sheetname.equals("y_cluster2")) {
            matrix = new Matrix(1865, 37);
        } else if (Sheetname.equals("y_cluster3")) {
            matrix = new Matrix(1844, 37);
        } else if (Sheetname.equals("y_cluster4")) {
            matrix = new Matrix(1876, 37);
        } else if (Sheetname.equals("y_cluster5")) {
            matrix = new Matrix(2238, 37);
        } else if (Sheetname.equals("thita_mm1")) {
            matrix = new Matrix(1, 37);
        } else if (Sheetname.equals("thita_mm2")) {
            matrix = new Matrix(1, 37);
        } else if (Sheetname.equals("thita_mm3")) {
            matrix = new Matrix(1, 37);
        } else if (Sheetname.equals("thita_mm4")) {
            matrix = new Matrix(1, 37);
        } else if (Sheetname.equals("thita_mm5")) {
            matrix = new Matrix(1, 37);
        } else if (Sheetname.equals("rc1")) {
            matrix = new Matrix(37, 1899);
        } else if (Sheetname.equals("rc2")) {
            matrix = new Matrix(37, 1865);
        } else if (Sheetname.equals("rc3")) {
            matrix = new Matrix(37, 1844);
        } else if (Sheetname.equals("rc4")) {
            matrix = new Matrix(37, 1876);
        } else if (Sheetname.equals("rc5")) {
            matrix = new Matrix(37, 2238);
        }
        //////////////////////////////////////////////////////Optimization of memory usage/////////////////////////////////////////////////////////////////////////////

        fis = new FileInputStream(fileName);
        XSSFWorkbook calismaKitap = new XSSFWorkbook(fis);
        XSSFSheet sheet = calismaKitap.getSheet(Sheetname);
        Iterator rows = sheet.rowIterator();
        int ih = 0;
        int jh = 0;

        while (rows.hasNext()) {
            XSSFRow row = (XSSFRow) rows.next();
            Iterator cells = row.cellIterator();
            ih++;
            while (cells.hasNext()) {
                XSSFCell cell = (XSSFCell) cells.next();
                jh++;
                matrix.set(ih - 1, jh - 1, cell.getNumericCellValue());
            }
            jh = 0;
        }
        ih = 0;
        jh = 0;
    } catch (FileNotFoundException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    }

    return matrix;
}

---

From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java

License:Open Source License

/**
 * Parse the list of patients from the workbook.
 *
 * @return A list of {@link Patient} objects.
 *///from   w ww.j  a v  a2 s  . c  o  m
private List<Patient> readPatients() throws DataProviderException {
    XSSFSheet sheet = readRequiredSheet("patient");
    String sheetName = sheet.getSheetName();
    List<Patient> result = new ArrayList<>();
    Iterator<Row> rows = sheet.rowIterator();
    rows.next(); // skip header row
    while (rows.hasNext()) {
        Row row = rows.next();
        Patient patient = new Patient();
        patient.setId(readLongValue(sheetName, row.getCell(0)));
        patient.setFirstName(readStringValue(sheetName, row.getCell(1)));
        patient.setLastName(readStringValue(sheetName, row.getCell(2)));
        patient.setDateOfBirth(readDateValue(sheetName, row.getCell(3)));
        patient.setLanguage(readStringValue(sheetName, row.getCell(4)));
        patient.setMaritalStatus(readStringValue(sheetName, row.getCell(5)));
        patient.setRace(readStringValue(sheetName, row.getCell(6)));
        patient.setGender(readStringValue(sheetName, row.getCell(7)));
        result.add(patient);
    }
    return result;
}

---

From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java

License:Open Source License

/**
 * Parse the list of providers in the workbook.
 *
 * @return A list of {@link Provider} objects.
 *///from   w  w  w .  j a va 2  s.  c  om
private List<Provider> readProviders() throws DataProviderException {
    XSSFSheet sheet = readRequiredSheet("provider");
    String sheetName = sheet.getSheetName();
    List<Provider> result = new ArrayList<>();
    Iterator<Row> rows = sheet.rowIterator();
    rows.next(); // skip header row
    while (rows.hasNext()) {
        Row row = rows.next();
        Provider provider = new Provider();
        provider.setId(readLongValue(sheetName, row.getCell(0)));
        provider.setFirstName(readStringValue(sheetName, row.getCell(1)));
        provider.setLastName(readStringValue(sheetName, row.getCell(2)));
        result.add(provider);
    }
    return result;
}

---

From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java

License:Open Source License

/**
 * Parse the list of encounters in the workbook.
 *
 * @return A list of {@link Encounter} objects.
 *///from   ww w  .  ja va 2  s  . c o  m
private List<Encounter> readEncounters() throws DataProviderException {
    XSSFSheet sheet = readRequiredSheet("encounter");
    String sheetName = sheet.getSheetName();
    List<Encounter> result = new ArrayList<>();
    Iterator<Row> rows = sheet.rowIterator();
    LOGGER.debug("Encounter iterator: {}", Integer.valueOf(rows.hashCode()));
    rows.next(); // skip header row
    while (rows.hasNext()) {
        Row row = rows.next();
        Encounter encounter = new Encounter();
        encounter.setId(readLongValue(sheetName, row.getCell(0)));
        encounter.setPatientId(readLongValue(sheetName, row.getCell(1)));
        encounter.setProviderId(readLongValue(sheetName, row.getCell(2)));
        encounter.setStart(readDateValue(sheetName, row.getCell(3)));
        encounter.setEnd(readDateValue(sheetName, row.getCell(4)));
        encounter.setType(readStringValue(sheetName, row.getCell(5)));
        encounter.setDischargeDisposition(readStringValue(sheetName, row.getCell(6)));
        result.add(encounter);
    }
    return result;
}

---

From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java

License:Open Source License

/**
 * Parse the list of CPT codes in the workbook.
 *
 * @return A list of {@link CPT} objects.
 *///from   w ww . java  2  s . co m
private List<CPT> readCpts() throws DataProviderException {
    XSSFSheet sheet = this.workbook.getSheet("eCPT");
    List<CPT> result = new ArrayList<>();
    if (sheet != null) {
        String sheetName = sheet.getSheetName();
        Iterator<Row> rows = sheet.rowIterator();
        rows.next(); // skip header row
        while (rows.hasNext()) {
            Row row = rows.next();
            CPT cpt = new CPT();
            cpt.setId(readStringValue(sheetName, row.getCell(0)));
            cpt.setEncounterId(readLongValue(sheetName, row.getCell(1)));
            cpt.setTimestamp(readDateValue(sheetName, row.getCell(2)));
            cpt.setEntityId(readStringValue(sheetName, row.getCell(3)));
            result.add(cpt);
        }
    }
    return result;
}

---

• «
• 1
• 2
• 3
• 4
• 5
• 6
• 7
• 8
• 9
• »