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 ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to handle Java tree in QTP?
How you can delete excel file in qtp?
terminal services client
What is test object model in quicktest professional (qtp)?
Explain how Selenium is different from UFT?
What is checkpoints for quicktest professional (qtp)?
What are the methods used in UFT to handle exceptions or run-time errors?
What are the trigger events in qtp?
What are the automation metrice in your project?
In qtp is it possible to check broken links of a page?
what type of values given to objects. EX::Set oBrowser=Description.Create oBrowser(“micclass”).Value=”Browser”
What r the different filters in defect in quality center
What environment does qtp run in?
What is an optional step in qtp ?
How many types of run modes are there in qtp?