We can get all the values of a particular column based on a condition 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 ... Read More

We can get all the values of a particular row based on a condition 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 ... Read More

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

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 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 ... Read More

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