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

It is very difficult to test in manual for that we go to DATA DRIVEN TEST.

3 Answers  


what area in a web application cannot be automated.

1 Answers  


what is the use of Browser.sync()

2 Answers   NIIT,


Can any one tell me.......How the test engg's start testing in the compy environment.....real time tester PLSSSS help me i need in depth information regarding this...

0 Answers  


Write a function which returns the addition of two numbers. give the value of the numbers outside the function.

3 Answers   SAP Labs,






How to use descriptive programming?

0 Answers  


What is the difference between Action and Function.? when both has the same functionaltiy, when do we choose Action and when do we choose Function..??

3 Answers   DST Global Solutions,


Can we use Virtual Objects in Discriptive Programming?

5 Answers   Keane India Ltd,


with out object repository i need to launch IE and then navigate to a login page and then operate the objects within the page. How will be the script?

3 Answers   Ordain Solutions,


if my application shows 100 records and in my database having 200 records how i can validate using QTP tool?plz exp. in detail?

2 Answers   Wipro,


from what stage you will start automation in your project

5 Answers   TCS,


Which scripting language used by quicktest professional (qtp)?

0 Answers  


Categories