Skip to main content

Selenium Function Library + File Handler

Here is my first attempt towards building Selenium Function Library. Here is a class which deals with File handling. Hence test data can be externalized in to notepad, excel, word pad instead of hard coding it in Selenium Scripts. So you can fetch test data using excel, csv etc and supply it to Selenium, more over you can execute same Selenium script for different set of data.

Java jars which I used here are jxl and Apache HSSF

/**
 * Performs read/write operations on files
 * 
 */
public class FileHandler {

 /**
  * Retrieves the data from the properties file using variable name.
  * 
  * @param path
  *            to Property file.
  * @param variableName
  *            stored in the properties file.
  * 
  * @return value of property
  * @throws Exception
  */

 public static String getDataFromPropertiesFile(String path,
   String variableName) throws Exception {
 }

 /**
  * Retrieves the Excel cell value based on the row and column number.
  * 
  * @param path
  * @param sheetNumber
  * @param rowNumber
  * @param col
  * @return cell value
  * @throws Exception
  */
 public static String readExcelData(String path, int sheetNumber,
   int rowNumber, int col) throws Exception {
 }

 /**
  * Writes the provided value to the Excel cell based on the row and column
  * number.
  * 
  * @param path
  * @param rowNumber
  * @param col
  * @param addDataToCell
  * @throws Exception
  */
 @SuppressWarnings("deprecation")
 public static void writeToExcel(String path, String sheetName,
   int rowNumber, int col, String addDataToCell) throws Exception {
 }

 /**
  * Retrieves single row data based on the row number
  * 
  * @param path
  * @param sheetNumber
  * @param rowNumber
  * @return cell values of a single row
  * @throws Exception
  */

 public static ArrayList getRowDataFromExcel(String path,
   int sheetNumber, int rowNumber, int startColNumber)
   throws Exception {
 }

 /**
  * Retrieves column data based on the row number
  * 
  * @param path
  * @param sheetNumber
  * @param colNumber
  * @param startRowNumber
  * @return cell values of a single column
  * @throws Exception
  */
 public static ArrayList getColumnDataFromExcel(String path,
   int sheetNumber, int colNumber, int startRowNumber)
   throws Exception {
 }

 /**
  * Provides the cell type of a cell whether its a Numeric, string,
  * blank cell etc.
  * 
  * @param cell
  * @return cell type based on the cell
  * @throws Exception
  */

 public static String cellToString(HSSFCell cell) throws Exception {
 }

 /**
  * Gets the columns in csv file
  * 
  * @param filePath
  * @return
  */
 public static List getColumns(String filePath) {
 }

 /**
  * 
  * Reads CSV data in to HashMap
  * 
  * @param project
  * @param filePath
  * @return
  */
 public static HashMap readcsv(String filePath) {
 }

 /**
  * Returns Data from the Notepad
  * 
  * @param path
  * 
  * 
  * @return data or null
  * @throws IOException
  */

 public static String readFromNotepad(String path) throws IOException {
 }

 /**
  * Writes the contents into Notepad.
  * 
  * @param path
  * @param text
  * @throws Exception
  */

 public static void writeContentsToNotepad(String path, String text)
 }

 /**
  * Retrieves contents from Word document
  * 
  * @param path
  * 
  * @return content or null
  * @throws Exception
  */
 public static String readFromWordDoc(String path) throws Exception {
 }

 /**
  * Writes the content to Word document.
  * 
  * @param path
  * @param addText
  * @throws Exception
  */
 public static void writeToWordDoc(String path, String addText)
 }
} 

Comments

  1. How can we know about these jar files. Here you have used jxl for excel. Like that can u pls gimme more info on that.

    ReplyDelete
  2. I mentioned it - "Java jars which I used here are jxl and Apache HSSF"

    ReplyDelete

Post a Comment

No spam only genuine comments :)

Popular posts from this blog

Verify email confirmation using Selenium WebDriver

Note: If you are new to java and selenium then start with selenium java training videos .   How to Verify Email Confirmation Using Selenium 4 and JavaMail (2026 Guide) Email confirmation is a critical part of most registration flows — account activation, password reset, multi-factor authentication, and onboarding. Every automation engineer eventually faces the same challenge: How do you verify an email confirmation link inside a Selenium test without making it slow and flaky? The wrong instinct is to automate Gmail's UI with Selenium. It's fragile, slow, and breaks constantly. The right approach: Use Selenium for browser automation Use JavaMail (IMAP) to read the email directly Extract the confirmation link Continue the test in Selenium Why Not Automate Gmail UI With Selenium? Automating the Gmail UI means logging in, searching, clicking a message, and parsing content from a third-party interface that changes frequently. This leads to: Flaky...

Using xPath to reach parent of an element

Note: If you are new to java and selenium then start with selenium java training videos .   I generally prefer CSS selectors over XPath when writing Selenium locators. CSS selectors are concise, readable, and usually provide everything I need. However, there are situations where XPath is a better fit—particularly when I need to navigate through an element's hierarchy, such as moving from an element to its parent, grandparent, or sibling. This post shows one such real-world example. The Problem I came across a situation where I needed to click a link based on the value of an input field. The HTML structure contained multiple similar groups of elements. The input field and the link I wanted to click were not directly related, but they shared a common parent structure. In the following example above, the input element is highlighted, and I need to click the corresponding anchor ( <a> ) element . The challenge is that there may be multiple similar structures on the page. I th...

Real Time JMeter Result Using Backend Listener

Since JMeter 2.13 Backend Listener has been available to create real time graph of JMeter Test. Following tutorial explain the entire process in detail. At the end of this tutorial you would be able to create JMeter Live Test Result dashboard similar to following - This tutorial borrows information from many sources and my own experiments with JMeter live reporting dashboard. I have added source of information wherever applicable But before we can build such a snazzy JMeter Live Reporting dashboard we need to understand two more components - influxDB (a time series database) and Grafana Dashboard This is a big tutorial, so take deep breath :-) and follow on. Once you complete set up specified in this tutorial then you can watch JMeter Training Video Tutorial to watch this in action. What is Time Series Database? A time series is a sequence of data points , typically consisting of successive measurements made over a time interval . Examples of time ...