Regarding , Reading data from Apache POI in webdriver.

I am using the same code as written on this site, But while reading data from excel , It is coming as BLANK data, Its not reading data, and also not showing any error/warning message.
http://www.toolsqa.com/selenium-webdriver/data-driven-testing-excel-poi/

Add Comment
1 Answer(s)

Hi Raghav,

I am not understanding the reason not to run that code in your system if you follow the same then that should work.
If your requirement is to read data from excel following set of code will also work :

public void readXcelData()
{
FileInputStream fs = new FileInputStream(“—complete path of your excel file——“);

Workbook wb = WorkbookFactory.create(fs);
Sheet s = wb.getSheet(“Records”);
Row r = s.getRow(1);
Cell c1 = r.getCell(0);
String User = c1.getStringCellValue();
System.out.println(User);
}

Check this & please let me know if you are finding any difficulty.

raviiichauhan85 Train Answered on May 17, 2015.
Add Comment

Your Answer

By posting your answer, you agree to the privacy policy and terms of service.