public static object[] getData(ExcelReaderFile xls, string testCaseName) { string sheetName = "Data"; // Read data for only testCaseName int testStartRowNum = 1; //int colStartRowNum = 1; while (!xls.getCellData(sheetName, 0, testStartRowNum).Equals(testCaseName)) { testStartRowNum++; } Console.WriteLine("Test starts from row : " + testStartRowNum); int colStartRowNum = 1 + testStartRowNum; int dataStartRowNum = 2 + testStartRowNum; // Calculate rows of data int rows = 0; while (!xls.getCellData(sheetName, 0, dataStartRowNum + rows).Equals("")) { rows++; } Console.WriteLine("Total number of rows : " + rows); // Calculate total number of cols int cols = 0; while (!xls.getCellData(sheetName, cols, colStartRowNum).Equals("")) { cols++; } Console.WriteLine("Total number of cols : " + cols); // Read data object[][] data = new object[rows][]; int dataRow = 0; Dictionary <string, string> table = null; for (int rNum = dataStartRowNum; rNum < dataStartRowNum + rows; rNum++) { data[rNum - dataStartRowNum] = new object[1]; table = new Dictionary <string, string>(); for (int cNum = 0; cNum < cols; cNum++) { string key = xls.getCellData(sheetName, cNum, colStartRowNum); string value = xls.getCellData(sheetName, cNum, rNum); table.Add(key, value); } data[dataRow][0] = table; dataRow++; } return(data); }
public static bool isSkip(ExcelReaderFile xls, string testCaseName) { // true - N // false - Y int rows = xls.getRowCount("TestCases"); for (int rNum = 2; rNum <= rows; rNum++) { string tcid = xls.getCellData("TestCases", "TCID", rNum); if (tcid.Equals(testCaseName)) { return(true); } } return(true); }
public void executeKeywords(string testUnderExecution, ExcelReaderFile xls, Dictionary <string, string> testData) { app = new AppKeywords(test); int rows = xls.getRowCount(Constants.SHEETNAME); for (int rNum = 2; rNum <= rows; rNum++) { //app.reportFailure("Error Message"); string TCID = xls.getCellData(Constants.SHEETNAME, Constants.TCID_COL, rNum); if (TCID.Equals(testUnderExecution)) { string data = null; string keyword = xls.getCellData(Constants.SHEETNAME, Constants.KEYWORD_COL, rNum); string objct = xls.getCellData(Constants.SHEETNAME, Constants.OBJECT_COL, rNum); string key = xls.getCellData(Constants.SHEETNAME, Constants.DATA_COL, rNum); if (!key.Equals("")) { data = testData[key]; } test.Log(Status.Info, TCID + "-----" + keyword + "-----" + objct + "-----" + data); string result = ""; if (keyword.Equals("openBrowser")) { result = app.openBrowser(data); } else if (keyword.Equals("navigate")) { result = app.navigate(objct); } else if (keyword.Equals("input")) { result = app.input(objct, data); } else if (keyword.Equals("input")) { result = app.input(objct, data); } else if (keyword.Equals("click")) { result = app.click(objct); } else if (keyword.Equals("closeBrowser")) { result = app.closeBrowser(); } else if (keyword.Equals("wait")) { result = app.wait(objct); } else if (keyword.Equals("verifyElementPresent")) { result = app.verifyElementPresent(objct); } else if (keyword.Equals("verifyElementNotPresent")) { result = app.verifyElementNotPresent(objct); } else if (keyword.Equals("list_of_elements")) { result = app.list_of_elements(objct); } else if (keyword.Equals("verify")) { result = app.verify(); } if (!result.Equals(Constants.PASS)) { Assert.Fail(result); } } } }