how to get no.of non empty rows in a excel sheet through
vb-script

Answers were Sorted based on User's Feedback



how to get no.of non empty rows in a excel sheet through vb-script..

Answer / xxxx

rcount=usedrange.rows.count

Is This Answer Correct ?    6 Yes 0 No

how to get no.of non empty rows in a excel sheet through vb-script..

Answer / 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

More QTP Interview Questions

what is framework? which frame work u follow for writting script?

5 Answers   IBM,


Is there any relation between Keyword Driven Framework and Recording modes provided in QTP( whether Recording modes are applied on keyword driven framework or not?)

0 Answers   IBM,


Write a script to print below pattern 5 4 3 2 1 5 4 3 2 5 4 3 5 4 5

2 Answers  


Hi friend I have query regarding QTP datatable. I want to insert data in datatable during runtime. suppose i wrote datatble.value(1) = "Test data" so when i run the script it says column(1) doesn't exist. Then i write something in column A1 manualy and run the script again. Now it works fine. Pls clarify how i can put value in blank cell of datatable.

10 Answers   Apex,


How does you pass optional arguments in qtp?

0 Answers  






Any body have QTP 9.5 licence key. please provide me at madhukar_dec30@yahoo.co.in

0 Answers  


Hi, Where should I get all the test's results If I ran the scripts in Batch run. At the result window I found only last test result. Could any one help me on this?

3 Answers   Livetek,


Inserting a Call to Action is not Importing all columns in Datatable of globalsheet. Why?

3 Answers  


What are private functions in QTP? How they can be called from the function library?

0 Answers   HCL,


Is it possible to change the extension of Shared object repository?

2 Answers  


how can we preform retesting(DATA driven test) using function please gine the code for loginpage

0 Answers   W3 Solutions,


What is the logic for reading(exporting)the data from flat files to QTP?Can anyone explain me with an example? I appreciate it!!! Thanks!!! Prasanna

1 Answers  


Categories