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

getting error in numeric ,string and boolean

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 ...

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

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??

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

Hiii bro, im facing one error, please help me with this...
Exception in thread "main" java.lang.NullPointerException: Cannot invoke "org.apache.poi.xssf.usermodel.XSSFRow.getCell(int)" because the return value of "org.apache.poi.xssf.usermodel.XSSFSheet.getRow(int)" is null

super sir

Thank you very much for sharing your knowledge. Thank you for it.

Thank you for the clear explanation!!!

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??

facing error in above code line number 14 at my end and error is "XSSFWorkBook cannot be resolved to a type" and not able able to import what should i do? ... its allow to import as HSSFWorkbook and after run its throw "Exception in thread "main" org.apache.poi.poifs.filesystem.OfficeXmlFileException"

hi i am getting filenotfound error ehat should i do now ?? Help me with this error

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

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

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!!

Hi Sir,

Here I have one doubt.. For writing anything in the workbook means we will create the object for workbook..Here we are reading the file only..then y here we are creating the object and passing the file as parameter.. Existing excel only we are going to read then y we need to create the object and what is the use in it.. It's really confusing me sir.. Pls clarify my doubts...

Thank you sir

how to add in string n= sheet.getrow().getcell().getstring value()
;

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

Hello sir, your videos are really helpful.....thank you so much...can you please make a video on the hybrid framework