Selenium How to read data from excel sheet using POI API

DURGASOFT is INDIA's No.1 Software Training Center offers
online training on various technologies like JAVA, .NET ,
ANDROID,HADOOP,TESTING TOOLS , ADF, INFORMATICA, SAP...
courses from Hyderabad & Bangalore -India with Real Time Experts.
so that our Supporting Team will arrange Demo Sessions.
Ph:Call [phone],[phone],[phone],[phone].

[phoenixmoguns]

Thanks for the Video, which is useful for real time scenario instead of reading the data and printing in console. Appreciate your Effort. :)

[radhwanianchal]

Thanks for making it understand so easily, kindly share test ng with groups and dataprovider

[yuvathejak]

Thank you Soo Much for giving Good understanding

[bharath]

and if someone is using numbers in excel and try to print it out, i recommend you to enter number in excel starting with a small single quote like this '
example: - to put number 123, try entering as '123 and save the excel.

[sainiranjan]

Namaste Sir, As I run on local I have no issues but when I upload to Azure DevOps (CI/CD) and run remotely, build failed with below errors. I was wondering why Azure DevOps failing to download the packages? Any suggestion please!
[INFO] Compiling 32 source files to
[INFO]
[ERROR] COMPILATION ERROR :
[INFO]
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[8, 35] package org.apache.poi.ss.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[9, 37] package org.apache.poi.xssf.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[10, 37] package org.apache.poi.xssf.usermodel does not exist
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[18, 9] cannot find symbol
symbol: class XSSFWorkbook
location: class
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[20, 9] cannot find symbol
symbol: class XSSFSheet
location: class
[ERROR] /e:/a/1/s/ExceleRATE/src/main/java/com/qa/ExceleRATE/util/ReadExcelData.java:[31, 34] cannot find symbol
symbol: class XSSFWorkbook
location: class
[INFO] 6 errors

[luckywithpooji-telugu]

but every one tell single row data at a time or coloum but both combination how to print

[virenderkamboj]

Hi,
This is very helpful.
Thanks!

Can you help me to iterate multiple set of data type from excel to application ?

[lokeshdohare]

Do version of MS office matters while using Apache POI??

[donatesmile]

Hi Durga Software Solutions,
Suppose i have two same .xlsx file then how can we read and compare these two same file in selenium webdriver so that if any row or column gets mismatch then it print the error message . Any idea ?
Thanks

[tejasvisabharwal]

Iterable<Row> rw = (Iterable<Row>) sheet.iterator();
while (rw.hasNext()) {


}


rw.hasNext() is underlined. telling *cannot find symbol*

[bharathiv]

Hi Sir, how to process the excel with the empty value. please assists

[shwetaadhikari]

And plz tell us about how to create reports using junit

[vikramd]

I tried the above program but all the user name and password available in excel sheet are printed in a stretch.

[shwetaadhikari]

Plz tell an easy way to create reports

[kirantherise]

I try this but I have got error "OfficeXmlFileException:" can you help this out.

[nikitabais]

can you please tell me if the excel contain first row i.e header as Username and password then while reading data from excel why didnt take Username and password as first value, it gets start from second row

[luckywithpooji-telugu]

but how to print total username and passwors at time

[shwetaadhikari]

can u plz tell how to write into Excel file

[zahirabbas]

Can anyone suggest me how to read .xlsb file in java

[USP]

U added username in loop but I didn't add password in loop