How to Read Excel File in Selenium Webdriver Using Apache POI

Thank you so much Mukesh for wonderful tutorial series. I am learning so many concepts from u

Exception in thread "main" java.lang.IllegalArgumentException: Sheet index (0) is out of range (no sheets)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.validateSheetIndex(XSSFWorkbook.java:1484)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.getSheetAt(XSSFWorkbook.java:1186)
at lib.excelDataConfig.getData(excelDataConfig.java:32)
at pages.login.main(login.java:9)

I am getting this error

Sound athigama vachi podu da body stodaa

hi sir is there any other api apart from Apache poi to read excel in java

great viseo

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

Thank you Bhai!!💥

Hi, Please make a video of reading data from a JSON file and writing it into an Excel sheet using Selenium+Java code.

Iam getting like this D:\Excelreader (Access is denied). could u pls help me sir

Very well explained and easy to understand

Thank you for sharing your knowledge with us.

How to put the excel data into a website? For example there is IP address of a system and a excel file in a location. SO if we give IP address then it should display excel data. By the way your video is really very helpful. Thank you very much.

How to read ODS file instead of XLSX, BTW very helpful video

Great work Well explained 👍

what if the excel sheet data contains both numeric and string values , then we cant use the same loop right?

Hi if we need to take from excel having first value null but next value has a data

One of the best tutorial I have ever learnt ❤️ thank you mukesh for this wonderful explanation 💥

What a wonderful lecture? Many thanks.

Hi Mukesh, It will be helpful if you have any video example with able to read data from excel if using pipe ex : abcd | abcd1 and print individually