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


Please Help Members By Posting Answers For Below Questions

What is the process of synchronizing qtp and aut?

568


Do you know how to connect database? Can you tell me the procedures?

551


what is command for executing files?

1514


How to read a text file from QC using QTP. I would like to do something like this. But instead read a file from QC and NOT from my local drive. Set fso = CreateObject("Scripting.FileSystemObject") Set InputFile = fso.OpenTextFile("C:\test.txt", ForReading) Thanks

2753


1.Write a CRITICAL test cases for calculator ? 2.What is the difference b/w FRS and SRS documents ? 3.What is Component ? 4.What is object ? 5.what is the difference b/w static and dynamic descriptive programming ?

1585






how can i pass a "automation script" as a parameter in a function give me need full suggestion thank inadvance

1426


What is regular expression?

579


If I give some thousand tests to execute in two days what do you do?

583


What are the differences between quicktest professional (qtp) and winrunner?

572


Explain the types of object repository?

553


How to upload excel files into Quality Center using QTP Script and how to delete excel files from Quality?

614


Hello everyone! I am just writing a small test for a windows application. I have a problem with a text output value. The value i am trying to catch is presented in a scrollable textbox. When the text is too long, only a portion of it gets captured. Do you have any experience with this?

2141


How you will rate urself in QTP in the range of 0 to 5

1746


How to use transactions in qtp?

563


how to disable the pop ups through QTP using a script

1728