Selenium Data Driven | Python | xlrd | .XLSX

XLRD

xlrd is a library that is used to extract data from an excel file using Python Binding. It helps you to do data scrapping from an Excel spreadsheet.


Setup xlrd with Python 

1| Open cmd prompt
2| Locate the folder C:\Python27\Scripts in cmd and enter
pip install xlrd

Excel

Create an Excel sheet that resembles this:

from selenium import webdriver
import unittest, time
import xlrd

class moduleName(unittest.TestCase):
    def setUp(self):
        self.driver = webdriver.Firefox()
        self.driver.implicitly_wait(30)
        self.base_url = "https://www.google.co.in"
        self.verificationErrors = []
        self.accept_next_alert = True
        
    def test_Login(self):
        driver=self.driver
        driver.get(self.base_url +"/")
        driver.maximize_window()
        wb=xlrd.open_workbook('C://sams.xlsx')
        sheetname = wb.sheet_names() 
        #Read for XLSX Sheet names
        sh1 = wb.sheet_by_index(0) 
                        
        i=0
        while (i<2):
            rownum=(i)
            rows = sh1.row_values(rownum)
            element = driver.find_element_by_id("gbqfq")
            driver.find_element_by_id("gbqfq").send_keys(rows[0])        
            element.submit()
            time.sleep(3)
            print "The keyword [" + rows[0] + "] is searched"
            driver.back()
            time.sleep(3)
            i=i+1
    
    def tearDown(self):
        self.driver.quit()

if __name__ == "__main__":
    unittest.main()

Test Console looks the same as below after Execution

NOTE| Use Python 2.7 instead of Python 3; xlrd doesn't support Python 3