List of usage examples for org.apache.poi.hssf.usermodel HSSFSheet getRow
@Override public HSSFRow getRow(int rowIndex)
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
private Location retrieveOriginForWM(HSSFSheet sheet) { int originRowNo = 2; HSSFRow originRow = sheet.getRow(originRowNo); String originName = ((String) getCellValue(originRow.getCell(0))); originName = StringUtils.trimToEmpty(originName); if (StringUtils.isEmpty(originName)) { return null; }//from ww w . jav a2s. com List<WMLocation> wmLocationList = retrieveWMLocationByName(originName, 1); if (wmLocationList == null || wmLocationList.isEmpty()) { return null; } else { return wmLocationList.get(0).getLocation(); } /*if (StringUtils.contains(originName, Location.FORGE_TRANSFER_STATION)) { originName = Location.FORGE_TRANSFER_STATION; } else if (StringUtils.contains(originName, Location.PHILADELPHIA_TRANSFER_STATION)) { originName = Location.PHILADELPHIA_TRANSFER_STATION; } else if (StringUtils.contains(originName, Location.BQE_TRANSFER_STATION)) { originName = Location.BQE_TRANSFER_STATION; } else if (StringUtils.contains(originName, Location.VARICK_I_TRANSFER_STATION)) { originName = Location.VARICK_I_TRANSFER_STATION; } else if (StringUtils.contains(originName, Location.YONKERS_TRANSFER_STATION)) { originName = Location.YONKERS_TRANSFER_STATION; } else if (StringUtils.contains(originName, Location.WAVERLY_TRANSFER_STATION)) { originName = Location.WAVERLY_TRANSFER_STATION; } List<Location> originList = retrieveLocationDataByLongName(1, originName); if (originList == null || originList.isEmpty()) { return null; } else { return originList.get(0); }*/ }
From source file:com.primovision.lutransport.service.ImportMainSheetServiceImpl.java
private Location retrieveDestinationForWM(HSSFSheet sheet) { HSSFRow destinationRow = sheet.getRow(1); String destinationName = ((String) getCellValue(destinationRow.getCell(0))); destinationName = StringUtils.trimToEmpty(destinationName); if (StringUtils.isEmpty(destinationName)) { return null; }/*w w w .ja va2s.co m*/ List<Location> destinationList = retrieveLocationDataByLongName(2, destinationName); if (destinationList == null || destinationList.isEmpty()) { return null; } else { return destinationList.get(0); } }
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 {/*from www . ja v a2s. co 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 ww w. j a v a 2s . c o m*/ * 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 ww. j a v a2s .c o m*/ * 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//from www . j a v a 2s . 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.ProjectBatchImportRunner.java
License:Open Source License
/** * @param _sString/*from w w w.ja va 2 s .com*/ * @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.qcadoo.mes.assignmentToShift.print.xls.AssignmentToShiftXlsService.java
License:Open Source License
private int fillColumnWithStaffForWorkOnLine(final HSSFSheet sheet, int rowNum, final Entity assignmentToShiftReport, final List<DateTime> days, final List<Entity> productionLines, final Entity dictionaryItem) { if ((assignmentToShiftReport != null) && (days != null) && (productionLines != null)) { for (Entity productionLine : productionLines) { int rowNumFromLastSection = rowNum; int numberOfColumnsForWorkers = getNumberOfRowsForWorkers(assignmentToShiftReport, days, productionLine, dictionaryItem); for (int i = 0; i < numberOfColumnsForWorkers; i++) { HSSFRow row = sheet.createRow(rowNum); rowNum++;/*w w w .ja v a 2 s . com*/ } String productionLineValue = null; if (productionLine.getStringField(PLACE) == null) { productionLineValue = productionLine.getStringField(NUMBER); } else { productionLineValue = productionLine.getStringField(NUMBER) + "-" + productionLine.getStringField(ProductionLineFields.PLACE); } HSSFRow firstRowInSection = null; if (sheet.getRow(rowNumFromLastSection) == null) { firstRowInSection = sheet.createRow(rowNumFromLastSection); rowNum++; } else { firstRowInSection = sheet.getRow(rowNumFromLastSection); } HSSFCell cell = firstRowInSection.createCell(0); cell.setCellValue(productionLineValue); sheet.addMergedRegion(new CellRangeAddress(rowNumFromLastSection, rowNum - 1, 0, 0)); int columnNumber = 1; int maxLength = 0; for (DateTime day : days) { Entity assignmentToShift = assignmentToShiftXlsHelper .getAssignmentToShift(assignmentToShiftReport.getBelongsToField(SHIFT), day.toDate()); if (assignmentToShift == null) { columnNumber += 3; continue; } List<Entity> staffs = assignmentToShiftXlsHelper.getStaffsList(assignmentToShift, dictionaryItem.getStringField(NAME), productionLine); if (staffs.isEmpty()) { columnNumber += 3; continue; } String staffsValue = assignmentToShiftXlsHelper.getListOfWorkers(staffs); List<String> workers = assignmentToShiftXlsHelper.getListOfWorker(staffs); int rowIndex = rowNumFromLastSection; for (String worker : workers) { sheet.getRow(rowIndex).createCell(columnNumber).setCellValue(worker); rowIndex++; } if (workers.isEmpty()) { sheet.getRow(rowIndex).createCell(columnNumber).setCellValue(" "); } if (maxLength < staffsValue.length()) { maxLength = staffsValue.length(); } // row.setHeightInPoints(assignmentToShiftXlsStyleHelper.getHeightForRow(maxLength, 22, 14)); columnNumber += 3; } for (int i = rowNumFromLastSection; i < rowNum; i++) { assignmentToShiftXlsStyleHelper.addMarginsAndStylesForSeries(sheet, i, assignmentToShiftXlsHelper.getNumberOfDaysBetweenGivenDates(assignmentToShiftReport)); } } } return rowNum; }
From source file:com.qcadoo.mes.assignmentToShift.print.xls.AssignmentToShiftXlsService.java
License:Open Source License
private int fillColumnWithStaffForOtherTypes(final HSSFSheet sheet, int rowNum, final Entity assignmentToShiftReport, final List<DateTime> days, final Entity occupationType) { if ((assignmentToShiftReport != null) && (days != null) && (occupationType != null)) { int rowNumFromLastSection = rowNum; int numberOfColumnsForWorkers = getNumberOfRowsForWorkersForOtherTypes(assignmentToShiftReport, days, occupationType);// w w w. j ava2 s . c o m for (int i = 0; i < numberOfColumnsForWorkers; i++) { HSSFRow row = sheet.createRow(rowNum); rowNum++; } String occupationTypeValue = occupationType.getStringField(NAME); HSSFRow firstRowInSection = null; if (sheet.getRow(rowNumFromLastSection) == null) { firstRowInSection = sheet.createRow(rowNumFromLastSection); rowNum++; } else { firstRowInSection = sheet.getRow(rowNumFromLastSection); } HSSFCell cell = firstRowInSection.createCell(0); cell.setCellValue(occupationTypeValue); sheet.addMergedRegion(new CellRangeAddress(rowNumFromLastSection, rowNum - 1, 0, 0)); int columnNumber = 1; int maxLength = 0; for (DateTime day : days) { Entity assignmentToShift = assignmentToShiftXlsHelper .getAssignmentToShift(assignmentToShiftReport.getBelongsToField(SHIFT), day.toDate()); if (assignmentToShift == null) { columnNumber += 3; continue; } List<Entity> staffs = assignmentToShiftXlsHelper.getStaffsList(assignmentToShift, occupationType.getStringField(NAME), null); List<String> workers = Lists.newArrayList(); if (OccupationType.OTHER_CASE.getStringValue() .equals(occupationType.getStringField(TECHNICAL_CODE))) { workers = assignmentToShiftXlsHelper.getListOfWorkerWithOtherCases(staffs); } else { workers = assignmentToShiftXlsHelper.getListOfWorker(staffs); } int rowIndex = rowNumFromLastSection; for (String worker : workers) { sheet.getRow(rowIndex).createCell(columnNumber).setCellValue(worker); rowIndex++; } if (workers.isEmpty()) { sheet.getRow(rowIndex).createCell(columnNumber).setCellValue(" "); } columnNumber += 3; } for (int i = rowNumFromLastSection; i < rowNum; i++) { assignmentToShiftXlsStyleHelper.addMarginsAndStylesForSeries(sheet, i, assignmentToShiftXlsHelper.getNumberOfDaysBetweenGivenDates(assignmentToShiftReport)); } } return rowNum; }
From source file:com.qcadoo.mes.assignmentToShift.print.xls.AssignmentToShiftXlsStyleHelper.java
License:Open Source License
public void addMarginsAndStylesForAuthor(final HSSFSheet sheet, final int rowNumber, final int numberOfDays) { int firstColumnNumber = 0; int lastColumnNumber; int margin = 3; if (numberOfDays < 3) { lastColumnNumber = 10;//from w ww. ja v a 2s .c o m } else { lastColumnNumber = (numberOfDays + 1) * margin; } for (int columnNumber = firstColumnNumber; columnNumber <= lastColumnNumber; columnNumber++) { if (sheet.getRow(rowNumber).getCell(columnNumber) == null) { sheet.getRow(rowNumber).createCell(columnNumber); } if (columnNumber == firstColumnNumber) { setGreyDataStyleBorderLeftAlignLeftBold(sheet, sheet.getRow(rowNumber).getCell(columnNumber)); } else if (columnNumber == lastColumnNumber) { setGreyDataStyleBorderRightAlignLeftBold(sheet, sheet.getRow(rowNumber).getCell(columnNumber)); } else { setGreyDataStyleAlignLeftBold(sheet, sheet.getRow(rowNumber).getCell(columnNumber)); } } sheet.addMergedRegion( new CellRangeAddress(rowNumber, rowNumber, firstColumnNumber, firstColumnNumber + margin - 1)); sheet.addMergedRegion(new CellRangeAddress(rowNumber, rowNumber, firstColumnNumber + margin, firstColumnNumber + (margin * 2) - 1)); sheet.addMergedRegion( new CellRangeAddress(rowNumber, rowNumber, firstColumnNumber + (margin * 2), lastColumnNumber)); }