1.How to find in which row or column,string "Hyderabad"
exist in excel sheet?
2.How to find how many times character "a" repeated in a
given string "Koteswararao"
Answer Posted / lakshmi
Set ObjExcel=CreateObject("Excel.Application")
ObjExcel.Workbooks.Open("C:\Find.xls")
Set Obj=ObjExcel.Sheets.Item(1)
rowcount=Obj.usedrange.rows.count
colcount=Obj.usedrange.columns.count
For i=1 to rowcount
For j=1 to colcount
Aval=Obj.Cells(i,j)
If StrComp(Aval,"HYDERABAD")=0 then
MsgBox "Location Is : ("&i&","&j&")"
Exit For
Exit For
End If
Next
Next
Please let me know if you have simplest answer than this.
Thx
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
hi i want license key for qtp 9.2 pls its adjust product name : quick test professional locking code :8 - 54A6A license type : seat license maintenance number : 88888888-8888 pls send license key to my email id borusu.ramkumar@gmail.com
Can we create a qtp test from qc?
How to do the scripting. Are there any inbuilt functions in QTP? What is the difference between them? How to handle script issues?
Explain the qtp test phases.
What is environment variable in qtp and why to use it?
Consider one application is open, clicking one menu will open another application in another browser. QTP does not catch the URL of the second browser(second application). can we capture it ?
what type of framework u r using in ur organization
What are the properties you would use for identifying a browser and page when using descriptive programming?
What is the extension of the recovery scenario file in qtp?
Describe synchronization point.
Can we run test with out adding object in object repository? How it is possible?
How to do the scripting. Is there any inbuilt functions in qtp as in qtp-s. What's the difference between them? How to handle script issues?
Explain how you can find the absolute value of the number in qtp?
If you giving priority as p0, as a developer if I give priority as p2, What happens In user defined function ?
How to use setroproperty?