SELENIUM BASICS:


SELENIUM WEBDRIVER:


TESTNG:


REPORTS:


BUILD & CONTINUOUS INTEGRATION TOOLS:


CROSS BROWSER TESTING:


MOBILE TESTING:


AUTOMATION FRAMEWORKS:


API Testing:


INTERVIEW QUESTIONS:


SAMPLE RESUME:

How to Write Excel Files Using Apache POI In Selenium WebDriver

Let’s see how to Write excel files using Apache POI in Selenium WebDriver:

Assuming that you have already downloaded and configured Apache POI jars in your project. If not, follow the below steps:

Step 1– Download Apache POI jar file

Download link of Apache POI Jars.

Step 2– Add download 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

Complete Guide: Handling Excel Files Using Apache POI

Precondition: 

  1. Create an xlsx file and save it at particular location. Enter some data to read using Selenium. Close the created excel file before executing the script. (I have placed an excel file ‘Test.xlsx’ in my D Driver  and my sheet name is TestData.)
  2. Go to option “Format Cells” and under Number Tab option, select Text and click on OK. By default it will be general, you need to make it as Number. If you don’t make it as text, there is a chance of NullPointerException error.

Must Read: How To Install Apache ANT

Below mentioned script shows how to write excel files in Selenium using Apache POI.

Console Output:

Also Read: How to Read 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.

Sharing is caring.

Share on facebook
Facebook
Share on twitter
Twitter
Share on linkedin
LinkedIn

Get our latest blog posts delivered to your inbox

Subscribe and get popular blog posts about software testing industry.

Rajkumar

6 thoughts on “How to Write Excel Files Using Apache POI In Selenium WebDriver”

  1. Well explained . Keep it up

    • Thanks Tanaya.

  2. Hi i learned from your post.it’s very helpful .

    Note: Could u pls post new reg appium tutorial.

    Thanks
    Mahesh

    • Sure Mahesh. We have a plan. We will do it ASAP.

  3. Hey, I am getting null pointer exception while writing to excel. I tried saving file as text / number. Nothing helps.

    • Hi Mithun, are you still facing the same issue

Leave a Comment