Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
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 called as an active sheet. Each cell inside a sheet has a unique address which is a combination of row and column numbers.The column number starts from alphabetic character A and row number starts from the number 1. A cell can contain numerous types of values and they are the ... Read More
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 that is called as an active sheet. Each cell inside a sheet has a unique address which is a combination of row and column numbers.The column number starts from alphabetic character A and row number starts from the number 1. A cell can contain numerous types of values and they ... Read More
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 as an active sheet. Each cell inside a sheet has a unique address which is a combination of row and column numbers.The column number starts from alphabetic character A and row number starts from the number 1. A cell can contain numerous types of values and they are the main ... Read More
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 want to create the log file. If this parameter is omitted in the argument, by default it prints root in the log file.Syntaxlogger = logging.getLogger(_name_)The different types of logger level are listed below. We can add all, some or at least one logger in our test case.logger.debug("Debug log")logger.info("Information log")logger.warning("Warning log")logger.error("Error ... Read More
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 by logging the prior test step execution status and details. Thus debugging becomes easy and quick. Most logs are maintained in separate files which can be shared with other non- technical team members for analyzing a root cause for a failure.There are six logging levels with each level assigned an ... Read More
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 for reasons listed below −If the assertion does not pass.If there are sync issues between our application and Selenium.If there are timeout issues.If an alert appears in between.If the element cannot be identified with the locators.If the actual and final results are not matching.For capturing the screenshot, save_screenshot() method is ... Read More
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 the assertion does not pass.If there are sync issues between our application and Selenium.If there are timeout issues.If an alert appears in between.If the element cannot be identified with the locators.If the actual and final results are not matching.For capturing the screenshot, save_screenshot() method is available. This method takes the ... Read More
We can extract values from a specific cell (say 2nd row and 3rd column) inside a table in Selenium. First of all we need to locate the cell with the help of xpath locator.Since the row and column numbers are given, we can create a customized xpath with the help of indexes specified for both and tags. The rows of a table are represented by tag in html code. The data in each row is enclosed with the tag in html. Thus a tag’s parent is always a tag.So to get the value at ... Read More
We can count the number of occurrences of a particular text inside a table in Selenium. First of all we need to locate the element by xpath. In xpath, we have a particular text() function that identifies elements based on the visible text on the screen.Then we have to use find_elements method to get the list of matching elements having the text we are looking for on the page. Finally we need to get the size of that list with the help of the len function of the list.This will give the number of occurrences of a particular text inside ... Read More
We can get all the values inside a table in Selenium with the help of find_elements method. The rows of a table are represented by tag in html code. To get all the rows, we shall use the locator xpath and then use find_elements_by_xpath method. The list of rows will be returned. Next we need to compute the size of the list with the help of len method.Syntaxdriver.find_elements_by_xpath("//table/tbody/tr")Once we get all the rows, we now have to compute the number of columns.The headers of a table are represented by tag in html and always in the first row ... Read More