Interested to Buy Any Domain ? << Click Here >> for more details...
In an application you have a web table. You are provided
with an external Excel sheet with the same structure as that
of the web table.
How will you retrieve all data from the web table and
compare it with corresponding data available in the excel
sheet, using QTP?
How will you report the results in QTP?
- 1 Answers
- 14248 Views
- I also Faced
- E-Mail Answers
Answer / saket bharti
'Get the Web Table Row and Col count using the GetROProperty
rowcount=
Browser("").Page("").WebTable("").GetRoProperty("rows")
colcount=
Browser("").Page("").WebTable("").GetRoProperty("cols")
'Create a Excel COM object to read the data from the file.
Set excelobj=CreateObject("Excel.Application")
Set excelbooks=excelobj.Workbooks.open("C:\Data-excel.xls")
Set excelsheets=excelobj.Worksheets.item("Sheet1")
'Now loop through the excel and the wettable and check their
values
for i=0 to rowcount
for j=0 to colcount
if (
Browser("").Page("").WebTable("").GetCellData(i,j)=excelsheets.Cells(i,j))
Then
Reporter.ReportEvent micPass ,"Validation","Cell values & i
& j are same"
Else
Reporter.ReportEvent micFail ,"Validation","Cell values & i
& j do not match"
End If
Next
Next
| Is This Answer Correct ? | 8 Yes | 1 No |
can i change the runtime properties of an object ? How can i check if a parameter exists in database ?
How do you change Logical Name of the object in test script?
write script for , launching fr window,login and create 5 elements array and store 5 order numbers inthat array? and open order by using order no.s in array and find out maximum tickets booked by which order?
How many tabs are available to view your test in a test pane and what are they?
Tell me about userdefined functions ?
How would you directly trigger javascript in a test?
how can I read text in browser and export the same into text file?
how can we call an external library file in QTP apart from using the Executefile statement..?? is there any other way we can call the external library file in QTP..??
2 Answers DST Global Solutions,
Can anyone share/send me QTP 8.2 Crack as I had it before but now it's virus affected. Pls send me on Sawale.vijay@gmail.com Thanks, ~Vijay
what is the hierarchy to use properties in descriptive programming
setroproperty and getroproperty difference
How to use the object spy in quicktest professional 8.0 version?
WinRunner 
