TestNG – 16 || Access data from Excel sheet using DataProvider.

We can use an Excel sheet as a source of input. We can access data from excel sheet using DataProvider annotation and pass arguments through @Test methods. Mainly this approach is used in Data Driven Framework.     Data Driven Framework: A data-driven framework is used to run the same script for a huge amountRead More

Framework || Simple example of Key Driven Framework using excel sheet in Selenium(JAVA).

This is an small and simple example of Key Driven Framework to execute test cases using excel sheet in Selenium(JAVA).          Key Driven framework is based on keywords which are used to control the execution of the script without modifying the actual code. A tester has to just set the keywords whichRead More

Copy formatting & style of cells from one sheet to another.

This blog contains steps to copy Formatting & Style from one Excel sheet to another sheet. Also, shows how to identify the Cell Type. To implement formatting in the excel sheet while writing data, please visit the below link: Copy Formatting & Style Below are the requirements: inputfile.xlsx file Sheet having list of few ElectronicRead More

File Handling || Multiple file creation using template based input data.

In our previous chapter, we have learned “How to read and write data into a text file?”. In this chapter, we learn how to create multiple files using a Template. The data in these templates would be populated from another file which is called Input datafile. Understand template-based file handling Getting the content and structureRead More

File Handling | Copy existing data from one workbook to another workbook in Java.

Copy existing data from one workbook to another workbook in Java using File Handling. We have to copy existing data from one workbook to another workbook in Java. Example: This includes all the sheets and its content from input workbook as mentioned in the below example. Overview of Program As per the above screenshot, we clearlyRead More

File Handling | Writing data into an Excel(.XLSX or .XLS) File.

Writing data into an Excel(.XLSX or .XLS) File using JAVA. Overview of the Program Locate path and filename where the new excel file will be created using File Class. Load the newly created file into FileOutputStream Class, so that new content can be written in it. Create workbook using XSSFWorkbook class. Create sheet in theRead More

Site Statistics

  • Users online: 0 
  • Visitors today : 8
  • Page views today : 8
  • Total visitors : 50,681
  • Total page view: 69,802

   YouTube ChannelQuora

            Ashok Kumar is working in an IT Company as a QA Consultant. He has started his career as a Test Trainee in manual testing in August 2010. Then he moves towards the automation testing after 4 years. He started learning JAVA and Selenium by self to get the knowledge of automation.

       While learning these tools and working on multiple projects, he found that sometimes people get stuck in live scenarios in their project and they have to do lots of RnD to get out of it. So he decided to start blogging only for such scenarios, where anyone facing any problem in their project, can ask any question or give a solution or you can say an alternate solution to achieve the goal successfully.

Later on, he observed that some people want to learn Java but they have few questions in their mind like how to start Java, whether we should go for the online or offline course. So he started writing tutorials on Java, Jira, Selenium, Excel etc.