Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
What are the significant changes/upgrades in various selenium versions?
How to assert title of the web page?
How to delete cookies in selenium?
How to get an attribute value using selenium webdriver?
How could ajax controls be handled in webdriver?
Explain what can cause a selenium ide test to fail?
Tell me how you can find broken images in a page using selenium web driver?
What is selenium rc?
What is the alternate way to click on the login button?
Explain the fundamental difference between xpath and css selector.
Mention what are the advantages of using git hub for selenium?
Explain what is datadriven framework and keyword driven?
Explain dataproviders in testng using an example. Can I call a single data provider method for multiple functions and classes?
How to create and run testng.xml?
Which are the languages supported by selenium rc?
