Selenium Tutorial – Hybrid Automation Framework – Part 2 – Data Driven Framework -1

• What is Data Driven Framework?
• Why you should use Data Driven Framework?
• Read/Write from Excel files using Apache POI API
  • Downloading Apache POI API
  • Setting up Apache POI API in Eclipse
  • Reading specific cells
  • Creating a sheet/row/cell
  • Writing to specific cells
  • NullPointerException handling for blank rows/cells

Selenium Tutorial – Hybrid Automation Framework – Part 2 – Data Driven Framework-2

• Creating reusable Excel Helper class to read/write from Excel files
• Building the Data Driven Framework for a E-Commerce Website
• Creating Test Cases and Test Data in Excel
• Automating the Test Cases with Selenium WebDriver using Page Objects Framework
• Developing Required JAVA Function Libraries
• Developing Data Driven Helper class to help data driven testing
• Reading the Test Data from Excel files
• Applying Excel Test Data to Web Elements as per Test Case
• Running the Automated Tests with different sets of Test Data
• Moving shared code to TestBase class for easy maintenance, reusability
• Developing a single data provider method for all test cases for easy maintenance, reusability
• Using JAVA properties file to specify Test Data Excel file, Test Data Excel Sheet

Note:  In TestBase class, testConfig field needs to be static member (protected static Properties testConfig;) so that after initialisation in beforeSuite(), testConfig can be shared & reused across all test classes