how to get no.of non empty rows in a excel sheet through
vb-script
Answer Posted / hari
by writing the for loop and you have to initialize for (i=0;
i<==num(i), i++)
Next
This loop will include that the rowcount it will take first
0 and total count it wil compare to the max of rows if it
wil true it will counts the nect row count
| Is This Answer Correct ? | 2 Yes | 7 No |
Post New Answer View All Answers
could any help me please, how to work on visual foxpro application using UFT
Hi, I am using 2 excel sheet.First excel sheet works fine with the script, if it opens the 2nd excel sheet,it works fine,but after finish all the rows it is giving the following error in the following line. InValid Procedure call or argument Line (178): "Browser("name:="&result,"application version:=internet explorer 7").Page ("title:=bgt.*", "index:=0").WebList ("name:=SearchType","html id:=Select1","location:=0").Select SearchType1". I have seen a web article says that,If we use any vbscript friendly name it may gives the above error-Invalid procedure call or argument not sure,Am I using any VBScript frienlyName? in the above line? [but the same line is perfecly working for first Excel ] It is little urgent. Any Help Thanks you
What is clean sweep?
descriptive program for a yahoo mail that is in yahoo mail suppose check box mailid subject assume it is like this format all things are in webtable the question is suppose some mail ids are there in that mailids i want to select the check box wich is before a@gmail.com and after that i want to click on delete button
What is the default object synchronization timeout in qtp?
can u explain the keyword driven framework with an example clearly how to create all the files and how to attach to main test.
How the smart identification is used in real time?Please explain with an example
I have 5 save buttons in 5 tabs . The tabs are placed one after the other. My object repository have these added as 5 save buttons with name sav1, save 2, save 3 , save 4, save 5 .all are getting highlighted from OR but they are not getting clicked. After spying each button all the properties are same except First button Index 0 html id:=btnSaveTab1 outerhtml:=", Second button "html id:=btnSave "outerhtml:=", Third button "html id:=", outerhtml:=",
If you have two monitors one is of 19inch and the 2nd one is of 24inch,if you want to write same QTP script in both the two monitors is there any changes required in the script?
How you can find the absolute value of the number in qtp?
How to export quicktest professional results to an .xls file?
How will internal and external links be validated and updated? how often?
What is a checkpoint? How many check points are there in qtp?
Why do you create a text checkpoint on a Web application? What is the purpose of the Close method?
Suppose I want fail that check point? How can you do that?