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
- 14253 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 anyone please tell me which is the best institute for learning QTP and Automation Testing tools in hyderabad with realtime examples and scenarios...I heard about many institutes in Ammerpet hyderabad i.e Suresh Reddy's Smart Solutions, Ashwin Palaparthi's Tech Teach,SUNNYSOFT, SITE institute, I-VINTAGE, siritechnologies and sriven institute..pls suggest me which to choose for learning QTP....Which institute has fasttrack option?
How u call functions in QTP Function to calculate the length of characters in a word -
How to modify the text checkpoint?
what is the test object?
How to catch the TOol Tip Dyanamically changing values using the qtp script by Descriptive Programming Scenario: ======== 1. when i press the submit button 2. The Tool tip first shows the value "Validating...." 3. Next the value is changed in tooltip "Logging....." ------ And the class is webElement SO , how can i catch both values During Run time using Dp
BEst INstitute for QTP & SELENIUM
QTP9.1 does not support to text checkpoint in Windows application? Is this correct? If this is correct, what is alternative for Text checkpoint?
How can you pass value one action to another action?
What is an optional step in qtp ?
What is the qtp testing process?
Pls explain me the difference between ........ Description.Create and CreateObject
Your roles and responsibilities and daily tasks? (As automation tester)
WinRunner 
