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
File
Properties File | Accessing properties file for user input or test data.
According to name, a Properties file is used to define properties of keys which would have been used in our Selenium project. A Property file contains data in Key=Value format. It helps external users to communicate with the code and generate output on the basis of inputs. Features of a Property File: Can be usedRead 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 || Traverse folders and subfolders in Java.
As we all know that we can read or write data on any format of file whether it is excel, word, notepad. But sometimes we need to traverse folders and subfolders to locate any file. Also, sometimes we need to identify the file folder count under specific directory, find a file with specific name, findRead More
File Handling | Reading data from PDF file using JAVA.
Reading data from PDF file using JAVA. User would be able to perform operations on PDF files like reading all the content from PDF file, searching any text in the PDF file, getting total number of lines etc. Pre-requisites To read the PDF file, first of all, you should download the Apache PDFBox library whichRead 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 | Implement formatting in Excel using Java.
While writing data through the code we can also implement formatting in Excel sheets. Applying to format is a very simple process. Here we are taking an example that we have to write a few data into the excel sheet. And then apply format on Heading Row as setting font color WHITE, BOLD and CellRead 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