List of usage examples for org.apache.poi.hssf.usermodel HSSFRow getCell
@Override public HSSFCell getCell(int cellnum)
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
private boolean setVehicleInFuelLogFromUnitNumber(HSSFRow row, String transdate, FuelLog fuelLog) { String vehicleQuery = "Select obj from Vehicle obj where obj.type=1 and obj.unit=" + Integer.parseInt((String) getCellValue(row.getCell(6))) + " and obj.validFrom<='" + transdate + "' and obj.validTo>='" + transdate + "'"; System.out.println("******* The vehicle query for fuel upload is " + vehicleQuery); List<Vehicle> vehicleList = genericDAO.executeSimpleQuery(vehicleQuery); if (vehicleList == null || vehicleList.size() == 0) { System.out.println("Entered here "); return true; } else {// w w w . j a v a 2 s. c o m fuelLog.setUnit(vehicleList.get(0)); return true; } }
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
private String getTransactionDateFromExcel(HSSFRow row, int colIndex) { String transdate = null;// ww w . jav a2s . c om if (validDate(getCellValue(row.getCell(4)))) { transdate = dateFormat.format(((Date) getCellValue(row.getCell(4))).getTime()); } System.out.println("<<Custom code for Driver>>: Transaction date = " + transdate); return transdate; }
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
@Override @Transactional(readOnly = false, propagation = Propagation.REQUIRED) public List<String> importMainSheet(InputStream is) throws Exception { SimpleDateFormat sdf = new SimpleDateFormat("MM-dd-yyyy"); // initializing the InputStream from a file using // POIFSFileSystem, before converting the result // into an HSSFWorkbook instance System.out.println("***** Here step 2"); HSSFWorkbook wb = null;/*from w w w. j a v a 2s . c om*/ StringBuffer buffer = null; List<String> list = new ArrayList<String>(); List<Ticket> tickets = new ArrayList<Ticket>(); // List<String> emptydatalist=new ArrayList<String>(); int count = 1; int errorcount = 0; try { POIFSFileSystem fs = new POIFSFileSystem(is); ErrorData edata = new ErrorData(); // FileWriter writer = new FileWriter("e:/errordata.txt"); wb = new HSSFWorkbook(fs); // loop for every worksheet in the workbook int numOfSheets = wb.getNumberOfSheets(); Map criterias = new HashMap(); HSSFSheet sheet = wb.getSheetAt(0); HSSFRow row = null; HSSFCell cell = null; Ticket ticket = null; Iterator rows = sheet.rowIterator(); StringBuffer lineError; while (rows.hasNext()) { boolean error = false; buffer = new StringBuffer(); int cellCount = 0; row = (HSSFRow) rows.next(); if (count == 1) { count++; continue; } lineError = new StringBuffer(""); try { ticket = new Ticket(); ticket.setTicketStatus(1); ticket.setPayRollStatus(1); Object loadDateObj = getCellValue(row.getCell(0), true); if (loadDateObj == null) { error = true; lineError.append("Load Date,"); } else if (loadDateObj instanceof Date) { ticket.setLoadDate((Date) loadDateObj); } else { String loadDateStr = loadDateObj.toString(); loadDateStr = StringUtils.trimToEmpty(loadDateStr); Date loadDate = sdf.parse(loadDateStr); ticket.setLoadDate(loadDate); } /*try { Date loadDate = sdf.parse((String) getCellValue(row.getCell(0), true)); ticket.setLoadDate(loadDate); } catch (ParseException p) { error = true; lineError.append("Load Date,"); }*/ /*if (validDate(getCellValue(row.getCell(0)))) ticket.setLoadDate((Date) getCellValue(row.getCell(0))); else { error = true; lineError.append("Load Date,"); }*/ if (validTime((String) getCellValue(row.getCell(1)))) { StringBuilder timeIn = new StringBuilder( StringUtils.leftPad((String) getCellValue(row.getCell(1)), 4, '0')); timeIn.insert(2, ':'); ticket.setTransferTimeIn(timeIn.toString()); } else { error = true; lineError.append("Transfer Time In,"); } if (validTime((String) getCellValue(row.getCell(2)))) { StringBuilder timeOut = new StringBuilder( StringUtils.leftPad((String) getCellValue(row.getCell(2)), 4, '0')); timeOut.insert(2, ':'); ticket.setTransferTimeOut(timeOut.toString()); } else { error = true; lineError.append("Transfer Time Out,"); } try { criterias.clear(); criterias.put("type", 1); criterias.put("unit", Integer.parseInt((String) getCellValue(row.getCell(3)))); Vehicle vehicle = genericDAO.getByCriteria(Vehicle.class, criterias); if (vehicle == null) throw new Exception("no such truck"); else ticket.setVehicle(vehicle); } catch (Exception ex) { error = true; lineError.append("Truck,"); log.warn(ex.getMessage()); } try { criterias.clear(); criterias.put("type", 2); criterias.put("unit", Integer.parseInt((String) getCellValue(row.getCell(4)))); Vehicle vehicle = genericDAO.getByCriteria(Vehicle.class, criterias); if (vehicle == null) throw new Exception("no such trailer"); else ticket.setTrailer(vehicle); } catch (Exception ex) { error = true; lineError.append("Trailer,"); log.warn(ex.getMessage()); } Object unloadDateObj = getCellValue(row.getCell(5), true); if (unloadDateObj == null) { error = true; lineError.append("Unload Date,"); } else if (unloadDateObj instanceof Date) { ticket.setUnloadDate((Date) unloadDateObj); } else { String unloadDateStr = unloadDateObj.toString(); unloadDateStr = StringUtils.trimToEmpty(unloadDateStr); Date unloadDate = sdf.parse(unloadDateStr); ticket.setUnloadDate(unloadDate); } /*try { Date unloadDate = sdf.parse((String) getCellValue(row.getCell(5))); ticket.setUnloadDate(unloadDate); } catch (ParseException p) { error = true; lineError.append("Unload Date,"); }*/ /*Object unloadDate = getCellValue(row.getCell(5)); if (validDate(unloadDate)) ticket.setUnloadDate((Date) unloadDate); else { error = true; lineError.append("" + " Date,"); }*/ if (validTime((String) getCellValue(row.getCell(6)))) { StringBuilder timeIn = new StringBuilder( StringUtils.leftPad((String) getCellValue(row.getCell(6)), 4, '0')); timeIn.insert(2, ':'); ticket.setLandfillTimeIn(timeIn.toString()); } else { error = true; lineError.append("Landfill Time In,"); } if (validTime((String) getCellValue(row.getCell(7)))) { StringBuilder timeOut = new StringBuilder( StringUtils.leftPad((String) getCellValue(row.getCell(7)), 4, '0')); timeOut.insert(2, ':'); ticket.setLandfillTimeOut(timeOut.toString()); } else { error = true; lineError.append("Landfill Time Out,"); } try { criterias.clear(); criterias.put("type", 1); criterias.put("name", (String) getCellValue(row.getCell(8))); Location location = genericDAO.getByCriteria(Location.class, criterias); if (location == null) throw new Exception("no such origin"); else ticket.setOrigin(location); } catch (Exception ex) { error = true; lineError.append("Origin,"); // log.warn(ex.getMessage()); } try { ticket.setOriginTicket(Long.parseLong((String) getCellValue(row.getCell(9)))); } catch (Exception ex) { error = true; lineError.append("Origin Ticket,"); } try { criterias.clear(); criterias.put("type", 2); criterias.put("name", (String) getCellValue(row.getCell(10))); Location location = genericDAO.getByCriteria(Location.class, criterias); if (location == null) throw new Exception("no such destination"); else ticket.setDestination(location); } catch (Exception ex) { error = true; lineError.append("Destination,"); // log.warn(ex.getMessage()); } // FOR CUSTOMER AND COMPANY_LACATION BillingRate billingRate = null; try { criterias.clear(); criterias.put("type", 1); criterias.put("name", (String) getCellValue(row.getCell(8))); Location originid = genericDAO.getByCriteria(Location.class, criterias); criterias.clear(); criterias.put("type", 2); criterias.put("name", (String) getCellValue(row.getCell(10))); Location destinationid = genericDAO.getByCriteria(Location.class, criterias); if (originid != null && destinationid != null) { // BillingRate billingRate = null; String query = "select obj from BillingRate obj where transferStation=" + originid.getId() + " and landfill=" + destinationid.getId(); List<BillingRate> rates = genericDAO.executeSimpleQuery(query); for (BillingRate rate : rates) { if (rate.getRateUsing() == null) { billingRate = rate; break; } else if (rate.getRateUsing() == 1) { // calculation for a load date if ((ticket.getLoadDate().getTime() >= rate.getValidFrom().getTime()) && (ticket.getLoadDate().getTime() <= rate.getValidTo().getTime())) { billingRate = rate; break; } } else if (rate.getRateUsing() == 2) { // calculation for a unload date if ((ticket.getUnloadDate().getTime() >= rate.getValidFrom().getTime()) && (ticket.getUnloadDate().getTime() <= rate.getValidTo().getTime())) { billingRate = rate; break; } } } if (billingRate != null) { ticket.setCompanyLocation((billingRate.getCompanyLocation() != null) ? billingRate.getCompanyLocation() : null); ticket.setCustomer( (billingRate.getCustomername() != null) ? billingRate.getCustomername() : null); } else { System.out.println("Customer and Company Location"); } /* * { error = true; lineError.append( * "Rate is expired for this origin and destination,please contact to administrator," * ); } */ } } catch (Exception ex) { System.out.println("Customer and Company Location"); log.warn(ex.getMessage()); } try { ticket.setDestinationTicket(Long.parseLong((String) getCellValue(row.getCell(11)))); } catch (Exception ex) { error = true; lineError.append("Destination Ticket,"); } if (ticket.getOrigin() != null) { if (reportService.checkDuplicate(ticket, "O")) { lineError.append("Duplicate Origin Ticket,"); error = true; } } if (ticket.getDestination() != null) { if (reportService.checkDuplicate(ticket, "D")) { lineError.append("Duplicates Dest. Ticket,"); error = true; } } if (ticket.getUnloadDate() != null && ticket.getLoadDate() != null) { if (ticket.getUnloadDate().before(ticket.getLoadDate())) { lineError.append("Unload Date is before Load Date,"); error = true; } } Double tgross = getValidAmount((String) getCellValue(row.getCell(12))); if (tgross != null) ticket.setTransferGross(tgross); else { error = true; lineError.append("Transfer Gross,"); } Double ttare = getValidAmount((String) getCellValue(row.getCell(13))); if (ttare != null) ticket.setTransferTare(ttare); else { lineError.append("Transfer Tare,"); error = true; } if (tgross != null && ttare != null) { ticket.setTransferNet(tgross - ttare); ticket.setTransferTons((tgross - ttare) / 2000); /* if(billingRate.getBilledby().equals("bygallon")){ */ // Change to 8.35 - 28th Dec 2016 ticket.setGallons(ticket.getTransferNet() / 8.35); // } } Double lgross = getValidAmount((String) getCellValue(row.getCell(16))); if (lgross != null) ticket.setLandfillGross(lgross); else { error = true; lineError.append("Landfill Gross,"); } Double ltare = getValidAmount((String) getCellValue(row.getCell(17))); if (ltare != null) ticket.setLandfillTare(ltare); else { lineError.append("Landfill Tare,"); error = true; } if (lgross != null && ltare != null) { ticket.setLandfillNet(lgross - ltare); ticket.setLandfillTons((lgross - ltare) / 2000); } String driverName = ((String) getCellValue(row.getCell(21))); Driver driver = null; try { if (StringUtils.isEmpty(driverName)) throw new Exception("Invalid driver"); else { // String[] names = driverName.split(" "); criterias.clear(); /* * criterias.put("firstName", names[1]); * criterias.put("lastName", names[0]); */ criterias.put("status", 1); criterias.put("fullName", driverName); driver = genericDAO.getByCriteria(Driver.class, criterias); if (driver == null) throw new Exception("Invalid driver"); ticket.setDriver(driver); // ticket.setDriverCompany(driver.getCompany()); } } catch (Exception ex) { error = true; lineError.append("Driver,"); } try { String employeeCompanyName = ((String) getCellValue(row.getCell(23))); if (StringUtils.isEmpty(employeeCompanyName)) throw new Exception("Invalid company"); else { criterias.clear(); criterias.put("status", 1); criterias.put("name", employeeCompanyName); Location employeeCompany = genericDAO.getByCriteria(Location.class, criterias); if (employeeCompany == null) throw new Exception("Invalid company"); ticket.setDriverCompany(employeeCompany); } } catch (Exception ex) { error = true; lineError.append("employee company,"); } String subcontractor = ((String) getCellValue(row.getCell(20))); try { if (!StringUtils.isEmpty(subcontractor)) { /* * if (driver != null && !"Subcontractor" * .equalsIgnoreCase(driver .getLastName().trim())) * { throw new Exception("Invalid subcontractor"); } * * * else { */ //String subcontractorMod = subcontractor.replace("&", "\"&\""); criterias.clear(); criterias.put("name", subcontractor); SubContractor contractor = genericDAO.getByCriteria(SubContractor.class, criterias); if (contractor == null) { throw new Exception("Invalid subcontractor"); } else { ticket.setSubcontractor(contractor); } criterias.clear(); } // } } catch (Exception ex) { error = true; lineError.append("Sub Contractor,"); } Object billbatchDateObj = getCellValue(row.getCell(22), true); if (billbatchDateObj == null) { error = true; lineError.append("Bill Batch Date,"); } else if (billbatchDateObj instanceof Date) { ticket.setBillBatch((Date) billbatchDateObj); } else { String billbatchDateStr = billbatchDateObj.toString(); billbatchDateStr = StringUtils.trimToEmpty(billbatchDateStr); Date billbatchDate = sdf.parse(billbatchDateStr); ticket.setBillBatch(billbatchDate); } /*try { Date billBatch = sdf.parse((String) getCellValue(row.getCell(22))); ticket.setBillBatch(billBatch); } catch (ParseException p) { error = true; lineError.append("Batch Date,"); }*/ /*Object billBatch = getCellValue(row.getCell(22)); if (validDate(billBatch)) ticket.setBillBatch((Date) billBatch); else { error = true; lineError.append("Batch Date,"); }*/ try { criterias.clear(); String locCode = (String) getCellValue(row.getCell(24)); if (StringUtils.isEmpty(locCode)) throw new Exception("Invalid terminal"); else { criterias.put("code", locCode); criterias.put("type", 4); } Location location = genericDAO.getByCriteria(Location.class, criterias); if (location == null) { throw new Exception("no such terminal"); } else { criterias.clear(); criterias.put("status", 1); criterias.put("fullName", driverName); criterias.put("terminal", location); Driver driverobj = genericDAO.getByCriteria(Driver.class, criterias); if (driverobj == null) { throw new Exception("Terminal does not match with driver"); } else { ticket.setTerminal(location); } } } catch (Exception ex) { error = true; lineError.append("Terminal does not match with driver,"); log.warn(ex.getMessage()); } try { User user = genericDAO.getByUniqueAttribute(User.class, "username", (String) getCellValue(row.getCell(25))); if (user == null) { throw new Exception("Invalid user"); } else { ticket.setCreatedBy(user.getId()); ticket.setEnteredBy(user.getName()); } } catch (Exception ex) { error = true; lineError.append("User,"); } if (!error) { if (tickets.contains(ticket)) { lineError.append("Duplicate Ticket,"); error = true; errorcount++; } else { tickets.add(ticket); //genericDAO.saveOrUpdate(ticket); } } else { errorcount++; } } catch (Exception ex) { error = true; log.warn(ex); } if (lineError.length() > 0) { System.out.println("Error :" + lineError.toString()); list.add("Line " + count + ":" + lineError.toString() + "<br/>"); } System.out.println("Record No :" + count); count++; } } catch (Exception e) { log.warn("Error in import customer :" + e); } if (errorcount == 0) { for (Ticket ticket : tickets) { genericDAO.saveOrUpdate(ticket); } } return list; }
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
@SuppressWarnings({ "rawtypes", "unchecked" })
@Override// ww w.jav a 2s . c o m
@Transactional(readOnly = false, propagation = Propagation.REQUIRED)
public List<String> importVehiclePermitMainSheet(InputStream is) {
List<String> list = new ArrayList<String>();
List<VehiclePermit> vehiclePermits = new ArrayList<VehiclePermit>();
int errorcount = 0;
HSSFWorkbook wb = null;
try {
POIFSFileSystem fs = new POIFSFileSystem(is);
wb = new HSSFWorkbook(fs);
Map criterias = new HashMap();
HSSFSheet sheet = wb.getSheetAt(0);
HSSFRow row = null;
Iterator rows = sheet.rowIterator();
VehiclePermit vehiclePermit = null;
int count = 1;
while (rows.hasNext()) {
row = (HSSFRow) rows.next();
if (count == 1) {
count++;
continue;
}
boolean error = false;
StringBuffer lineError = new StringBuffer();
vehiclePermit = new VehiclePermit();
String unitNum = "";
try {
unitNum = (String) getCellValue(row.getCell(0));
if (!StringUtils.isEmpty(unitNum)) {
criterias.clear();
criterias.put("unitNum", unitNum);
Vehicle vehicle = genericDAO.getByCriteria(Vehicle.class, criterias);
if (vehicle == null) {
error = true;
lineError.append("Invalid Vehicle Number, ");
} else {
vehiclePermit.setVehicle(vehicle);
}
} else {
error = true;
lineError.append("Vehicle Number is Empty, ");
}
} catch (Exception e) {
e.printStackTrace();
error = true;
lineError.append("Unit,");
log.warn(e.getMessage());
}
String company = "";
try {
company = (String) getCellValue(row.getCell(1));
if (!StringUtils.isEmpty(company)) {
criterias.clear();
criterias.put("name", company);
criterias.put("type", 3);
Location location = genericDAO.getByCriteria(Location.class, criterias);
if (location == null) {
error = true;
lineError.append("Invalid Company Name, ");
} else {
vehiclePermit.setCompanyLocation(location);
}
} else {
error = true;
lineError.append("Company is Empty, ");
}
} catch (Exception e) {
e.printStackTrace();
error = true;
lineError.append("Company, ");
log.warn(e.getMessage());
}
String permitType = "";
try {
permitType = (String) getCellValue(row.getCell(2));
if (!StringUtils.isEmpty(permitType)) {
criterias.clear();
criterias.put("dataType", "PERMIT_TYPE");
criterias.put("dataLabel", permitType);
SetupData setUpdata = genericDAO.getByCriteria(SetupData.class, criterias);
if (setUpdata == null) {
error = true;
lineError.append("Permit Type doesn't exists,");
} else {
SetupData data = genericDAO.getById(SetupData.class, setUpdata.getId());
vehiclePermit.setPermitType(data);
}
} else {
error = true;
lineError.append("Permit Type is Empty, ");
}
} catch (Exception e) {
e.printStackTrace();
error = true;
lineError.append("Permit Type, ");
log.warn(e.getMessage());
}
String permitNumber = "";
try {
permitNumber = (String) getCellValue(row.getCell(3));
vehiclePermit.setPermitNumber(permitNumber);
} catch (Exception e) {
e.printStackTrace();
error = true;
lineError.append("Permit Number, ");
log.warn(e.getMessage());
}
Date date4 = row.getCell(4).getDateCellValue();
try {
if (validDate(date4)) {
vehiclePermit.setIssueDate(dateFormat1.parse(dateFormat1.format(date4)));
} else {
error = true;
lineError.append("Invalid Effective date, ");
}
} catch (Exception e) {
e.printStackTrace();
error = true;
lineError.append("Invalid Effective Date, ");
log.warn(e.getMessage());
}
Date date5 = row.getCell(5).getDateCellValue();
try {
if (validDate(date5)) {
vehiclePermit.setExpirationDate(dateFormat1.parse(dateFormat1.format(date5)));
} else {
error = true;
lineError.append("Invalid Expiration Date");
}
} catch (Exception e) {
error = true;
e.printStackTrace();
lineError.append("Invalid Expiration Date, ");
log.warn(e.getMessage());
}
if (!error) {
java.sql.Date issueDate = new java.sql.Date(vehiclePermit.getIssueDate().getTime());
java.sql.Date expirationDate = new java.sql.Date(vehiclePermit.getExpirationDate().getTime());
criterias.clear();
criterias.put("dataType", "PERMIT_TYPE");
criterias.put("dataLabel", permitType);
SetupData setupData = genericDAO.getByCriteria(SetupData.class, criterias);
String query;
try {
query = "select obj from VehiclePermit obj " + " where obj.vehicle.unitNum='" + unitNum
+ "'" + " and obj.companyLocation.name='" + company + "' "
+ " and obj.companyLocation.type=3 " + " and obj.permitType=" + setupData.getId()
+ " " + " and (('" + issueDate
+ " 00:00:00' BETWEEN obj.issueDate and obj.expirationDate)" + " or ('"
+ expirationDate + " 00:00:00' BETWEEN obj.issueDate and obj.expirationDate)"
+ " or obj.issueDate>='" + issueDate + " 00:00:00' AND obj.expirationDate<='"
+ expirationDate + " 00:00:00')";
// +" and obj.issueDate='"+dateFormat1.format(date4)+"'
// "
// +" and
// obj.expirationDate='"+dateFormat1.format(date5)+"'";
List<VehiclePermit> duplicateCheck = genericDAO.executeSimpleQuery(query);
if (duplicateCheck != null && duplicateCheck.size() > 0) {
lineError.append("Vehicle Permit Already exists for specified date range, ");
errorcount++;
}
/*
* else{
*
* genericDAO.save(vehiclePermit); }
*/
} catch (Exception e) {
e.printStackTrace();
}
vehiclePermits.add(vehiclePermit);
} else {
errorcount++;
}
if (lineError.length() > 0) {
list.add("Line " + count + ":" + lineError.toString() + "<br/>");
}
count++;
}
} catch (Exception e) {
e.printStackTrace();
list.add("Not able to upload the file, please try again");
}
if (errorcount == 0) {
for (VehiclePermit vPermit : vehiclePermits) {
genericDAO.save(vPermit);
}
}
return list;
}
From source file:com.proem.exm.service.wholesaleGroupPurchase.customer.impl.CustomerInfoServiceImpl.java
@Override public Map<String, Object> getAllByExcel(String path) { Map returnMap = new HashMap(); String returnAnwer = ""; List<CustomerInfo> list = new ArrayList<CustomerInfo>(); try {/*w ww.j a va2 s . c o m*/ HSSFWorkbook wb = new HSSFWorkbook(new FileInputStream(path)); HSSFSheet sheet = wb.getSheetAt(0); HSSFRow row = null;// excel HSSFCell cell = null;// excel int totalRow = sheet.getLastRowNum(); for (int i = 1; i <= totalRow; i++) { row = sheet.getRow(i); if (row != null) { CustomerInfo obj = new CustomerInfo(); HSSFCell obj_id = row.getCell(0); if (getValue(obj_id) != null) { obj.setId(getValue(obj_id)); } HSSFCell obj_code = row.getCell(1); obj.setCode(getValue(obj_code) == null ? "" : getValue(obj_code)); HSSFCell obj_name = row.getCell(2); obj.setName(getValue(obj_name) == null ? "" : getValue(obj_name)); HSSFCell obj_memory_code = row.getCell(3); obj.setMnemonicCode(getValue(obj_memory_code) == null ? "" : getValue(obj_memory_code)); HSSFCell defaultPrice = row.getCell(4); //obj.setDefaultPrice(getValue(defaultPrice) == null ? "" : getValue(defaultPrice)); obj.setDefaultPrice("WHOLESALE_PRICE"); HSSFCell discount = row.getCell(5); obj.setDiscount(getValue(discount) == null ? "" : getValue(discount)); HSSFCell ownedStores = row.getCell(6); obj.setOwnedStores(getValue(ownedStores) == null ? "" : getValue(ownedStores)); HSSFCell preferentialWay = row.getCell(7); obj.setPreferentialWay(getValue(preferentialWay) == null ? "" : getValue(preferentialWay)); HSSFCell settlementcycle = row.getCell(8); obj.setSettlementcycle(getValue(settlementcycle) == null ? "" : getValue(settlementcycle)); HSSFCell settlementdate = row.getCell(9); obj.setSettlementdate(getValue(settlementdate) == null ? "" : getValue(settlementdate)); HSSFCell settlementway = row.getCell(10); //obj.setSettlementway(getValue(settlementway)== null ? "" : getValue(settlementway)); obj.setSettlementway("?"); HSSFCell creditLimit = row.getCell(11); obj.setCreditLimit(getValue(creditLimit) == null ? "" : getValue(creditLimit)); HSSFCell saleman = row.getCell(12); obj.setSaleman(getValue(saleman) == null ? "" : getValue(saleman)); HSSFCell area = row.getCell(13); //obj.setArea(getValue(area) == null ? "" : getValue(area)); obj.setArea(""); HSSFCell type = row.getCell(14); obj.setType(getValue(type) == null ? "" : getValue(type)); HSSFCell linkman = row.getCell(15); obj.setLinkman(getValue(linkman) == null ? "" : getValue(linkman)); HSSFCell address = row.getCell(16); obj.setAddress(getValue(address) == null ? "" : getValue(address)); HSSFCell mail = row.getCell(17); obj.setMail(getValue(mail) == null ? "" : getValue(mail)); HSSFCell telephone = row.getCell(18); obj.setTelephone(getValue(telephone) == null ? "" : getValue(telephone)); HSSFCell bank = row.getCell(19); obj.setBank(getValue(bank) == null ? "" : getValue(bank)); HSSFCell mobilephone = row.getCell(20); obj.setMobilephone(getValue(mobilephone) == null ? "" : getValue(mobilephone)); HSSFCell taxregistration = row.getCell(21); obj.setTaxregistration(getValue(taxregistration) == null ? "" : getValue(taxregistration)); HSSFCell fax = row.getCell(22); obj.setFax(getValue(fax) == null ? "" : getValue(fax)); HSSFCell license = row.getCell(23); obj.setLicense(getValue(license) == null ? "" : getValue(license)); HSSFCell postcode = row.getCell(24); obj.setPostcode(getValue(postcode) == null ? "" : getValue(postcode)); HSSFCell account = row.getCell(25); obj.setAccount(getValue(account) == null ? "" : getValue(account)); HSSFCell frozen = row.getCell(26); obj.setFrozen(getValue(frozen) == null ? "" : getValue(frozen)); HSSFCell remark = row.getCell(27); obj.setRemark(getValue(remark) == null ? "" : getValue(remark)); list.add(obj); } } returnMap.put("returnAnwer", returnAnwer); returnMap.put("listSupply", list); return returnMap; } catch (Exception e) { e.printStackTrace(); } return null; }
From source file:com.projectname.testutils.genericutility.testDataLib.ChartPreVisitLib.java
/** * fetchCodingInterfaceTestData//from w w w . ja v a 2 s . c om * function for fetching Test data based on test case id * @since Apr 30, 2010 */ public boolean fetchChartPreVisitTestData() { ReadFromExcel readTestData = new ReadFromExcel(); boolean isDataFound = false; testCaseId = testCaseId != null ? testCaseId.trim() : ""; try { //******************************************************************// //Fetching the test data for New Nexia Interface //******************************************************************// HSSFSheet sheet = null; // function call to initiate a connection to an excel sheet sheet = readTestData.initiateExcelConnectionNexia(workSheetName, sectionName, workBookName); // function to find number of rows and columns excelrRowColumnCount = readTestData.findRowColumnCount(sheet, excelrRowColumnCount); // function call to find excel header fields excelHeaders = readTestData.readExcelHeaders(sheet, excelHeaders, excelrRowColumnCount); HSSFRow row = null; HSSFCell cell = null; String temptestCaseId = null; for (int r = 0; r < excelrRowColumnCount.get("RowCount"); r++) { row = sheet.getRow(r); if (row != null) { for (int c = 0; c < excelrRowColumnCount.get("ColumnCount");) { cell = row.getCell(excelHeaders.get("TestID")); if (cell != null) { temptestCaseId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestID"))); if (temptestCaseId.equals(testCaseId)) { isDataFound = true; if (workSheetName.equalsIgnoreCase("PrescribeMedi")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); prescribeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeCa"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); loaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Loaction"))); freeText = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FreeText"))); direction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Direction"))); addDirectionCount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AdditionalDirectionCount"))); increaseDecreaseDose = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("IncreaseDecreaseDose"))); multipleDirection = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MultipleDirection"))); ofRefill = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OfRefill"))); refillDoNot = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillDoNot"))); refillUsage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage"))); refillUsageCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsageCa"))); refillMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillMethod"))); refillMethodCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillMethodCa"))); refillQuantity = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillQuantity"))); refillQuantityCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillQuantityCa"))); refillUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUnit"))); refillUnitCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUnitCa"))); refillRoute = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillRoute"))); refillRouteCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillRouteCa"))); refillFrequency = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillFrequency"))); refillFrequencyCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillFrequencyCa"))); refillduration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Refillduration"))); refilldurationCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefilldurationCa"))); refillUsage1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage1"))); refillUsage2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage2"))); refillUsage3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage3"))); refillUsage4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage4"))); refillUsage5 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage5"))); refillUsage1Ca = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsage1Ca"))); refillUsage2Ca = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsage2Ca"))); refillUsage3Ca = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsage3Ca"))); refillUsage4Ca = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsage4Ca"))); refillUsage5Ca = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsage5Ca"))); quality = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Quality"))); qualityCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("QualityCa"))); andThen = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AndThen"))); unit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Unit"))); unitCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UnitCa"))); route = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Route"))); routeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RouteCa"))); frequency = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Frequency"))); frequencyCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FrequencyCa"))); duration = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Duration"))); durationIn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DurationIn"))); method = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Method"))); usage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Usage"))); usageCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UsageCa"))); methodCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MethodCa"))); dispense = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Dispense"))); unitList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UnitList"))); fillon = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fillon"))); notesToPharmacy = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("NotesToPharmacy"))); subPermitted = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SubPermitted"))); comePackage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ComePackage"))); weightPreMed = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ChkWeight"))); weight = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Weight"))); weightUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WeightUnit"))); expires = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Expires"))); saveList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SaveList"))); problemSuggest = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProblemSuggest"))); internalNote = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("InternalNote"))); searchWithin = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SearchWithin"))); searchWithinKM = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SearchWithinKM"))); searchWithinMiles = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SearchWithinMiles"))); patient = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Patient"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); zipcodecheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcodecheck"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCA"))); pharmacyName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Pharmacyname"))); prescribeName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeName"))); prescribeNameCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeNameCa"))); patientName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientName"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); patientAddressCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PatientAddressCA"))); providerAddressCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProviderAddressCA"))); HealthCardNo = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("HealthCardNoCa"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); patientAddress = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PatientAddress"))); providerAddress = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProviderAddress"))); dispenseWord = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DispenseWord"))); patientPhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientPhone"))); providerPhone = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProviderPhone"))); reasonForRestart = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForRestart"))); reasonForDelete = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForDelete"))); show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); signPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SignPassword"))); alert = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Alert"))); healthCard = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HealthCard"))); patientNameApprove = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PatientNameApprove"))); interactionWarning = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("InteractionWarning"))); unitListCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UnitListCA"))); reasonForStop = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForStop"))); pharmacyNameUS = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PharmacynameUS"))); licenseNo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LicenseNum"))); medicationName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MedicationName"))); primaryIngredient = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrimaryIngredient"))); drugClass = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DrugClass"))); break; } else if (workSheetName.equalsIgnoreCase("ProviderHomePage")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); announcements = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Announcements"))); noteToeSelf = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NoteToeSelf"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProvider")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); providerType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderType"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); billingInfoCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingInfoCheck"))); maximumFte = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MaximumFte"))); signatureDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SignatureDate"))); break; } else if (workSheetName.equalsIgnoreCase("CreateInjection")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); consentCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentCheck"))); injection = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Injection"))); injection1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Injection"))); lotNumber = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LotNumber"))); expiryData = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExpiryData"))); dosage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Dosage"))); dosageUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DosageUnit"))); consent = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Consent"))); site = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Site"))); adminOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AdminOn"))); adminBy = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AdminBy"))); cptCode1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CptCode1"))); cptCode2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CptCode2"))); reaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reaction"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); route = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Route"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); verifyCpt1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("VerifyCPT1"))); verifyCpt2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("VerifyCPT2"))); quickList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("QuickList"))); break; } else if (workSheetName.equalsIgnoreCase("CreateImmunization")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); refused = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Refused"))); vaccineUS = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("vaccineUS"))); vaccineNameUS = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("vaccineNameUS"))); immunization = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Immunization"))); refusedDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefusedDate"))); admin = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Admin"))); vaccine = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vaccine"))); series = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Series"))); seriesof = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("seriesof"))); consentCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentCheck"))); lotNumber = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LotNumber"))); expiryData = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExpiryData"))); dosage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Dosage"))); dosageUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DosageUnit"))); consent = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Consent"))); site = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Site"))); adminOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AdminOn"))); adminBy = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AdminBy"))); cptCode1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CptCode1"))); cptCode2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CptCode2"))); reaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reaction"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); route = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Route"))); saveList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SaveList"))); vaccine1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vaccine1"))); verifyvac1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("VerifyVac1"))); immunization1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Immunization1"))); immunization2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Immunization2"))); cpt1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cpt1"))); cpt2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cpt2"))); enImmunization = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EnImmunization"))); immunizationCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Immunizationca"))); VaccineCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("VaccineCA"))); RouteCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RouteCA"))); Vaccine1CA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vaccine1CA"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); break; } else if (workSheetName.equalsIgnoreCase("CreateAllergy")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); allergyType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AllergyType"))); allergen = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Allergen"))); allergenCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AllergenCA"))); reaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reaction"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); severity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Severity"))); status = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); onsetDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSet Date"))); lifeStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage"))); reason = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForDeletion"))); onsetDate1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSet Date1"))); lifeStage1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage1"))); onsetDate2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSet Date2"))); lifeStage2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage2"))); onsetDate3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSet Date3"))); lifeStage3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage3"))); onsetDate4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSet Date4"))); lifeStage4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage4"))); noKnownDrugAllergy = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("NoKnownDrugAllergy"))); intolerance = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Intolerance"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProcedure")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); proName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProcedureName"))); proDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProcedureDate"))); onsetDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnSetDate"))); cpt = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CPT"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); consent = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Consent"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); consentCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentCheck"))); cptOne = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CPTONE"))); saveListCheckBox = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SaveListCheckBox"))); showMoreLink = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ShowMoreLink"))); noSignificantHistory = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("NoSignificantHistory"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProblemList")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); medicalCondition1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Condtion"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Condtion"))); onsetDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Onset Date"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Item Status"))); lifeStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage"))); resDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Resloved Date"))); codingSystem = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Coding System"))); diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); user = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("User"))); encounterDiagnosis = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EncounterDiagnosis"))); quickList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("QuickList"))); quickListCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("QuickListCheck"))); finalCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FinalCheck"))); noSignificant = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("NoSignificantProblemList"))); resolvedDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Resloved Date"))); showAllDetails = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Show All Details"))); break; } else if (workSheetName.equalsIgnoreCase("CreateFamilyHistory")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); medical = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Medical"))); cause = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cause"))); relation = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Relation"))); lifeStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LifeStage"))); codingSystem = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CodingSystem"))); age = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Age"))); diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); diagnosis1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis1"))); ageAtDeath = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Ageatdeath"))); treatment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Treatment"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); saveList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SaveList"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); break; } else if (workSheetName.equalsIgnoreCase("CreateMedication")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); /*holdreason=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("holdreason"))); stopreason=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("stopreason")));*/ patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); prescribeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeCa"))); freeText = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FreeText"))); direction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Direction"))); increaseDecreaseDose = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("IncreaseDecreaseDose"))); refillMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillMethod"))); refillQuantity = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillQuantity"))); refillUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUnit"))); refillRoute = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillRoute"))); refillRouteCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillRouteCa"))); refillFrequency = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillFrequency"))); refillUsage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage"))); usage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Usage"))); //usageCa = readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("UsageCa"))); duration = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Duration"))); refillUsage1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage1"))); refillUsage2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage2"))); refillUsage3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage3"))); multipleDirection = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MultipleDirection"))); refillduration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Refillduration"))); method = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Method"))); quality = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Quality"))); unit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Unit"))); route = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Route"))); frequency = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Frequency"))); startDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartDate"))); supply = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Supply"))); refillUsage4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage4"))); prescribeOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeOn"))); refill = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Refill"))); prescribedby = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribedby"))); lastRefill = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastRefill"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); //startDate1= readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("StartDate1"))); //addby= readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("Addby"))); prescribeName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeName"))); prescribeNameCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeNameCa"))); concentration = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Concentation"))); refillQuantityCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillQuantityCa"))); refillFrequencyCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillFrequencyCa"))); quantityCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("QuantityCa"))); frequencyCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FrequencyCa"))); refillUsageCa = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillUsageCa"))); quickList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("QuickList"))); //quickListCheck =readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("QuickListCheck"))); //finalCheck =readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("FinalCheck"))); switchRoleNurse = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SwitchRoleNurse"))); break; } else if (workSheetName.equalsIgnoreCase("VerifySecurityOption")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); break; } else if (workSheetName.equalsIgnoreCase("CreateSocialHistory")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); type = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Type"))); status = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); item = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Item"))); detailsNum = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DetailsNum"))); detailsText = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DetailsText"))); period = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Period"))); year = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("year"))); startAge = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartAge"))); historyType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HistoryType"))); stopAge = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StopAge"))); lifeStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LifeStage"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); other = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Other"))); break; } else if (workSheetName.equalsIgnoreCase("EditMedication")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); freeText = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FreeText"))); direction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Direction"))); increaseDecreaseDose = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("IncreaseDecreaseDose"))); refillMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillMethod"))); refillQuantity = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillQuantity"))); refillUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUnit"))); refillRoute = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillRoute"))); refillFrequency = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefillFrequency"))); refillUsage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage"))); usage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Usage"))); duration = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Duration"))); refillUsage1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage1"))); refillUsage2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage2"))); refillUsage3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage3"))); multipleDirection = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MultipleDirection"))); refillduration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Refillduration"))); method = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Method"))); quality = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Quality"))); unit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Unit"))); route = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Route"))); frequency = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Frequency"))); startDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartDate"))); supply = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Supply"))); refillUsage4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RefillUsage4"))); prescribeOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeOn"))); refill = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Refill"))); prescribedby = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribedby"))); lastRefill = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastRefill"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); break; } else if (workSheetName.equalsIgnoreCase("UnsignedEncounterQueue")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientName"))); ecDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EncounterDate"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); break; } else if (workSheetName.equalsIgnoreCase("NewPatientCheckIn")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); prematureCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrematureCheck"))); duration = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Duration"))); measure = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Measure"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); status = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); sex = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Sex"))); dob = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DOB"))); break; } else if (workSheetName.equalsIgnoreCase("CreateVitals")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); heightInFeet = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HeightInFeet"))); heightInCm = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("HeightInCmOrInches"))); heightMU = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HeightMU"))); heightMUCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HeightMUCA"))); htResult = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("HeightConversion"))); weight = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Weight"))); weightMU = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WeightMU"))); weightMUCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WeightMUCA"))); wtResult = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("WeightConversion"))); bmi = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BMI"))); category = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Category"))); systolicRate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SystolicRate"))); diastolicRate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DiastolicRate"))); position = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Position"))); limb = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Limb"))); cuffSize = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cuff Size"))); time = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Time"))); bPM = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BPM"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); rhythm = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Rhythm"))); waist = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Waist"))); waistMU = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WaistMU"))); waistMUCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WaistMUCA"))); temperature = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Temperature"))); tempRU = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TempRU"))); tempRUCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TempRUCA"))); location = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Location"))); bloodSuger = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BloodSuger"))); bSUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BSUnit"))); repositoryRate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Repository Rate"))); rR_BPM = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RR-BPM"))); oxygenSaturation = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OxygenSaturation"))); pEFR = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PEFR"))); pre_bronchodilator = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Pre-bronchodilator"))); graph1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph1"))); graph2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph2"))); graph3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph3"))); graph4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph4"))); graph5 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph5"))); graph6 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph6"))); graph7 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Graph7"))); headResult = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HeadResult"))); fatherStatureResult = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FatherStatureResult"))); motherStatureResult = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MotherStatureResult"))); head = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Head"))); headMU = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HeadMU"))); fatherStature = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FatherStature"))); fatherStatureIn = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FatherStatureIn"))); motherStature = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MotherStature"))); motherStatureIn = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MotherStatureIn"))); break; } else if (workSheetName.equalsIgnoreCase("CreateLabOrder")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); labTestName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTestName"))); labTestComments1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments1"))); labTestComments2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments2"))); sendTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SendTo"))); notifyme = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notifyme"))); notifymein = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NotifymeIn"))); authorization = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Authorization"))); templateName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TemplateName"))); onBehalf = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OnBehalf"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); printOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrintOn"))); testName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName"))); testName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName1"))); testName2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName2"))); testName3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName3"))); break; } else if (workSheetName.equalsIgnoreCase("EncounterOverAll")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); provider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider1"))); vitals = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vitals"))); chiefComplaint = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChiefComplaint"))); chief = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Chief"))); chief1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChiefComplaint1"))); historyType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HistoryType"))); review = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Review"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MedicalCondition"))); medicalCondition1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MedicalCondition1"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); offEncounter = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OffEncounter"))); show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); break; } else if (workSheetName.equalsIgnoreCase("CreateDiganosticImaging")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); labTestName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTestName"))); labTestComments1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments1"))); labTestComments2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments2"))); authorization = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Authorization"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Condtion"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Item Status"))); printOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrintOn"))); payer = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Payer"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); copyTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CopyTo"))); location = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Location"))); break; } else if (workSheetName.equalsIgnoreCase("PatientMeds")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); break; } else if (workSheetName.equalsIgnoreCase("VerifyCommentsIcon")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); labTestName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTestName"))); labTestComments1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments1"))); labTestComments2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments2"))); break; } else if (workSheetName.equalsIgnoreCase("CreateReferralOrder")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); referral = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReferralSearchName"))); referral1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Referral"))); referralNoteText = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReferralNote"))); authorization = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Authorization"))); storedValue = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StoredValue"))); break; } else if (workSheetName.equalsIgnoreCase("FileLabReport")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); accNumber = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccessionNumber"))); rProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Rprovider"))); oProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Oprovider"))); labName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportingLab"))); labNameCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReportingLabCA"))); cDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("CollectionDate"))); cTime = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("CollectionTime"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); testName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName"))); testName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName1"))); result = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Result"))); low = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Low"))); high = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("High"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); units = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Units"))); abnormal = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Abnormal"))); patientName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientName"))); reportStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportStatus"))); show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); break; } else if (workSheetName.equalsIgnoreCase("ElectronicFileLabReport")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); ftpHostStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FtpHostStage"))); ftpUserStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FtpUserStage"))); ftpPasswordStage = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FtpPasswordStage"))); ftpHost = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FtpHost"))); ftpUser = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FtpUser"))); ftpPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FtpPassword"))); sourcePath = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SourcePath"))); destDir = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DestinationDir"))); numLabs = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NumLabs"))); normal = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Normal"))); providerID = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderID"))); patientHCN = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientHCN"))); labTest = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTest"))); labTest1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTest1"))); facilityName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FacilityName"))); ssNumber = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SSNumber"))); break; } else if (workSheetName.equalsIgnoreCase("VerifyGrowthChart")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); errorMessage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ErrorMessage"))); break; } else if (workSheetName.equalsIgnoreCase("PatientHandouts")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); medical = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Medical"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Condtion"))); onsetDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Onset Date"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Item Status"))); lifeStage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Life Stage"))); resDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Resloved Date"))); codingSystem = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Coding System"))); diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); comment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comment"))); break; } else if (workSheetName.equalsIgnoreCase("MedWarnings")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); prescribeName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeName"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); indications = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Indication"))); prescribeName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PrescribeName"))); severity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Severity"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); loaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Loaction"))); allergen = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Allergen"))); allergenCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AllergenCA"))); prescribeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeCA"))); status = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); break; } else if (workSheetName.equalsIgnoreCase("CreateEncounterReference")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); reference = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reference"))); bookMark = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BookMark"))); break; } else if (workSheetName.equalsIgnoreCase("PatientSummary")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); break; } else if (workSheetName.equalsIgnoreCase("CreatePatientTask")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); TaskType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaskType"))); Instruction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Instruction"))); DueIn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DueIn"))); AssignTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AssignTo"))); Requestedby = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Requestedby"))); Recipienttype = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Recipienttype"))); Deliverymethod = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Deliverymethod"))); Consentname = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Consentname"))); Show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); DueInCount = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DueInCount"))); DueInUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DueInUnit"))); AssignToChartDis = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AssignToChartDis"))); RequesterName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RequesterName"))); RequesterRel = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RequesterRel"))); ContactPhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ContactPhone"))); Extn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Extn"))); RecipientName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RecipientName"))); RecipientRel = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RecipientRel"))); RepConPhn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RepConPhn"))); RepExtn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RepExtn"))); Add1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Add1"))); Add2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Add2"))); City = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); State = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); Zip = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zip"))); Country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); //Fax=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); break; } else if (workSheetName.equalsIgnoreCase("CreateDiganosticImaging")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); labTestName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTestName"))); labTestComments1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments1"))); labTestComments2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("labTestComments2"))); authorization = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Authorization"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Condtion"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Item Status"))); printOn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrintOn"))); payer = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Payer"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); copyTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CopyTo"))); break; } else if (workSheetName.equalsIgnoreCase("Cosign")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); provider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider1"))); vitals = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vitals"))); chiefComplaint = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChiefComplaint"))); chief = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Chief"))); chief1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChiefComplaint1"))); historyType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HistoryType"))); review = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Review"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); medicalCondition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MedicalCondition"))); medicalCondition1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MedicalCondition1"))); itemStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); offEncounter = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OffEncounter"))); show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); EncountertypeMy = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EncountertypeMy"))); EncounterTypeCo = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EncounterTypeCo"))); CosignProv = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cosign"))); break; } else if (workSheetName.equalsIgnoreCase("EMRSecurity")) { loaction = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Loaction"))); userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); prescribe = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescribe"))); prescribeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrescribeCa"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); newPractice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NewPractice"))); dataShareLevel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DataShareLevel"))); emergencyAccessDuration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EmergencyAccessDuration"))); emergencyAccessReason = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EmergencyAccessReason"))); race = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Race"))); ethnicity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Ethnicity"))); religion = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Religion"))); citizenship = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Citizenship"))); studentStatus = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("StudentStatus"))); householdIncome = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("HouseholdIncome"))); employmentStatus = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EmploymentStatus"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); break; } else if (workSheetName.equalsIgnoreCase("ImplementReferrals")) { //implement referral userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); referral1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Referral"))); //otherReferral=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("OtherReferral"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); letterTemplateName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LetterTemplateName"))); templateNameToCopy = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("TemplateNameToCopy"))); ; templateNameToRename = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("TemplateNameToRename"))); templatePageSize = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("TemplatePageSize"))); templateType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TemplateType"))); refLetterTaskType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaskType"))); refLetterTaskName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaskName"))); refLetterTaskAssignTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaskAssignTo"))); allTemplateFields = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AllTemplateFields"))); templateHTML = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TemplateHTML"))); editTemplateFields = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EditTemplateFields"))); editTemplateHTML = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EditTemplateHTML"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); primaryPhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrimaryPhone"))); primaryPhoneExtn = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrimayExtn"))); BussinessPhone = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BussinessPhone"))); BussinessPhoneExtn = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BussinessExtn"))); addressLine1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address1"))); addressLine2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode"))); break; } else if (workSheetName.equalsIgnoreCase("PreventiveCare")) { provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); instructions = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Instructions"))); callerScript = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CallerScript"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); reason = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reason"))); recallFrequency = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RecallFrequency"))); recallCount = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RecallCount"))); recallUnit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RecallUnit"))); alertName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AlertName"))); break; } else if (workSheetName.equalsIgnoreCase("SigningAuthority")) { provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); editRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("EditRole"))); featureName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FeatureName"))); documentType = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FileDocumentType"))); sender = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Sender"))); corrsReportType = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("CorrsReportType"))); rProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Rprovider"))); oProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Oprovider"))); labName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportingLab"))); labNameCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReportingLabCA"))); testName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName"))); result = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Result"))); facilityName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Facility"))); location = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Loaction"))); accessLevel = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AccessLevel"))); break; } else if (workSheetName.equalsIgnoreCase("CreateCorresReport")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); ReportType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Report Type"))); Receivingprovider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Receiving provider"))); DocumentType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DocumentType"))); AccessionNumber = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Accession Number"))); DOS = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DOS"))); ReceivingDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Receiving Date"))); Sender = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Sender"))); Orderingprovider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Ordering provider"))); Diagnosis = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Diagnosis"))); Comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); Show = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Show"))); For = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("For"))); comments1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("comments1"))); comments2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("comments2"))); comments3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("comments3"))); ReportType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Report Type1"))); TaskInst = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaskInst"))); DiagnosisName = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DiagnosisName"))); ForwardTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ForwardTo"))); RefilePatient = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RefilePatient"))); break; } else if (workSheetName.equalsIgnoreCase("PortOrderTemplate_CA")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); templateName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TemplateName"))); testName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName"))); testName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName1"))); testName2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName2"))); testName3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestName3"))); break; } else if (workSheetName.equalsIgnoreCase("CreateDiagnosticReport")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); userPassword1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); patientId1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId1"))); ReportType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Report Type"))); Receivingprovider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Receiving provider"))); Orderingprovider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Ordering provider"))); DocumentType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DocumentType"))); AccessionNumber = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Accession Number"))); facilityName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Facility"))); transcriptionist = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Transcriptionist"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); labTestName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabTestName"))); testResult = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestResult"))); dicomment = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DIcomment"))); forwardTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Forwardto"))); copiedTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Copiedto"))); orderedby = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Orderedby"))); break; } } else { break; } } else { break; } } } if (isDataFound) { break; } } if (!isDataFound) { Assert.fail("\nTest Data not found in test data sheet for Test Case Id : " + testCaseId); } } catch (RuntimeException e) { Assert.fail("Error During Execution; Execution Failed More detaisl " + e); e.printStackTrace(); } return isDataFound; }
From source file:com.projectname.testutils.genericutility.testDataLib.SystemSettingsLib.java
/** * fetchCodingInterfaceTestData// w w w.ja v a2s. c om * function for fetching Test data based on test case id * @since Apr 30, 2010 */ public boolean fetchSystemSettingTestData() { ReadFromExcel readTestData = new ReadFromExcel(); boolean isDataFound = false; testCaseId = testCaseId != null ? testCaseId.trim() : ""; try { //******************************************************************// //Fetching the test data for New Clinical Interface //******************************************************************// HSSFSheet sheet = null; // function call to initiate a connection to an excel sheet sheet = readTestData.initiateExcelConnectionNexia(workSheetName, sectionName, workBookName); // function to find number of rows and columns excelrRowColumnCount = readTestData.findRowColumnCount(sheet, excelrRowColumnCount); // function call to find excel header fields excelHeaders = readTestData.readExcelHeaders(sheet, excelHeaders, excelrRowColumnCount); HSSFRow row = null; HSSFCell cell = null; String temptestCaseId = null; for (int r = 0; r < excelrRowColumnCount.get("RowCount"); r++) { row = sheet.getRow(r); if (row != null) { for (int c = 0; c < excelrRowColumnCount.get("ColumnCount");) { cell = row.getCell(excelHeaders.get("TestID")); if (cell != null) { temptestCaseId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TestID"))); if (temptestCaseId.equals(testCaseId)) { isDataFound = true; if (workSheetName.equalsIgnoreCase("AdminNewConsent")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); consentType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentType"))); consentName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentName"))); validFor = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ValidFor"))); validForType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ValidForType"))); restrictionLevel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("restrictionLevel"))); break; } else if (workSheetName.equalsIgnoreCase("EP_Consent")) { consentType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentType"))); consentType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentType1"))); consentValue = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentValue"))); break; } else if (workSheetName.equalsIgnoreCase("AdminEnterPriseVariables")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); idType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Idtype"))); idName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Idname"))); editIdName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("EditIdName"))); break; } else if (workSheetName.equalsIgnoreCase("NewSocioEconomic")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); patientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientId"))); CAPatientId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CAPatientId"))); parentEthnicityPanel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ParentEthnicityPanel"))); livingArrangement = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LivingArrangement"))); studentStatus = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("StudentStatus"))); educationLevel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EducationLevel"))); break; } else if (workSheetName.equalsIgnoreCase("CreateExternalProviders")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); referringCode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReferringCode"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); middleInitial = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("MiddleInitial"))); practiceNameReferral = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeName"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); licenseNum = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LicenseNumber"))); reportMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportMethod"))); specialty = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Specialty"))); billingExclusionCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingExclusion"))); picosEnrolledCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PicosEnrolled"))); upin = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UPIN"))); npi = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NPI"))); taxonomyCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaxonomyCode"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); practiceName1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PracticeName1"))); epstreet11 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street11"))); epstreet12 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street12"))); epcity1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City1"))); epstate1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State1"))); epzipcode1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode1"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCodeCA"))); epcountry1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country1"))); epphone1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Phone1"))); epextn1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Extn1"))); epfax1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax1"))); epemail1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("E-mail1"))); practiceName2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PracticeName2"))); epstreet21 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street21"))); epstreet22 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street22"))); epcity2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City2"))); epstate2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State2"))); epzipcode2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode2"))); state2CA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcodeCa1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("EZipCodeCA"))); epcountry2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country2"))); epphone2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Phone2"))); epextn2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Extn2"))); epfax2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax2"))); epemail2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("E-mail2"))); break; } else if (workSheetName.equalsIgnoreCase("EP_HealthCareTeam")) { deleteValue = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DeleteValue"))); reasonForDelete = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForDelete"))); role = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role"))); roleValue = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("RoleValue"))); break; } else if (workSheetName.equalsIgnoreCase("CreateHealthCareTeam")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); global = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Global"))); local = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Local"))); teamName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TeamName"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); name1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Name1"))); role1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role1"))); name2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Name2"))); name = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Name"))); chartsChecxBox = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChartsChecxBox"))); reasonForDelete = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForDelete"))); break; } else if (workSheetName.equalsIgnoreCase("EditHealthCareTeam")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); global = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Global"))); local = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Local"))); teamName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TeamName"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); name1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Name1"))); role1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role1"))); chartsChecxBox = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChartsChecxBox"))); reasonForDelete = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReasonForDelete"))); break; } else if (workSheetName.equalsIgnoreCase("CreateAddressBook")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); contactLevel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Contact Level"))); contactType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Contact Type"))); contactCompany = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Contact Company"))); salutation = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Salutation"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Last Name"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("First Name"))); middleName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Middle Name"))); jobTitle = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Job Title"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); telephoneType1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Primary Phone Type"))); telephoneNo1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Primary Phone Number"))); telephoneextnNo1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Primary Phone Extn"))); telephoneType2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Secondary Phone Type"))); telephoneNo2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Secondary Phone Number"))); telephoneextnNo2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Secondary Phone Extn"))); telephoneType3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Tertiary Phone Type"))); telephoneNo3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Tertiary Phone Number"))); telephoneextnNo3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Tertiary Phone Extn"))); primaryPhoneExtn1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Primary Phone Extn1"))); primaryPhoneNumber1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Primary Phone Number1"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCodeCA"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("E-mail"))); webAddress = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("WebAddress"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); break; } else if (workSheetName.equalsIgnoreCase("EP_AddressBook")) { contactType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ContactType"))); contactType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ContactType1"))); contactValue = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Contact"))); contactValue1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Contact1"))); break; } else if (workSheetName.equalsIgnoreCase("CreateIdentifierGroups")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); groupFor = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupFor"))); groupName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupName"))); groupDescription = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); groupDefault = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Default"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProgram")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); providers = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Providers"))); break; } else if (workSheetName.equalsIgnoreCase("CreatePractice")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); practiceName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeName"))); practiceCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeCode"))); taxId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaxId"))); groupNpi = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupNPI"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); primaryPhoneType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType1"))); primaryPhoneNumber1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrimaryPhone"))); primaryPhoneExtn1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("primaryPhoneExtension"))); primaryPhoneType2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType2"))); primaryPhoneNumber2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); primaryPhoneType3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType3"))); primaryPhoneNumber3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); verifyPhoneNo1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyPrimaryPhone"))); verifyPhoneNo2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone1"))); verifyPhoneNo3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone2"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCa"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); billlingaddress1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr1"))); billingaddress2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr2"))); billingcity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingCity"))); billingstate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingState"))); billingzipcode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCode"))); billingzipcodeCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCodeCA"))); billingcountry = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingCountry"))); patientName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PatientName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); locationName1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName1"))); billingLocation = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingLocation"))); practiceType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeType"))); startHour = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartHours"))); taxRate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaxRate"))); mammography = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Mammography"))); associateUser = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AssociateUser"))); CLIANumber = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CLIANumber"))); break; } else if (workSheetName.equalsIgnoreCase("EditProgram")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); break; } else if (workSheetName.equalsIgnoreCase("CreateIdentifierTypes")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); groupFor = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupFor"))); idGroup = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("IdGroup"))); idType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("IdType"))); typeDescription = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); freeTextRadio = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("FreeTextRadio"))); definedListRadio = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DefinedListRadio"))); identifier = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Identifier"))); idTypeMask = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("IdTypeMask"))); expDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExpDate"))); typeDefault = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Default"))); restricted = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Restricted"))); typeStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Status"))); enterprise = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Enterprise"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); break; } else if (workSheetName.equalsIgnoreCase("CreateDepartment")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); break; } else if (workSheetName.equalsIgnoreCase("CreateUser")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); UserProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); externalEmr = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExternalEMR"))); password = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); newpassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Newpassword"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); practise = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise"))); userRole2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole2"))); practice2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise2"))); userRole3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole3"))); practice3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise3"))); userRole4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole4"))); practice4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise4"))); break; } else if (workSheetName.equalsIgnoreCase("PortPractice")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); practiceName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeName"))); practiceCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeCode"))); taxId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaxId"))); groupNpi = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupNPI"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); primaryPhoneType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType1"))); primaryPhoneNumber1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrimaryPhone"))); primaryPhoneExtn1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("primaryPhoneExtension"))); primaryPhoneType2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType2"))); primaryPhoneNumber2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); primaryPhoneType3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType3"))); primaryPhoneNumber3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); verifyPhoneNo1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyPrimaryPhone"))); verifyPhoneNo2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone1"))); verifyPhoneNo3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone2"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCa"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCodeCa"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); billlingaddress1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr1"))); billingaddress2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr2"))); billingcity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingCity"))); billingstate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingState"))); billingzipcode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCode"))); billingzipcodeCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCodeCa"))); billingcountry = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingCountry"))); locationCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LocationCode"))); locationName1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName1"))); locationName2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName2"))); locationName3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName3"))); locationName4 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName4"))); practiceType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeType"))); break; } else if (workSheetName.equalsIgnoreCase("ForcePasswordReset")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); externalEmr = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExternalEMR"))); resetPassword = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ResetPassword"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); password1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); startDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartDate"))); break; } else if (workSheetName.equalsIgnoreCase("EditUser")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); externalEmr = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExternalEMR"))); resetPassword = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ResetPassword"))); password = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); changedPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); practise = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise"))); startDate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StartDate"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProvider")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); providerType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderType"))); providerCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("providerCode"))); title = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Title"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); middleName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MiddleName"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); specialty = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Specialty"))); gender = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Gender"))); language = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Language"))); cellPhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CellPhone"))); pager = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Pager"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); maximumFte = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MaximumFte"))); hoursWorked = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HoursWorked"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); officePhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OfficePhone"))); officePhone1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OfficePhone1"))); fax = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); billingAddressCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BllingAddressCheck"))); billingStreet1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingStreet1"))); billingStreet2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingStreet2"))); billingCity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingCity"))); billingState = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingState"))); billingZipcode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipcode"))); billingCountry = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingCountry"))); billingInfoCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("InfoCheck"))); signatureDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SignatureDate"))); dEA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DEA"))); uPIN = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UPIN"))); nPI = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NPI"))); reportMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportMethod"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); groupName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupName"))); groupFor = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupFor"))); idTypeMask = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("IdTypeMask"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); eDIStatus = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("EDIStatus"))); providerId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderId"))); alernateProvider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AlernateProvider"))); groupId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupId"))); taxonomy = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Taxonomy"))); providerBillingNumber = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ProviderBillingNumber"))); payToNumber = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayToNumber"))); break; } else if (workSheetName.equalsIgnoreCase("PortProvider")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); providerType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderType"))); providerCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("providerCode"))); title = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Title"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); middleName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MiddleName"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); specialty = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Specialty"))); gender = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Gender"))); language = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Language"))); cellPhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CellPhone"))); pager = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Pager"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); maximumFte = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("MaximumFte"))); hoursWorked = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("HoursWorked"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCa"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCA"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); officePhone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OfficePhone"))); officePhone1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OfficePhone1"))); fax = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); billingAddressCheck = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BllingAddressCheck"))); billingStreet1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingStreet1"))); billingStreet2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingStreet2"))); billingCity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingCity"))); billingState = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingState"))); billingZipcode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipcode"))); billingCountry = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingCountry"))); billingInfoCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("InfoCheck"))); signatureDate = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SignatureDate"))); dEA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DEA"))); uPIN = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UPIN"))); nPI = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NPI"))); reportMethod = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ReportMethod"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); groupName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupName"))); groupFor = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupFor"))); idTypeMask = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("IdTypeMask"))); SupervisorSuggestBox = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Supervisor"))); DurationTo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DurationTo"))); DurationFrom = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DurationFrom"))); break; } else if (workSheetName.equalsIgnoreCase("PatientInfo")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); pcpCheck = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PcpCheck"))); provider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider1"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); break; } else if (workSheetName.equalsIgnoreCase("CreateAssociateDepartment")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); department1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department1"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); description1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description1"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProviderForProgram")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); provider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NewProvider"))); break; } else if (workSheetName.equalsIgnoreCase("CreatePracticeForProvider")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); program = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Program"))); break; } else if (workSheetName.equalsIgnoreCase("CreateAddressBookForSearch")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); contactLevel = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Contact Level"))); contactType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Contact Type"))); contactCompany = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Contact Company"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Last Name"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("First Name"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); searchElement = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Search Element"))); break; } else if (workSheetName.equalsIgnoreCase("CreateMandatoryField")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); unit = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Unit"))); field = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Field"))); break; } else if (workSheetName.equalsIgnoreCase("CreateProviderForPractice")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); practiceName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeName"))); provider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NewProvider"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProviderName"))); break; } else if (workSheetName.equalsIgnoreCase("CreateDirectories")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); pharmacyName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PharmacyName"))); street = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); telephoneNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TelephoneNo"))); phone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Phone"))); telephoneextnNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExtnNo"))); fax = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); fax1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax1"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); webAddress = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Website"))); salutation = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Salutation"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCA"))); zipcodeCheckCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ZipcodeCheckCA"))); break; } else if (workSheetName.equalsIgnoreCase("PayerAdmin")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); directoryType = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DirectoryType"))); payerWizard = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerWizard"))); payerWizardCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PayerWizardCA"))); payerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerName"))); payerCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerCode"))); payerType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerType"))); street = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); telephoneNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TelephoneNo"))); phone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Phone"))); telephoneextnNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExtnNo"))); fax = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); fax1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax1"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); webAddress = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Website"))); submitClaim = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SubmitClaims"))); submitClaimsSub = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SubmitClaimsSub"))); claimDays = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ClaimDays"))); claimDaysTransfer = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ClaimDaysTransfer"))); department = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Department"))); title = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Title"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); role = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCA"))); planName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PlanName"))); coPay = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CoPay"))); specialistCoPay = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SpecialistCoPay"))); deductible = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Deductible"))); coInsurance = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CoInsurance"))); break; } else if (workSheetName.equalsIgnoreCase("SearchDirectories")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); pharmacyName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PharmacyName"))); street = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Street"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); telephoneNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TelephoneNo"))); phone = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Phone"))); telephoneextnNo1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExtnNo"))); fax = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax"))); fax1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fax1"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); webAddress = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Website"))); salutation = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Salutation"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); break; } else if (workSheetName.equalsIgnoreCase("CreateUserRole")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); homePage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Home Page"))); noAccess = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("NoAccess"))); viewOnly = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ViewOnly"))); limitedAccess = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LimitedAccess"))); fullAccess = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FullAccess"))); break; } else if (workSheetName.equalsIgnoreCase("UserRole")) { userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); description = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Description"))); homePage = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Home Page"))); patientRegistration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Patient Registration"))); personalInfo = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Personal Info"))); socioEconomics = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Socio Economics"))); houseHold = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Household"))); contacts = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Contacts"))); identifiers = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Identifiers"))); payers = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Payers"))); referrals = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Referrals"))); consents = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Consents"))); notes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Notes"))); cases = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Cases"))); programs = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Programs"))); healthCareTeam = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Healthcare Team"))); patientTimeLine = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PatientTimeLine"))); administration = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Administration"))); organizationalStructure = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Organizational Structure"))); practice = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practice"))); providers = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Providers"))); users = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Users"))); departments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Departments"))); programsOrg = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ProgramsOrg"))); enterpriseVariables = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Enterprise Variables"))); mandatoryFields = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Mandatory Fields"))); addressBook = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Address Book"))); externalProviders = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("External Providers"))); identifiersAdmin = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("IdentifiersAdmin"))); healthCareTeamAdmin = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Healthcare TeamAdmin"))); directories = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Directories"))); referringProviders = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Referring Providers"))); payerDirectories = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("PayerDirectories"))); Pharmacies = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Pharmacies"))); governmentAgencies = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Government Agencies"))); hospitals = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Hospitals"))); labs = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Labs"))); securitySettings = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Security Settings"))); auditLog = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Audit Log"))); consentsSec = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ConsentsSec"))); userRoles = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("User Roles"))); passwordRules = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Password Rules"))); emergencyAccess = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("EmergencyAccess"))); userAccessExceptions = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("UserAccessExceptions"))); manageRecords = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Manage Records"))); dataSharing = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("DataSharing"))); restrictPatientChart = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("RestrictPatientChart"))); clinical = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Clinical"))); orders = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Orders"))); labsOrders = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabsOrders"))); diagnosticTestsOrders = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DiagnosticTestsOrders"))); prescription = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Prescription"))); referralsOrders = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ReferralsOrders"))); reportsClinical = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reports"))); labsReports = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LabsReports"))); diagnosticTestsRepords = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("DiagnosticTestsRepords"))); correspondence = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Correspondence"))); chartDisclosure = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ChartDisclosure"))); encounters = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Encounters"))); timeLine = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TimeLine"))); careAlerts = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Care Alerts"))); medicalSummary = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medical Summary"))); allergies = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Allergies"))); patientProblems = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Patient Problems"))); immunizations = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Immunizations"))); injections = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Injections"))); socialHistory = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Social History"))); familyHistory = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Family History"))); vitals = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Vitals"))); procedures = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Procedures"))); medicationsSummary = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Medications Summary"))); fileReport = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("File Report"))); exportChartData = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Export Chart Data"))); clinicalSetting = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Clinical Settings"))); encounterTemplates = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Encounter Templates"))); clinicalDecisionSupport = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Clinical Decision Support"))); electronicReports = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("ElectronicReports"))); laboratoryTemplates = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LaboratoryTemplates"))); interactionWarning = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Interaction Warnings"))); clinicalLists = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Clinical Lists"))); clinicalPatientList = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Clinical Patient List"))); clinicalQualityMeasures = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Clinical Quality Measures"))); meaningfulUseMeasures = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Meaningful Use Measures"))); general = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("General"))); unmatchedItems = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Unmatched Items"))); importChartData = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Import Chart Data"))); failedTransmition = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Failed Transmissions"))); unmatchedProviders = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("UnmatchedProviders"))); reports = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Reports"))); generalReports = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("General Reports"))); scheduler = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Scheduler"))); calendarSettings = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Calendar Settings"))); locationHours = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Location Hours"))); nonProviderResources = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Non-Provider Resources"))); resourceGroups = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Resource Groups"))); visitTypes = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Visit Types"))); visitGroups = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Visit Groups"))); calendarTemplates = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Calendar Templates"))); resourceCalendars = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Resource Calendars"))); calendarPreferences = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Calendar Preferences"))); programGroups = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Program Groups"))); cancellationReasons = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Cancellation Reasons"))); calendarView = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Calendar View"))); calendarSuperUser = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Calendar SuperUser"))); confirmAppt = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Confirm Appt"))); checkinPatient = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Check in Patient"))); bumpList = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Bump List"))); waitListManagement = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Wait List Management"))); recordAttendance = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Record Attendance"))); PDG = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PDG"))); openPDGSessions = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Open PDG Sessions"))); viewEditPDGsession = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("View/EditPDGsession"))); unexplainedabsentees = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Unexplainedabsentees"))); templateSetup = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Template Setup"))); daysheetTemplates = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Daysheet Templates"))); letterTemplates = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LetterTemplates"))); biller = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Biller"))); billingSettings = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Billing Settings"))); superbillSetup = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Superbill Setup"))); statementPreferences = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Statement Preferences"))); serviceCodes = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Service Codes"))); feeSchedule = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Fee Schedule"))); adjustmentReasons = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Adjustment Reasons"))); batchEligibilityPreferences = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Batch Eligibility Preferences"))); billingRulesAdmin = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Billing Rules Admin"))); superbillsToReview = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Superbills to Review"))); rejectionsToReview = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Rejections to Review"))); onHoldClaims = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("On Hold Claims"))); unprintedStatements = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Unprinted Statements"))); unpostedPayerBatches = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Unposted Payer Batches"))); paperClaimsToReview = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Paper Claims to Review"))); postCharges = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Post Charges"))); postPatientPayments = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Post Patient Payments"))); postPayerPayments = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Post Payer Payments"))); insuranceAging = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Insurance Aging"))); patientsFailedEligibility = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Patients Failed Eligibility"))); billingHistory = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("Billing History"))); summary = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Summary"))); charges = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Charges"))); payments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Payments"))); statements = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Statements"))); break; } else if (workSheetName.equalsIgnoreCase("LoginWithUpdateUser")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); password1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); userRole1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole1"))); break; } else if (workSheetName.equalsIgnoreCase("VerifySecurityOption")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); switchRole1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole1"))); break; } else if (workSheetName.equalsIgnoreCase("UserData")) { //userAccount = readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); providerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); lastName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LastName"))); firstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("FirstName"))); userName1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName1"))); UserProvider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); credentials = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Credentials"))); externalEmr = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ExternalEMR"))); password = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password1"))); //newpassword=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("Newpassword"))); practise = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise"))); //practise2=readTestData.convertHSSFCellToString(row.getCell(excelHeaders.get("Practise2"))); practiseCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PractiseCA"))); userRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole"))); userRole2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole2"))); userRole3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole3"))); userRole4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole4"))); userRole5 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole5"))); userRole6 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole6"))); userRole7 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole7"))); userRole8 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole8"))); userRole9 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole9"))); userRole10 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole10"))); userRole11 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole11"))); userRole12 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole12"))); userRole13 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole13"))); userRole14 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole14"))); userRole15 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole15"))); userRole16 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserRole16"))); practice2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise2"))); practice3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise3"))); practice4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Practise4"))); practiceCA2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PractiseCA2"))); practiceCA3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PractiseCA3"))); practiceCA4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PractiseCA4"))); break; } else if (workSheetName.equalsIgnoreCase("AssociateProvider")) { aprovider1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider1"))); aprovider2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider2"))); aprovider3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider3"))); aprovider4 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider4"))); aprovider5 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider5"))); aprovider6 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider6"))); aprovider7 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider7"))); aprovider8 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider8"))); aprovider9 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("AProvider9"))); break; } else if (workSheetName.equalsIgnoreCase("PortAdminPractice")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); switchRole = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SwitchRole"))); practiceName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeName"))); practiceCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PracticeCode"))); taxId = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TaxId"))); groupNpi = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("GroupNPI"))); email = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Email"))); primaryPhoneType1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType1"))); primaryPhoneNumber1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PrimaryPhone"))); primaryPhoneExtn1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("primaryPhoneExtension"))); primaryPhoneType2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType2"))); primaryPhoneNumber2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); primaryPhoneType3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CommType3"))); primaryPhoneNumber3 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("OtherPhone1"))); primaryPhoneExtn3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("OtherPhoneExtension1"))); verifyPhoneNo1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyPrimaryPhone"))); verifyPhoneNo2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone1"))); verifyPhoneNo3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("VerifyOtherPhone2"))); comments = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Comments"))); address1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr1"))); address2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Addr2"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCa"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCode"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipCodeCa"))); country = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Country"))); billlingaddress1 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr1"))); billingaddress2 = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingAddr2"))); billingcity = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingCity"))); billingstate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("BillingState"))); billingzipcode = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCode"))); billingzipcodeCA = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingZipCodeCa"))); billingcountry = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("BillingCountry"))); locationCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("LocationCode"))); locationName1 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName1"))); locationName2 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName2"))); locationName3 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName3"))); locationName4 = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("LocationName4"))); break; } else if (workSheetName.equalsIgnoreCase("PortAddPayers")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); role = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role"))); payerName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerName"))); payerType = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerType"))); payerCode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PayerCode"))); streetName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StreetName"))); city = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("City"))); state = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("State"))); zipcode = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Zipcode"))); stateCA = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("StateCA"))); zipcodeCa = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("ZipcodeCA"))); telePhoneNo = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("TelePhoneNo"))); planName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PlanName"))); coPay = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CoPay"))); specialistCoPay = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SpecialistCoPay"))); deductible = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Deductible"))); coInsurance = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("CoInsurance"))); break; } else if (workSheetName.equalsIgnoreCase("CosignProvider")) { userAccount = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("AccountNumber"))); userName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("UserName"))); userPassword = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Password"))); role = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Role"))); Provider = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Provider"))); SuperProvider = readTestData.convertHSSFCellToString( row.getCell(excelHeaders.get("SuperProvider"))); PFirstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("PFirstName"))); SFirstName = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("SFirstName"))); Enddate = readTestData .convertHSSFCellToString(row.getCell(excelHeaders.get("Enddate"))); break; } else { break; } } else { break; } } else { break; } } } if (isDataFound) { break; } } if (!isDataFound) { Assert.fail("\nTest Data not found in test data sheet for Test Case Id : " + testCaseId); } } catch (RuntimeException e) { Assert.fail("Error During Execution; Execution Failed More detaisl " + e); e.printStackTrace(); } return isDataFound; }
From source file:com.pureinfo.studio.db.txt2SRM.impl.SchoolSCITxtImportRunner.java
License:Open Source License
/** * @param _sString//w ww. ja va 2 s . c om * @throws PureException * @throws IOException * @throws FileNotFoundException */ public List check(String _sFileName) throws PureException, FileNotFoundException, IOException { POIFSFileSystem fs; HSSFSheet m_sheet = null; FileInputStream fileInputStream = new FileInputStream(_sFileName); String[] m_heads; fs = new POIFSFileSystem(fileInputStream); HSSFWorkbook wb = new HSSFWorkbook(fs); m_sheet = wb.getSheetAt(0); HSSFRow row = m_sheet.getRow(0); HSSFCell cell; // TITLE // BY lily List list = new ArrayList(row.getLastCellNum()); for (int i = 0; i < row.getLastCellNum(); i++) { cell = row.getCell((short) i); if (cell == null) { break; } list.add(cell.getStringCellValue().trim()); } m_heads = new String[list.size()]; list.toArray(m_heads); list.clear(); fileInputStream.close(); return checkExcelHead(m_heads); }
From source file:com.pureinfo.studio.db.xls2srm.impl.ProjectBatchImportRunner.java
License:Open Source License
/** * @param _sString/* w w w. j a v a2s.co m*/ * @throws PureException * @throws IOException * @throws FileNotFoundException */ public List check(String _sFileName) throws PureException, FileNotFoundException, IOException { POIFSFileSystem fs; HSSFSheet m_sheet = null; FileInputStream fileInputStream = new FileInputStream(_sFileName); String[] m_heads; fs = new POIFSFileSystem(fileInputStream); HSSFWorkbook wb = new HSSFWorkbook(fs); m_sheet = wb.getSheetAt(0); HSSFRow row = m_sheet.getRow(0); HSSFCell cell; // TITLE // BY lily List list = new ArrayList(row.getLastCellNum()); for (int i = 0; i < row.getLastCellNum(); i++) { cell = row.getCell((short) i); if (cell == null) { break; } list.add(cell.getStringCellValue().trim()); } m_heads = new String[list.size()]; list.toArray(m_heads); list.clear(); fileInputStream.close(); return checkExcelHead(m_heads); }
From source file:com.pureinfo.studio.db.xls2srm.impl.XlsObjectsImpl.java
License:Open Source License
public XlsObjectsImpl(String _sFileName) throws PureException { POIFSFileSystem fs;/* w w w .j ava2s. co m*/ try { fs = new POIFSFileSystem(new FileInputStream(_sFileName)); HSSFWorkbook wb = new HSSFWorkbook(fs); m_sheet = wb.getSheetAt(0); HSSFRow row = m_sheet.getRow(0); List list = new ArrayList(row.getLastCellNum()); HSSFCell cell; for (int i = 0; i < row.getLastCellNum(); i++) { cell = row.getCell((short) i); if (cell == null) { break; } list.add(cell.getStringCellValue().trim().toUpperCase()); } m_heads = new String[list.size()]; list.toArray(m_heads); list.clear(); } catch (Exception ex) { throw new PureException(PureException.UNKNOWN, "", ex); } }