List of usage examples for org.apache.poi.xssf.usermodel XSSFSheet getSheetName
@Override
public String getSheetName()
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. *//* w w w . ja v a 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 w w w . jav a 2s. 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. *//*w w w. ja v a 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; }
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. *//*from ww w. j ava 2 s. c o 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 www. j ava 2 s . 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 v a 2s . co 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. *///from w w w . j av a 2 s . c om 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 ww. j a va 2 s . co 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:excel2sql.util.ExcelReader.java
public ArrayList<String> read(int pageIndex) { ArrayList<String> queryes = new ArrayList<String>(); boolean first = true; ArrayList<String> params = new ArrayList<String>(); ArrayList<String> values = new ArrayList<String>(); try {/*from ww w . jav a 2s . com*/ FileInputStream file = new FileInputStream(new File(path)); XSSFWorkbook workbook = new XSSFWorkbook(file); XSSFSheet sheet = workbook.getSheetAt(pageIndex); Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); Iterator<Cell> cellIterator = row.cellIterator(); while (cellIterator.hasNext()) { Cell cell = cellIterator.next(); switch (cell.getCellType()) { case Cell.CELL_TYPE_NUMERIC: if (first) { params.add(String.valueOf((int) Math.floor(cell.getNumericCellValue()))); } else { values.add(String.valueOf((int) Math.floor(cell.getNumericCellValue()))); } break; case Cell.CELL_TYPE_STRING: if (first) { params.add(cell.getStringCellValue()); } else { values.add(cell.getStringCellValue()); } break; } } String[] stockParams = new String[params.size()]; stockParams = params.toArray(stockParams); String[] stockValues = new String[values.size()]; stockValues = values.toArray(stockValues); values.clear(); if (!first) { queryes.add(QueryBuilder.getQuery(sheet.getSheetName(), stockParams, stockValues)); } first = false; } file.close(); return queryes; } catch (IOException ioe) { ioe.printStackTrace(); } return null; }
From source file:excelcon.ExcelCon.java
public static String done(String[][] names, XSSFSheet sheet, File selectedDirectory) throws IOException { String headBlock = ""; String s = ""; int namesLength = names.length; String[] statment = new String[namesLength]; File[] file = new File[names.length]; BufferedWriter[] writer = new BufferedWriter[names.length]; for (int i = 0; i < names.length; i++) { file[i] = new File(selectedDirectory.getPath() + "\\" + names[i][0] + " for sheet " + sheet.getSheetName() + ".txt"); writer[i] = new BufferedWriter(new FileWriter(file[i])); statment[i] = ""; }/*from www . java 2 s . com*/ for (Row row : sheet) { int cellIndex = 0; String _tempHeadBlock = row.getCell(cellIndex, Row.CREATE_NULL_AS_BLANK).toString(); if (!_tempHeadBlock.isEmpty()) { headBlock = _tempHeadBlock; } if (headBlock == "") { System.out.println("Head Block is empty"); } cellIndex++; //System.out.println(headBlock); String _tempFeature = row.getCell(cellIndex, Row.CREATE_NULL_AS_BLANK).toString(); for (int i = 0; i < namesLength; i++) { if (_tempFeature.equals(names[i][0])) { //System.out.println(_tempFeature); cellIndex++; try { int no1 = Math .round(Float.valueOf(row.getCell(cellIndex, Row.CREATE_NULL_AS_BLANK).toString())); // System.out.println("No1 :"+ no1); cellIndex++; int no2 = Math .round(Float.valueOf(row.getCell(cellIndex, Row.CREATE_NULL_AS_BLANK).toString())); //System.out.println("No2 :"+ no2); if (no1 < no2) { int tempNo = no1; no1 = no2; no2 = tempNo; } statment[i] = ""; statment[i] += names[i][1]; statment[i] += no1 + ":" + no1; statment[i] += "\n"; statment[i] += headBlock + ":" + no1 + ":" + no2 + "\n"; //System.out.println(statment[i]); } catch (Exception e) { int rowin = row.getRowNum(); rowin += 1; int celle = cellIndex + 1; s += "Sheet: " + sheet.getSheetName() + " Row :" + rowin + " Cell:" + celle + "\n"; System.out.println(sheet.getSheetName() + "Row :" + rowin + " Cell:" + celle); } writer[i].write(statment[i]); } } } for (int i = 0; i < names.length; i++) { writer[i].write("End of MpartPos list"); writer[i].close(); } return s; }