How to Read Excel File in Java using Apache POI | Data Driven Testing in Selenium

In this video, We will be using Apache POI to read data, for example, username and password from the MS Excel file, and then, we will use that data in Selenium script.
Apache POI is a popular open-source Java library provided by the Apache Software Foundation.
It allows developers to create, modify, and manipulate Microsoft Office documents programmatically using Java.
Specifically, it provides APIs for working with Excel (HSSF and XSSF), Word (HWPF and XWPF), and PowerPoint (HSLF and XSLF) files.
This library is commonly used in Java applications for tasks such as reading data from Excel spreadsheets, generating Excel reports, or creating PowerPoint presentations dynamically.
#How to Read Excel File in Java using Apache POI
#Selenium Java
#Excel Automation
#Java Excel Tutorial
#Data-Driven Testing
#Test Automation
#Java Programming
#Excel Manipulation
#Excel Handling in Java
#Automation Framework
#Apache POI Tutorial
#Selenium WebDriver
#Excel Read Write
#Java Automation
#Software Testing
#SDET Adda For QA Automation
#Raghavendra Mishra
#SDETQA
I hope you have liked the explanation and learned from this video. Please do like and subscribe to my channel and share it with your friends, Also share the feedback in comment section.
Website for reference: opensource-dem...
POM Dependencies-
Apache POI: mvnrepository....
Selenium Java: mvnrepository....
Playlists in this channel's are:
******************************************************************************************************
Selenium Cucumber BDD Framework development with Java and TestNG | Latest Features (2023-2024) Series
• Selenium Cucumber BDD ...
Playwright with Java script [2024 latest] - End to end - By SDET Adda for QA Automation:
• Playwright with Java s...
TestNG + Selenium 4 Tutorial -2024 Updated 🔥🔥🔥
• TestNG + Selenium 4 Tu...
Linux and Bash Scripting Tutorial [2024 Updated]
• Linux and Bash Scripti...
VirtualBox and Virtual Machine setup for Selenium Automation: • VirtualBox and Virtual...
Selenium Grid Tutorial For Beginners [2024 latest] - End to end - By SDET Adda for QA Automation: • Selenium Grid Tutorial...
Git & GitHub Tutorial for Beginners [2024 Updated]: • Git & GitHub Tutorial ...
Apache Maven Tutorial for Beginners | SDET ADDA: • Apache Maven Tutorial ...
Jenkins 2024 Tutorial For Beginners | DevOps CI/CD | SDET ADDA: • Jenkins 2024 Tutorial ...
Karate Framework Tutorial:
• Karate Framework Tutorial
Top 100 Java Programs for Programming/coding and QA interviews
• Top 100 Java programs ...
******************************************************************************************************

[@riyashukla1717]

Well explained sir

[@sdetadda]

Thanks and welcome

[@poojashinde9494]

Nice explaination thanks .....

[@TestingUnlimited]

Excellent, thanks bro.

[@sdetadda]

Glad it helped

[@boundlessgyan]

good explanation, thanks

[@sdetadda]

Glad it was helpful!

[@TestingUnlimited]

Good demonstration, thanks.

[@sdetadda]

Glad it was helpful!

[@piyushkusrey2020]

Hi, I have one doubt
When we use fileinputstream class ?
this also used for reading the data right?

[@sdetadda]

Yes, correct.

[@user-vn4xf3qw5v]

can we also do write method to store few values in the excel ?

[@sdetadda]

Certainly, here is the video to achieve that - th-cam.com/video/ftbC4u_31Ec/w-d-xo.html