How can I read test data from excels?



How can I read test data from excels?..

Answer / Ishaan Pandey

Test data from Excel files can be read in Selenium using libraries like Apache POI or JXL (Javascript API for Excel).nFor example, with Apache POI:
1. Add the poi and poi-ooxml dependencies to your project.
2. Read the excel file using WorkbookFactory and XSSFWorkbook classes.
3. Access the data from the sheet and cells as needed.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Selenium Interview Questions

What / supported operating system platforms Selenium?

1 Answers  


How to retrieve css properties of an element?

1 Answers  


What is pom (page object model)?

1 Answers  


What are startpoints and breakpoints in selenium?

1 Answers  


What is an XPath?

1 Answers  


From selenium ide how you can execute a single line?

1 Answers  


What is the difference between driver.getwindowhandle() and driver.getwindowhandles() in selenium?

1 Answers  


What is the difference between “/” and “XPath //”?

1 Answers  


How do you simulate scroll down action?

1 Answers  


How you can capture server side log selenium server?

1 Answers  


Tell me what you know about selenium?

1 Answers  


How to execute javascript in selenium?

1 Answers  


Categories