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
How can we get a text of a web element?
i am a 2013 BE and 2015 M.tech passed out.i have taken course in manual testing with selenium automation.i have confident that, i have required technical knowledge in manual as well as automation.now my problem is whether to go as fresher or keep 3 years of experiance.there are very few interviews to call 2013 b.tech and no calls for M.tech...!!is it make any problem, if i keep fake.please let me clear my doubt
How to read a javascript variable in selenium webdriver?
What are the programming languages supported by selenium webdiver?
How we handle pop-up web-based ?
What are different types of locators?
What are selenium tests normally named (as displayed at the top of each test when viewed from within a browser)?
Explain what is the difference between borland silk and selenium?
List the different types of drivers in webdriver.
What is the syntax of finding elements by id using css selector?
What is the wait?
How do you simulate scroll down action?
How can one get side to always record an absolute url for the open command's argument?
How can we launch different browsers in selenium webdriver?
How can we fetch title of the page in selenium?
