Interested to Buy Any Domain ? << Click Here >> for more details...
How do you fetch the data from the excel
- 1 Answers
- 2025 Views
- I also Faced
- E-Mail Answers
Answer / govind
1.To get data fr excel sheet first we need to configure our selenium project with Apache pai jar file
2. Then we have to create execl sheet
3. Then we have to create object of Fileinpuststream class that accept path of execel sheet file.also return type Is file and we have store in one variable
4. After that we have to use create method to open excel sheet which is present in workboofactory class
Workboofactory.create(file)
5.now to navigate for specific sheet present in Excel we use getsheet method which accept string value that is name of sheet
Workbookfactory.create(file).getsheet("sheet name")
6.after that from which row you want data we have to navigate to that row by function getrow.
7. After that you have to navigate to column using function getcell
So finally depending upon type of data present in Excel we use
1.String cell value for stringdata
2. Neroc sell value data
3.boolean cell value da🙏🙏🙏🙏🙏🙏
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the different type of locators?
How to find more than one web element in the list?
What is the use of driver.get("url") and driver.navigate().to("url") command? Is there any difference between the two?
Explain what is the difference between find elements () and find element ()?
To generate pdf reports mention what java api is required?
How to change the url on a webpage using selenium web driver?
What is the purpose of creating a reference variable- ‘driver’ of type
What / supported operating system platforms Selenium?
What is the main difference between the close() and quit() methods?
How to handle a dropdown in selenium webdriver?
List some scenarios which we cannot automate using selenium webdriver?
How do you click on a menu item in a drop down menu?
WinRunner 
