SELENIUM BASICS:

  • What is Automation Testing - Advantages & Types of Tools
  • What is Selenium IDE, Selenium RC, Selenium WebDriver, Selenium Grid?
  • Selenium IDE, Firebug & Firepath Installation

  • SELENIUM WEBDRIVER:

  • Selenium WebDriver Architecture
  • Selenium Installation
  • Challenges and Limitations of Selenium
  • First Selenium WebDriver Script
  • Working with Firefox Browser
  • Solution - Failed To Launch Browser Using Selenium WebDriver
  • Working with Chrome Browser
  • Working with IE Browser
  • Difference Between FindElement & FindElements
  • Install Firebug, Fire path and other add on for Selenium
  • Locators in Selenium
  • Dynamic Xpath
  • Dynamic CSS
  • Handle drop-downs
  • How to work with file upload
  • Handle Alerts & Popups
  • Handle Multiple Windows
  • Mouse Hover event in Selenium
  • Right Click
  • Double Click
  • Drag and Drop
  • Capture Screenshots in Selenium
  • Parameterization
  • Synchronization
  • Implicit Wait, Explicit Wait and Fluent Wait in Selenium
  • Implicit Waits
  • Explicit WebDriver Waits
  • Fluent Wait In Selenium
  • Apache POI
  • How To Read Data From Excel File
  • How To Write Data In Excel File
  • Database Testing Using MSSQL
  • Database Testing Using MySQL
  • Database Testing Using DB2
  • Handle Ajax Call in Selenium
  • Listeners in Selenium
  • Handling JavaScript in Selenium
  • Stale Element Reference Exception in Selenium
  • Integrate Sikuli with Selenium
  • Headless Browser Testing 
  • Headless Browser Testing using HtmlUnitDriver
  • Headless Browser Testing using PhanthomJSDriver

  • TESTNG:

  • TestNG Installation
  • TestNG Complete Tutorial

  • REPORTS:

  • Extent Reports Introduction
  • Extent Reports Generation
  • Capturing Screenshots & Including In Extent Reports
  • Extent Reports Version 4

  • BUILD & CONTINUOUS INTEGRATION TOOLS:

  • ANT Build Tool - How To Download & Install
  • Maven Build Tool - How To Download & Install
  • Creating Maven Selenium Project
  • GIT Integration with Selenium
  • Jenkins - How To Download & Install
  • Jenkins - Executing TestNG Scripts
  • Jenkins - Generating Reports After Test Execution
  • Jenkins - Executing Maven Project
  • Create build and Execute build for nightly execution
  • Send Email report based on build Status
  • Selenium Continuous Integration with Jenkins [Selenium – Maven – Git – Jenkins] – Step By Step Guide

  • CROSS BROWSER TESTING:

  • Running Selenium Tests On BrowserStack
  • Kobiton - Mobile Testing Platform with Real Devices

  • MOBILE TESTING:

  • Mobile Testing Platform with Real Devices

  • AUTOMATION FRAMEWORKS:

  • What is Framework & Types of Framework
  • Page Object Model Design Pattern
  • Data Driven Framework
  • How to explain Test Automation Framework or Selenium Automation Framework Architecture In Interview

  • API Testing:

  • Learn API Testing
  • Postman Tutorial (API Testing with Postman)

  • INTERVIEW QUESTIONS:

  • Test Automation Framework Interview Questions
  • Selenium Interview Questions
  • TestNG Interview Questions
  • Java Interview Questions
  • Python Interview Questions
  • API Testing Interview Questions

  • SAMPLE RESUME:

  • Automation Tester Resume
  • Working with excel in Selenium Python

    In the previous articles on Selenium Python Tutorial, we have covered “Handling Cookies in Selenium Python“. In this tutorial, we will learn Working with excel in Selenium Python. 

    We can work with the excel workbook in Selenium WebDriver. Excel, also called a spreadsheet can have extensions like .xlsx, .xlsm, and so on. Excel consists of multiple worksheets.

    Each worksheet is divided into rows and columns both having an address. The address of rows starts from 1 and the column address begins from A. A cell inside a worksheet is the intersection point of a row and a column.

    Each cell in a worksheet has a unique address defined by the combination of row and column address. Out of the multiple worksheets in a workbook, the worksheet on which we are currently working is known as the active worksheet.

    While working with the Selenium tool along with language Python, we use the OpenPyXL library to access Excel from version 2010. Python does not provide this library automatically.

    We need to run the command pip install openpyxl to get the OpenPyXL library. Also we have to add an import openpyxl statement in our code to get all the methods under that library.

    To fetch the active worksheet in a workbook, we have to use the load_workbook () method which takes the path of the Excel as its parameter then uses the active method.

    Code Implementation to identify active worksheet.

    To read the value of a particular cell, we need to follow all the above steps. Then we have to apply the cell () method on the active worksheet object. This method contains the row and column number as parameters. Finally we shall use the value method to actually read the cell data.

    Code Implementation to read a cell value.

    To write the value on a particular cell, we need to identify the active worksheet. Then we have to apply the cell () method on the active worksheet object. This method contains the row and column number as parameters.

    Next, to set a value, we have to use the value method. Finally to save the workbook, we have to apply the save () method on the workbook object. The save () method takes the path of the file to be saved as a parameter.

    Code Implementation to write a cell value.

    To get the maximum number of rows and columns in the worksheet, we need to identify the active worksheet. Then we have to apply the max_row method on the active worksheet object to get the total occupied rows count. Also, we have to apply the max_column method on the active worksheet object to get the total occupied columns count.

    Code Implementation to identify maximum occupied row and column count.

    To get all the cell data in the worksheet, we need to identify the active worksheet. Then we have to apply the max_row method on the active worksheet object to get the total occupied rows count. Also, we have to apply the max_column method on the active worksheet object to get the total occupied columns count.

    To obtain the cell data, we shall then iterate through the maximum number of rows and columns that are occupied in the worksheet and then retrieve the cell value.

    Code Implementation to get all the cell values in the worksheet.

    To get all the cell data of a particular row in the worksheet, we need to identify the active worksheet. Then we have to apply the max_row method on the active worksheet object to get the total occupied rows count. Also, we have to apply the max_column method on the active worksheet object to get the total occupied columns count.

    To obtain the cell data, we shall then iterate through the maximum number of rows and columns that are occupied in the worksheet and then retrieve the cell value. Once we get the cell value we shall execute a conditional statement, and get all the values from a specific row which matches our requirement.

    Excel Data In Selenium Python

    Let us consider a workbook having a worksheet with the above set of data. Suppose we want to get the Student details for the topic Python.

    Code Implementation for the above scenario.

    In the next article, we will learn 100+ Selenium Interview Questions.

    Related posts:

    Get our latest blog posts delivered to your inbox

    Subscribe and get popular blog posts about software testing industry.

    Rajkumar

    Leave a Comment

    Share via
    Copy link
    Powered by Social Snap