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

Answer Posted / xxxx

rcount=usedrange.rows.count

Is This Answer Correct ?    6 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In qtp, how you can use xpath to identify objects?

614


what and how to answer for the question "tell me about yourself ?" for 3 years experience. can anyone say inj detail please... its urgent

1339


Does quicktest professional is unicode compatible?

525


i have an external excel datasheet where it only contains 3 rows. after qtp executed the code to import the datasheet, the datatable getrowcount method now gives me a different value, lets say 60,000+ instead of only 3. i did not have any values starting from row 4 of my excel file. why is this happening? this also results to the qtp report to load for a very long time.

1536


How you can write contexts to text file in qtp?

590






Explain process of smart Identification in QTP?

598


assume i have few url link how will i dynamically call then using descriptive programming?

1601


How to Open FireFox using descriptive programing? If my question is not clear, i will give an Example To Open Internet Explorer, We use Set IE = CreateObject(InternetExplorer.Application) IE.Navigate "www.yahoo.com In the same i need to open yahoo.com in firefox. Can any one tell me what is the server name of firefox to create an object

2528


What are the steps involved in recovery scenario wizard?

528


What is the difference between shared and local object repository?

615


How you calling actions in qtp?

630


Print the Prime numbers in below format only up to 20(Need commas also) 1,2,3,5,7,9,11,13,17,19

1184


How qtp recognizes the object?

671


what is actually contain test report? can anybody post the test report

1475


How to use reporter.report event in qtp ?

557