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 many exemptions do you know in selenium webdriver?
What are the main advantages of automation testing?
Tell us what kind of keyboard operations can be performed in selenium?
How to read a javascript variable in selenium webdriver?
How to perform double click action in selenium webdriver?
How does you use mouse over actions
Name an api used for reading and writing data to excel files?
How can you mark a test case as failed by using soft assertion?
What is the reason to use the selenium grid?
Do you know any alternative test automation tools for selenium?
What are some of the advantages of selenium grid?
What is the purpose of selenium ide?
How can we type text in a textbox element using selenium?
When do you use selenium grid?
What are some expected conditions that can be used in explicit waits?
