SELENIUM BASICS:


SELENIUM WEBDRIVER:


TESTNG:


REPORTS:


BUILD & CONTINUOUS INTEGRATION TOOLS:


CROSS BROWSER TESTING:


MOBILE TESTING:


AUTOMATION FRAMEWORKS:


API Testing:


INTERVIEW QUESTIONS:


SAMPLE 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:

Sharing is caring.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Get our latest blog posts delivered to your inbox

Subscribe and get popular blog posts about software testing industry.

Rajkumar

Leave a Comment