List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet rowIterator
@Override @SuppressWarnings("unchecked") public Iterator<Row> rowIterator()
From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java
License:Open Source License
/** * Parse the list of ICD9 Diagnostic codes present in the workbook. * * @return A list of {@link Icd9Diagnosis} objects. *//* ww w .j a v a 2 s . co m*/ private List<Icd9Diagnosis> readIcd9Diagnoses() throws DataProviderException { XSSFSheet sheet = this.workbook.getSheet("eICD9D"); List<Icd9Diagnosis> result = new ArrayList<>(); if (sheet != null) { String sheetName = sheet.getSheetName(); Iterator<Row> rows = sheet.rowIterator(); rows.next(); // skip header row Map<Long, Integer> ranksByEncounter = new HashMap<>(); while (rows.hasNext()) { Row row = rows.next(); Icd9Diagnosis diagnosis = new Icd9Diagnosis(); diagnosis.setId(readStringValue(sheetName, row.getCell(0))); Long encId = readLongValue(sheetName, row.getCell(1)); diagnosis.setEncounterId(encId); diagnosis.setTimestamp(readDateValue(sheetName, row.getCell(2))); diagnosis.setEntityId(readStringValue(sheetName, row.getCell(3))); Integer rank = ranksByEncounter.get(encId); if (rank == null) { diagnosis.setRank(1); ranksByEncounter.put(encId, 1); } else { int newRank = rank + 1; diagnosis.setRank(newRank); ranksByEncounter.put(encId, newRank); } result.add(diagnosis); } } return result; }
From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java
License:Open Source License
/** * Parse the list of ICD9 Procedure codes present in the workbook. * * @return A list of {@link Icd9Procedure} objects. *///from w w w. j a v a2s . co m private List<Icd9Procedure> readIcd9Procedures() throws DataProviderException { XSSFSheet sheet = this.workbook.getSheet("eICD9P"); List<Icd9Procedure> 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(); Icd9Procedure procedure = new Icd9Procedure(); procedure.setId(readStringValue(sheetName, row.getCell(0))); procedure.setEncounterId(readLongValue(sheetName, row.getCell(1))); procedure.setTimestamp(readDateValue(sheetName, row.getCell(2))); procedure.setEntityId(readStringValue(sheetName, row.getCell(3))); result.add(procedure); } } return result; }
From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java
License:Open Source License
/** * Parse the list of medications present in the workbook. * * @return A list of {@link Medication} objects. *//*from w w w .ja va 2 s .c o m*/ private List<Medication> readMedications() throws DataProviderException { XSSFSheet sheet = this.workbook.getSheet("eMEDS"); List<Medication> 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(); Medication medication = new Medication(); medication.setId(readStringValue(sheetName, row.getCell(0))); medication.setEncounterId(readLongValue(sheetName, row.getCell(1))); medication.setTimestamp(readDateValue(sheetName, row.getCell(2))); medication.setEntityId(readStringValue(sheetName, row.getCell(3))); result.add(medication); } } return result; }
From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java
License:Open Source License
/** * Parse the list of labs present in the workbook's "eLABS" worksheet. * * @return A list of {@link Lab} objects. */// w w w . j a va 2 s . com private List<Lab> readLabs() throws DataProviderException { XSSFSheet sheet = this.workbook.getSheet("eLABS"); List<Lab> 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(); Lab lab = new Lab(); lab.setId(readStringValue(sheetName, row.getCell(0))); lab.setEncounterId(readLongValue(sheetName, row.getCell(1))); lab.setTimestamp(readDateValue(sheetName, row.getCell(2))); lab.setEntityId(readStringValue(sheetName, row.getCell(3))); lab.setResultAsStr(readStringValue(sheetName, row.getCell(4))); lab.setResultAsNum(readDoubleValue(sheetName, row.getCell(5))); lab.setUnits(readStringValue(sheetName, row.getCell(6))); lab.setFlag(readStringValue(sheetName, row.getCell(7))); result.add(lab); } } return result; }
From source file:edu.emory.cci.aiw.cvrg.eureka.etl.spreadsheet.XlsxDataProvider.java
License:Open Source License
/** * Parse the list of vitals present in the workbook's "eVITALS" worksheet. * * @return A list of {@link Vital} objects. *///from w w w .j a v a2 s . c o m private List<Vital> readVitals() throws DataProviderException { XSSFSheet sheet = this.workbook.getSheet("eVITALS"); List<Vital> 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(); Vital vital = new Vital(); vital.setId(readStringValue(sheetName, row.getCell(0))); vital.setEncounterId(readLongValue(sheetName, row.getCell(1))); vital.setTimestamp(readDateValue(sheetName, row.getCell(2))); vital.setEntityId(readStringValue(sheetName, row.getCell(3))); vital.setResultAsStr(readStringValue(sheetName, row.getCell(4))); vital.setResultAsNum(readDoubleValue(sheetName, row.getCell(5))); vital.setUnits(readStringValue(sheetName, row.getCell(6))); vital.setFlag(readStringValue(sheetName, row.getCell(7))); result.add(vital); } } return result; }
From source file:fr.unice.i3s.rockflows.experiments.automatictest.AutomaticTest.java
public static List<TestResult> readValues(IntermediateExcelFile file, int preProcId, XSSFSheet sheet) { List<TestResult> res = new ArrayList<>(); Iterator<Row> rows = sheet.rowIterator(); //1st row: read dataset properties rows.next();//from w w w. j a v a 2 s . co m //3rd row read pre-proc time and pre-proc properties rows.next(); rows.next(); //4th row contains titles (to fold) rows.next(); int algoId = 0; while (rows.hasNext()) { TestResult currentRes = new TestResult(); currentRes.algoId = algoId++; currentRes.preProcId = preProcId; Row res4 = rows.next(); //Result row //read algo name XSSFCell resAlgoCell = (XSSFCell) res4.getCell(file.algorithmColumn); if (resAlgoCell == null) { continue; } currentRes.algoName = ExcelUtils.getStringValue(resAlgoCell); XSSFCell resCompatibleCell = (XSSFCell) res4.getCell(file.algoCompatible); if (resCompatibleCell == null) { continue; } String compatible = ExcelUtils.getStringValue(resCompatibleCell); if (compatible.equals("y")) { currentRes.compatible = true; //read avg values XSSFCell resAccuracyCell = (XSSFCell) res4.getCell(file.accuracyColumn); currentRes.accuracyAvg = ExcelUtils.getDoubleValue(resAccuracyCell); XSSFCell resTrainCell = (XSSFCell) res4.getCell(file.trainingTimeColumn); currentRes.trainTimeAvg = ExcelUtils.getDoubleValue(resTrainCell); XSSFCell resTestCell = (XSSFCell) res4.getCell(file.testTimeColumn); currentRes.testTimeAvg = ExcelUtils.getDoubleValue(resTestCell); XSSFCell resRamCell = (XSSFCell) res4.getCell(file.modelSizeColumn); currentRes.ramAvg = ExcelUtils.getDoubleValue(resRamCell); } else { currentRes.compatible = false; } res.add(currentRes); } return res; }
From source file:gov.anl.cue.arcane.engine.matrix.MatrixModel.java
License:Open Source License
/** * Imports the dimensions for a matrix model from a * template spreadsheet.//from w w w . j a va2 s. c o m * * @param fileName the file name * @return the matrix dimensions */ public static HashMap<Integer, Integer> importTemplateDimensions(String fileName) { // Create the results holder. HashMap<Integer, Integer> nodeCounts = new HashMap<Integer, Integer>(); // Try to read the spreadsheet. try { // Attempt to open the template spreadsheet. XSSFWorkbook workbook = new XSSFWorkbook(new FileInputStream(new File(fileName))); // Scan the sheets. Iterator<XSSFSheet> sheets = workbook.iterator(); // Ignore the first sheet. XSSFSheet sheet = sheets.next(); sheet = sheets.next(); // Prepare to scan the node count column. Iterator<Row> rowIterator = sheet.rowIterator(); // Skip the header row. rowIterator.next(); // Find the total number of nodes requested. int rowIndex = 0; Double nextCellValue = Util.getSpreadsheetNumber(sheet, rowIterator.next().getRowNum(), 2); while (!Double.isNaN(nextCellValue)) { // Store the results. nodeCounts.put(rowIndex++, nextCellValue.intValue()); // Get the next node count. nextCellValue = Util.getSpreadsheetNumber(sheet, rowIterator.next().getRowNum(), 2); } // Close the workbook. workbook.close(); // Catch errors. } catch (Exception e) { // Note an error. nodeCounts = null; } // Return the results. return nodeCounts; }
From source file:io.unravellingtechnologies.excalibur.Sheet.java
License:Open Source License
/** * Loads all the rows that have content into the Sheet structure. *//* w w w . java 2s . c o m*/ private void loadRows(XSSFSheet sheet) { if (logger.isDebugEnabled()) { logger.debug("Loading sheet rows..."); } if (sheet.getPhysicalNumberOfRows() < 2) { return; } for (Iterator<org.apache.poi.ss.usermodel.Row> rowIt = sheet.rowIterator(); rowIt.hasNext();) { org.apache.poi.ss.usermodel.Row tableRow = rowIt.next(); if (tableRow.getRowNum() != sheet.getFirstRowNum()) { Row row = new Row(new HashMap<String, String>()); for (Iterator<Cell> cellIt = tableRow.cellIterator(); cellIt.hasNext();) { Cell cell = cellIt.next(); row.addCell(getColumnName(cell.getColumnIndex()), cell.getStringCellValue()); } rows.add(row); } } if (logger.isDebugEnabled()) { logger.debug("Completed loading " + rows.size() + " rows."); } }
From source file:javafxapplication3.FXMLDocumentController.java
public static void readXLSXFile() throws IOException { InputStream ExcelFileToRead;/*from w ww.j a v a2 s . co m*/ ExcelFileToRead = new FileInputStream("C:\\Users\\IBM_ADMIN\\Desktop\\reimbursement.xlsx"); XSSFWorkbook wb = new XSSFWorkbook(ExcelFileToRead); System.out.println(wb); XSSFWorkbook test = new XSSFWorkbook(); XSSFSheet sheet = wb.getSheetAt(0); XSSFRow row; XSSFCell cell; Iterator rows = sheet.rowIterator(); ObservableList<ObservableList> csvData = FXCollections.observableArrayList(); while (rows.hasNext()) { ObservableList<String> amzrow = FXCollections.observableArrayList(); row = (XSSFRow) rows.next(); Iterator cells = row.cellIterator(); while (cells.hasNext()) { cell = (XSSFCell) cells.next(); if (cell.getCellType() == XSSFCell.CELL_TYPE_STRING) { amzrow.add(cell.getStringCellValue()); //System.out.print(cell.getStringCellValue()+" "); } else if (cell.getCellType() == XSSFCell.CELL_TYPE_NUMERIC) { //amzrow.add(cell.getNumericCellValue()); //System.out.print(cell.getNumericCellValue()+" "); } else { //U Can Handel Boolean, Formula, Errors } } csvData.add(amzrow); } //tableview.getItems().add(csvData); }
From source file:LeeExcel.CargaExcelReqRural.java
public Vector readDataExcelXLSX(String fileName) { Vector vectorData = new Vector(); try {/*from www.j a va 2 s.c o m*/ FileInputStream fileInputStream = new FileInputStream(fileName); XSSFWorkbook xssfWorkBook = new XSSFWorkbook(fileInputStream); // Read data at sheet 0 XSSFSheet xssfSheet = xssfWorkBook.getSheetAt(0); Iterator rowIteration = xssfSheet.rowIterator(); // Looping every row at sheet 0 while (rowIteration.hasNext()) { XSSFRow xssfRow = (XSSFRow) rowIteration.next(); Iterator cellIteration = xssfRow.cellIterator(); Vector vectorCellEachRowData = new Vector(); // Looping every cell in each row at sheet 0 while (cellIteration.hasNext()) { XSSFCell xssfCell = (XSSFCell) cellIteration.next(); vectorCellEachRowData.addElement(xssfCell); } vectorData.addElement(vectorCellEachRowData); } } catch (Exception ex) { ex.printStackTrace(); } return vectorData; }