public static void PopulateInCollection(string fileName, string SheetName) { ExcelLib.ClearData(); DataTable table = ExcelToDataTable(fileName, SheetName); //Iterate through the rows and columns of the Table for (int row = 1; row <= table.Rows.Count; row++) { for (int col = 0; col < table.Columns.Count; col++) { Datacollection dtTable = new Datacollection() { rowNumber = row, colName = table.Columns[col].ColumnName, colValue = table.Rows[row - 1][col].ToString() }; //Add all the details for each row dataCol.Add(dtTable); } } }
public void Inititalize() { // advisasble to read this documentation before proceeding http://extentreports.relevantcodes.com/net/ switch (Browser) { case 1: GlobalDefinitions.driver = new FirefoxDriver(); break; case 2: GlobalDefinitions.driver = new ChromeDriver(); GlobalDefinitions.driver.Manage().Window.Maximize(); break; } ExcelLib.PopulateInCollection(Base.ExcelPath, "SignIn"); driver.Navigate().GoToUrl(ExcelLib.ReadData(2, "Url")); #region Initialise Reports extent = new ExtentReports(ReportPath, false, DisplayOrder.NewestFirst); extent.LoadConfig(MarsResource.ReportXMLPath); test = extent.StartTest("Tests"); #endregion if (MarsResource.IsLogin == "true") { SignIn loginobj = new SignIn(); loginobj.LoginSteps(); } else { SignUp obj = new SignUp(); obj.register(); } }