SELENIUM BASICS:

  • What is Automation Testing - Advantages & Types of Tools
  • What is Selenium IDE, Selenium RC, Selenium WebDriver, Selenium Grid?
  • Selenium IDE, Firebug & Firepath Installation

  • SELENIUM WEBDRIVER:

  • Selenium WebDriver Architecture
  • Selenium Installation
  • Challenges and Limitations of Selenium
  • First Selenium WebDriver Script
  • Working with Firefox Browser
  • Solution - Failed To Launch Browser Using Selenium WebDriver
  • Working with Chrome Browser
  • Working with IE Browser
  • Difference Between FindElement & FindElements
  • Install Firebug, Fire path and other add on for Selenium
  • Locators in Selenium
  • Dynamic Xpath
  • Dynamic CSS
  • Handle drop-downs
  • How to work with file upload
  • Handle Alerts & Popups
  • Handle Multiple Windows
  • Mouse Hover event in Selenium
  • Right Click
  • Double Click
  • Drag and Drop
  • Capture Screenshots in Selenium
  • Parameterization
  • Synchronization
  • Implicit Wait, Explicit Wait and Fluent Wait in Selenium
  • Implicit Waits
  • Explicit WebDriver Waits
  • Fluent Wait In Selenium
  • Apache POI
  • How To Read Data From Excel File
  • How To Write Data In Excel File
  • Database Testing Using MSSQL
  • Database Testing Using MySQL
  • Database Testing Using DB2
  • Handle Ajax Call in Selenium
  • Listeners in Selenium
  • Handling JavaScript in Selenium
  • Stale Element Reference Exception in Selenium
  • Integrate Sikuli with Selenium
  • Headless Browser Testing 
  • Headless Browser Testing using HtmlUnitDriver
  • Headless Browser Testing using PhanthomJSDriver

  • TESTNG:

  • TestNG Installation
  • TestNG Complete Tutorial

  • REPORTS:

  • Extent Reports Introduction
  • Extent Reports Generation
  • Capturing Screenshots & Including In Extent Reports
  • Extent Reports Version 4

  • BUILD & CONTINUOUS INTEGRATION TOOLS:

  • ANT Build Tool - How To Download & Install
  • Maven Build Tool - How To Download & Install
  • Creating Maven Selenium Project
  • GIT Integration with Selenium
  • Jenkins - How To Download & Install
  • Jenkins - Executing TestNG Scripts
  • Jenkins - Generating Reports After Test Execution
  • Jenkins - Executing Maven Project
  • Create build and Execute build for nightly execution
  • Send Email report based on build Status
  • Selenium Continuous Integration with Jenkins [Selenium – Maven – Git – Jenkins] – Step By Step Guide

  • CROSS BROWSER TESTING:

  • Running Selenium Tests On BrowserStack
  • Kobiton - Mobile Testing Platform with Real Devices

  • MOBILE TESTING:

  • Mobile Testing Platform with Real Devices

  • AUTOMATION FRAMEWORKS:

  • What is Framework & Types of Framework
  • Page Object Model Design Pattern
  • Data Driven Framework
  • How to explain Test Automation Framework or Selenium Automation Framework Architecture In Interview

  • API Testing:

  • Learn API Testing
  • Postman Tutorial (API Testing with Postman)

  • INTERVIEW QUESTIONS:

  • Test Automation Framework Interview Questions
  • Selenium Interview Questions
  • TestNG Interview Questions
  • Java Interview Questions
  • Python Interview Questions
  • API Testing Interview Questions

  • SAMPLE RESUME:

  • Automation Tester Resume
  • Handling Excel Files Using Apache POI In Selenium WebDriver

    Handling excel files Using Apache POI in Selenium WebDriver. As we all know Selenium supports only Web browser automation. We need to get the help of third party API like Apache POI to handle (read and write) excel files using Selenium WebDriver.

    What is Apache POI?

    Apache POI is an open source library developed and distributed by Apache Software Foundation to design or modify Microsoft Office files using Java program. It is a popular API that allows to work around excel files using Java Programs. In short, you can read and write MS Excel files using Java. Apache POI is your Java Excel solution.
    You’d use HSSF if you needed to read or write an Excel file using Java (XLS). You’d use XSSF if you need to read or write an OOXML Excel file using Java (XLSX). It has many predefined methods, classes, and interfaces.

    Official website of Apache POI

    List of different Java Interfaces and classes in POI for reading XLS and XLSX file

    Java Interface List To Read & Write Xls & Xlsx Files

    Workbook: HSSFWorkbook and XSSFWorkbook classes implement this interface
    HSSFWorkbook: It is a class represents XLS file
    XSSFWorkbook: It is a class represents XLSX file
    Sheet: HSSFWorkbook and XSSFWorkbook classes implement this interface
    HSSFSheet: It is a class represents a sheet in a XLS file
    XSSFSheet: It is a class represents a sheet in a XLSX file
    Row: HSSFWorkbook and XSSFWorkbook classes implement this interface
    HSSFRow: It is a class represents a row in a sheet of XLS file
    XSSFRow: It is a class represents a row in a sheet of XLSX file
    Cell: HSSFWorkbook and XSSFWorkbook classes implement this interface
    HSSFCell: It is a class represents a cell in a row of XLS file
    XSSFCell: It is a class represents a cell in a row of XLSX file

    Download link of Apache POI Jars.

    Download the jar files using the above mentioned link. All jar files will come in a zip file. Extract it and Add all jar files in the Project.

    Must Read: How To Install Apache ANT

    Note: How to add Jar files – Select Project and Right click on the Project – Go to ‘Build path’ – Go to ‘Configure build path’ – Click on ‘lib’ section – Add external jar

    We do handle excel files using Apache POI in Selenium WebDriver very often. Mainly coming to Automation framework (Data Driven Framework), we call the data from excel file and write the data in the excel file. Below links give an idea about Read/Write excel files using Selenium WebDriver.

    How to Read Excel Files Using Apache POI In Selenium WebDriver

    How to Write Excel Files Using Apache POI In Selenium WebDriver

    If you are not regular reader of my blog then I highly recommend you to signup for the free email newsletter using the below link.

    Handling Excel Files using Apache POI

    Get our latest blog posts delivered to your inbox

    Subscribe and get popular blog posts about software testing industry.

    Rajkumar

    8 thoughts on “Handling Excel Files Using Apache POI In Selenium WebDriver”

    1. Can you tell,how to explain Keyword driven frame work in Interview?

      • Hi Satish, earlier I have clearly explained hybrid framework check this link for that. Whatever framework it is you just follow the way I did in that. Coming to keyword driven, I will try to write a separate post. In keyword framework, we create methods for each and every action. We keep those methods in excel sheet and call those actions whenever required in the test scripts. The main advantage of this is reusability of code. Most of the companies use the hybrid framework. As per my knowledge, very few use keyword driven. We could take more advantage by combining multiple frameworks. Refer this – Types of frameworks

    2. Hi Raj Kumar,
      Thanks for the detailed document for each topic. Very helpful.

      • Welcome Rajashekar.

    3. Hi Raj Kumar,
      Thanks for the detailed document for each topic. Very helpful.

      can you please keep the core java interview questions for the selenium automation testers

      Thanks in advance

      • Hi Shivateja, Sure I will update ASAP. Also I will publish Java tutorial by end of this weekend.

    4. Hi Raj,

      Thanks for this tutorial.I am biginner to selenium and your post helped me alot.

    Leave a Comment

    Share via
    Copy link
    Powered by Social Snap