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
Explain in selenium ide how can you debug the tests?
Write the code for reading and writing to excel through selenium?
How testing is better than junit?
How you can convert any selenium ide tests from selenese to another language?
Which is the command used for displaying the values of a variable into the output console or log?
What are heightened privileges browsers?
How selenium grid works?
How you can debug the tests in selenium ide?
How to developer selenium test cases?
How can I learn to automate testing using selenium?
Mention what is intellij?
Why testers should opt for selenium and not qtp?
How to execute javascript in selenium?
List the advantages of webdriver over selenium server?
What does a right-pointing green triangle at the beginning of a command in side indicate?
