Found 871 Articles for Automation Testing

What is pytest and what are its advantages?

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:13:20

1K+ Views

Pytest is a test framework in python. To install pytest, we need to use the command pip install pytest. After installation, we can verify if python has been installed by the command pytest –version. The version of pytest shall be known.Pytest can be used for creating and executing test cases. It can be used in wide range testing API, UI, database and so on. The test file of pytest has a naming convention that it starts with test_ or ends with _test keyword and every line of code should be inside a method which should have a name starting with ... Read More

How to create a worksheet and write some values in it in Selenium with python?

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:12:03

995 Views

We can create a worksheet and then write some values in it. 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

How to get all the values of a particular column based on a condition in a worksheet in Selenium with python?

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:09:15

684 Views

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

How to get all the values of a particular row based on a condition in a worksheet in Selenium with python?

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:07:32

787 Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:05:55

321 Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:04:09

6K+ Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:02:47

632 Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:01:28

2K+ Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 11:00:05

778 Views

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

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

Debomita Bhattacharjee
Updated on 29-Jul-2020 10:58:17

1K+ Views

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

Advertisements