How to Read Excel File using Apache POI | Selenium WebDriver |

In this video, I have explained how to Read Excel File using Apache POI.

Apache POI is an API provided by Apache foundation which is a collection of different java libraries.
These libraries give the facility to read, write and manipulate different Microsoft files such as excel sheet, power-point, and word files, etc.

Download Apache POI from the below link:👇

==============================================

👑 Join my YouTube channel to get access to perks:👇

==============================================
==============================================
Connect us @
==============================================
==============================================
🙏 Please Subscribe🔔 to start learning for FREE now, Also help your friends in learning the best by suggesting this channel.

#hyrtutorials #ApachePOI #selenium #webAutomation
Apache POI By Yadagiri Reddy

This video clarifies the below questions on Apache POI:
✔ What is the excel workbook structure?
✔ What is the component used for handling the older version of the excel file?
✔ How to read an excel file using apache poi?
✔ How to read data from excel using selenium webdriver?
✔ How to read an excel file with a user-defined sheet name?
✔ How to access a sheet from an excel file using apache poi?
✔ How to get rows in excel using apache poi?
✔ How to get physically defined number of rows?
✔ How to get physically defined number of cells?
✔ How to get data from the String type of cell using apache poi?
✔ How to get data from the Boolean type of cell using apache poi?
✔ How to get data from the Numeric type of cell using apache poi?
✔ How to identify the cell type in apache poi?
✔ How to close the workbook in apache poi?
✔ What is HSSFWorkbook?
✔ WHat is HSSFSheet?
✔ WHat is HSSFRow?
✔ What is XSSFWorkbook?
✔ WHat is XSSFSheet?
✔ WHat is XSSFRow?
✔ When HSSF is used and When XSSF is used?
✔ Component Map of Apache POI?
✔ Can Apache POI will be used in Selenium WebDriver?
✔ How to Read Excel File in Selenium Webdriver Using Apache POI?
✔ How to read/write data from Excel file using Apache POI API in Selenium?
✔ Read & write excel sheet data in Java using Apache POI?
✔ Reading Excel using Apache POI in Java?
✔ How to read excel file using Apache POI?

Video search tags:
apache poi java tutorial,apache poi java excel,read excel selenium,read excel file in selenium webdriver,write data into excel using apache poi,java,xssf,workbook,how to read excel file in selenium webdriver using apache poi,how to use apache poi in eclipse,how to read excel file,read excel file in selenium webdriver java,excel,selenium,selenium webdriver tutorial,selenium webdriver,read excel file in selenium webdriver poi,microsoft excel,apache poi download for selenium webdriver,apache poi java excel api,how to read data from excel sheet in selenium webdriver using java,how to read excel file in selenium webdriver using java,,read excel file in selenium java,how to read data from excel in selenium webdriver using poi,selenium tutorial for beginners,selenium testing tool,read data from excel,,read data from excel in selenium,selenium tutorial for beginner,java tutorial,selenium webdriver tutorial for beginners,selenium java,xls,selenium interview questions and answers,.xlsx file handling,read excel in selenium,excel read and write,selenium .xlsx,how to read excel data,selenium excel data-driven,java read excel,apache poi excel tutorial,read excel file in java selenium,excel java,automation testing tutorial for beginners,automation testing tools,software testing tools,selenium tutorial,selenium tutorials,how to get excel data in selenium,automation testing,readwrite excel,selenium framework using java,automation,selenium webdriver tutorial for beginner,how to read data from excel,how to read data from excel in selenium webdriver using testng,read excel data in java,how to read excel data in selenium

[pranavkhurud]

I'm getting
[ error statuslogger log4j2 could not find a logging implementation. please add log4j-core to the classpath. using simplelogger to log to the console... ]this error msg in console what does this mean??

[apoorvsinha]

can you please tell me changes to read ODS instead of XLSX

[ashwinjayaraj]

My file is in .csv format. Please suggest on the same.. Its as excel but in .csv format

[GenshinGuyy]

Hiii bro, im facing one error, please help me with this...
Exception in thread "main" Cannot invoke because the return value of is null

[imrankhan-rgzk]

I have questions
I want exclude the header of the excel
Could you please share rhe logic here or anyone knows about that

[ERUCSE]

how to read a drop-down list in excel using selenium Apache POI

[swapnilpujari]

Your explanation is very appreciable. So neat and easy to understand. Really its helping me a lot in getting my concepts clear. Thank you very much for letting us understand in very well manner.

[okk-wpyl]

getting error in numeric, string and boolean

[kshipra]

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

[SagarPatil-]

Sir pls give any ex where we can provide this data directly from Excel sheet

[krusharthshah]

Hi. While I want to import and read Excel data in Java, "XSSFSheet sheet = workbook.getSheetAt(0);" I am getting an error in this line. The error is: "The method getCell(int) is undefined for the type Object". I don´t know how to solve this error. Please help me out. Thanks in advance!!

[gilsonsouza]

Hiiii, I have another question to you : )

Scenario - This is how my excel looks like:

1° column - Customer name
2° column - Customer type

So there are many lines with this information!

My automation will not need "ALL" the excel information. lets say that the automation will find the exact customer name in the web application. Then with this information (Customer name) I need to read the excel to discover the Customer type.

My question is:

- How can I search for the exact meet customer name in the excel (using Apache POI ore any other API).
- After search, discover the index from the cell in the column 1
- And look to the same index but in the column 2
- Bring the content from the cell - column 2- and print it

than I will be able to decide what to do

E.g.

If ( CustomerName == partner)
{
Send this email
}Else{
Send a different email.
}


Can you help me with that ???

Thank you so much

[tarluck]

Hi,
first i'll thank you for your video, i tried to import apache hssfworkbook etc... i added the my project many JAR's file but unfortunately, the import didin't succed,
i use jdev 11g, please guide me to the solution, wich Jar do i use for this version of jdev
thanks

[BharuChowdary]

hello brother it was useful...but i want to know how to add that converted string in data driven framework. please do reply i have a assignment today

[ramutule]

Hi.. I want to get the row index value. Like 1, 2, 3.. Etc .row numbers. Could you please tell me how to get that rown number?

[unmeshinde]

I found this topic a little bit hard, and where I learnt it before, I haven't had much in depth clarity. But after watching your video it's getting clearer a bit ...

[gayathrik]

Hi HYR gaaru, i learnt a lot from your videos till now. now am trying to learn frameworks. can you please make a videos on frameworks please

[amarbhairat]

Your explanation is very good Sir...
If I want to use HashMap to store this data as a key-value pair as a First Row is Keys And remaining Rows are Value Respectively then which changes I have to do in this code??

[indrajitkhandalkar]

Thank u sir for providing valuable knowledge... Sir plz make video on how to write in excel sheet by using selenium webdriver

[RakeshSaineni]

My file doesn't have any extension like (.xlsx)
I have to use filename or filename.xlsx?