How to get all the values in a worksheet in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:35:45
We can get all the values in a worksheet in Selenium. Excel is a spreadsheet which is saved with the .xlsx extension. An excel workbook has multiple sheets and each sheet consists of rows and columns.Out of all the worksheets, while we are accessing a particular sheet that is called ... Read More

How to get the maximum number of occupied rows and columns in a worksheet in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:33:38
We can get the maximum number of occupied rows and columns in a worksheet in Selenium. Excel is a spreadsheet which is saved with the .xlsx extension. An excel workbook has multiple sheets and each sheet consists of rows and columns.Out of all the worksheets, while we are accessing a ... Read More

How to write value inside a cell in a worksheet in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:32:36
We can write value inside a cell in a worksheet in Selenium. Excel is a spreadsheet which is saved with the .xlsx extension. An excel workbook has multiple sheets and each sheet consists of rows and columns.Out of all the worksheets, while we are accessing a particular sheet that is ... Read More

How to get the value in a particular cell inside the worksheet in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:30:58
We can get the value in a particular cell inside the worksheet in Selenium. Excel is a spreadsheet which is saved with the .xlsx extension. An excel workbook has multiple sheets and each sheet consists of rows and columns.Out of all the worksheets, while we are accessing a particular sheet ... Read More

How to get the active sheet in a workbook in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:29:29
We can get the active sheet in a workbook in Selenium. Excel is a spreadsheet which is saved with the .xlsx extension. An excel workbook has multiple sheets and each sheet consists of rows and columns.Out of all the worksheets, while we are accessing a particular sheet that is called ... Read More

How to configure handling and formatting of log file in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:27:17
A log configuration consists of formatter and FileHandler methods. We need to import a logging package and then create an object which will be responsible for entire logging.If we add the parameter _name_ inside the getLogger() method, we shall be able to add the test case name for which we ... Read More

What is the importance of logging in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:25:40
While building our test cases in Selenium, we need to implement a logging feature in our framework. It is essential for monitoring the flow of the program and then include other edge scenarios which we might have missed.The logs can give more information whenever there are errors than stack trace ... Read More

How to get the screenshot of a particular section of the page like the logo of a website in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:23:37
We can capture the screenshot of a particular section of the page like the logo of the website in Selenium. For doing so we need to import a PIL imaging library. It may or may not be a part of the standard libraries. However if it is unavailable, it can ... Read More

How to get the screenshot of a particular element in the page in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:22:16
We can get the screenshot of a particular element in a page in Selenium. While executing any test cases, we might encounter failures for a particular. To pinpoint the failure of a specific element we try to capture a screenshot where the error exists.In an element, there may be errors ... Read More

How to get the complete screenshot of a page in Selenium with python?

Debomita Bhattacharjee
Published on 29-Jul-2020 14:20:41
We can get the complete screenshot of a page in Selenium. While executing any test cases, we might encounter failures. To keep track of the failures we capture a screenshot of the web page where the error exists.In a test case, there may be failure for reasons listed below −If ... Read More
Advertisements