How to read/write data from Excel file using Apache POI API in Selenium || Latest POI Version

In this video, I have explained how to read/write data from Apache POI API.
-How to use test data from excel in Selenium.
-How to perform data driven approach using POI APIs - Excel Files.
--Different operations like :

Read/Write,
getRowCount,
getColumnCount,
getCellData,
setCellData,
addSheet,
AddColumn,
RemoveColumn,
isSheetExists etc..

Here is the GIT Repo URL for Xls_Reader. java file:

Get all POI dependencies:

GIT Hub URL:

You can download the latest utility jar from here :

~~Subscribe to this channel, and press bell icon to get some interesting videos on Selenium and Automation:

Follow me on my Facebook Page:

Let's join our Automation community for some amazing knowledge sharing and group discussion on Telegram:

Paid courses (Recorded) videos:
📗 Get My Paid Courses at
Paid courses (Recorded) videos:
-------------------------------

✔️SOCIAL NETWORKS
--------------------------------

Support My Channel✔️Or Buy Me A Coffee
--------------------------------
✔️Thanks for watching!
देखने के लिए धन्यवाद
Благодаря за гледането
感谢您观看
Merci d'avoir regardé
Grazie per la visione
Gracias por ver
شكرا للمشاهدة

[mithaleepardeshi]

I was clapping with happiness when you could solve the clear problem on crm website :P

[manojmadavi]

Thanks Naveen sir for such video on Automation its really helpful for me.

[abc-jzty]

Thank you soo much naveen for the videos on automation this is really helping me for my interview preparation

[ArtiSingh-yxpj]

Hi Naveen, thank you so much for this video but can we do this in the framework where we are using Page object model approach with TestNg? actually i am confused, is there only dataprovider through which we can read data from excel in TestNg or we can use Apache Poi API what you have shown in this video? And how to write data into excel by using dataprovider in TestNg? I did not get it anywhere, i want to implement same thing you have shown here in my framework where i am using TestNg and POM approach with Maven.

[jannatulnayeem]

Very informative Vedio...thanks for uploading

[omkarpotdar]

Thanks a lot Naveen for providing these useful utilities with us. This utility really helps me with my project. Excellent work Naveen. Just one request, could you please make a video on how to read/write data from .csv file?

[victor]

Good job 👏 Very thankful for your great video

[pravesh]

Hi Naveen
I can give some suggestions to your approach.
You can add test case name and runnable flag in your excel first read the test case name and if runnable flag is y then only pick that else not
And add one column called test status and exception if test is passed put pass there and if failed put exception.

[nivd]

I need to write to the excel after each cucumber scenario and our test cases works in parallel. I tried with synchronized method but seems it is not working. Can you show how we can achieve that

[shwetamahajan]

I am getting the folowing exception- The element 'created' must have the 'xsi:type' attribute present ! can u plz give some suggestions...

[PK-nrvj]

Hi I need one help.
I have urls in excel file. For launching browser I want to fetch particular urls from excel sheet.If I insert again different urls into excel.at that without updating into code.automatically fetch the url which is required for the page and run the script.
Please can you tell me solution

[ParthKandpal]

Thank you very much naveen..
Can you please make a video on certifications for QA.
Please check your linkedin. I have pinged you.

[kshipra]

Is it possible to work with online excel data sheet in my selenium framework? I don't have ms office in my system.

[VISHAL]

Hello sir. Your video is quite informative. Thanks for that. Can we read the excel data and change it in default pdf file by just changing attributes obtained from excel

[pradeepjadhav]

Hi naveen, if I want to read the data from one excel and after reading the data I have to write same data in another excel, so how can I do it?

[traineegagan]

how can I append time with excelsheet name?... for example if I have to create a new sheet for writing something in it... Everytime I execute the test case-i have to delete that sheet first otherwise it shoows error- "xyz" sheet already exists. how can append time with sheetname?

[haarikagummadi]

Sir I want to know how to pick the particular value from excel sheet with out hardcoding. I don't know how many rows and columns in excel sheet please tell me sir..

[tejasnagpure]

Hi Naveen is there any way to download an excel and just after downloading the file we can retrieve the data from the file in same test case execution

[varunpola]

Hi sir, can you explain how to read or write the data from Google sheet.

[gilsonsouza]

Hi, How so save the excel file using Selenium after write and add some rows?