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
What does it mean when a check point is in red color? What do you do?
How is a Step generator used in UFT?
On what document base Descriptive programming is written if build is not yet ready ?
What are the different properties of an web object
Step 3&4 are repeated until an the object in recognised uniquely.
What should we say if interviewer asks "What is ur project architecture?".......Can any one help me with clear information.?????????
Hi, Can anyone please tell me how to connect the QC with QTP using QTP script? Thanks in advance
Is virtual object supported in low level recording mode?
How to attach a file to TD?
How do I lauch my test website using code from qtp in different environmet, uat and PPTE?
How to execute a winrunner script in quicktest professional?
What is the extension of qtp local repository?
When should I use smart identification?
How do you perform Regreession Testing?
How will you test a keyboard?