Test_Login Code:

from testresources.readingexcel import getcelldata
from testresources.readingexcel import isRunnable
import testresources.constants as constants
import pytest
from page.LandingPage import Landingpage
from page.Base import BasePage
import conftest
from conftest import objlist

@pytest.mark.usefixture("base_fixture")
class TestLogin:
@pytest.mark.parametrize("argvals",getcelldata("LoginTest", constants.XLS_FILEPATH))
def test_login(self,argvals):
testrunmode = isRunnable("LoginTest", constants.XLS_FILEPATH)
datarunmode = argvals[constants.RUNMODE]
if testrunmode:
if datarunmode == constants.RUNMODE_Y:
for i in range(0,len(objlist)):
#print(objlist[i])
driver = objlist[i].openbrowser(argvals[constants.BROWSERNAME])
# print(driver.name())
# web_driver = driver.openbrowser(constants.FIREFOX)
# landingpage = Landingpage(web_driver)
# login = landingpage.landingpage()
# username = login.login()
# username.enterusername()
else:
pytest.skip("test case is not executed due to run mode is set no no in datasheet")
else:
pytest.skip("test case is not executed due to run mode is set no no in testcase")

OpenBrowser: 

def openbrowser(self,browser):
with allure.step("Opening "+ browser):
if(browser==constants.CHROME):
self.driver = webdriver.Chrome(ChromeDriverManager().install())
elif(browser==constants.FIREFOX):
self.driver = webdriver.Firefox(executable_path=GeckoDriverManager().install())
elif(browser==constants.EDGE):
self.driver = webdriver.Edge(r"msedgedriver.exe")
else:
self.driver = webdriver.Ie()

Conftest Code:

from pyjavaproperties import Properties
import testresources.constants as constants
import pytest
from page.Base import BasePage

prod = Properties()
#set up and tear down-fxture
objlist = []
@pytest.yield_fixture(scope ='function', autouse=True)
def base_fixture():
try:
prodpath = open(constants.ENVIRONMENT_PROPERTIES)
prod.load(prodpath)
#prod.list()
base = BasePage()
objlist.append(base)
except Exception:
pass

yield locals()
base.quit()

TestCase:

DataSheet