Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

How can I change object description or check point values in qtp?

0 Answers  


Hi friends, In a particular test how many maximum call to new actions we can call?It reusable or normal actions what ever it is .

1 Answers   AppLabs,


Hai Guys, can anybody show me how to write automaed test cases using VB scprit(examples)...i had an interviw soon...please guyz send as quickly as possible

5 Answers  


I want to read XML file loaded in Quality center and compare the values with the values displayed in Application (web table).How can I do that

0 Answers  


How do we edit the script in QTP. Anybody can explain in detail..Thanks in advacne...

3 Answers   IBM,


You have an application version 1 with 5 combo boxes, Developers develop version 2. Here they replaced bottom 3 combo boxes with each other. While executing the Test script for version1 no errors. When we execute the Test script for version2 that QTP showing the error message "Object not identified" remember no property changed in version 2, ordinal identifier also disabled. Find what properties might change here in this scenario

6 Answers   ADP,


what is localisation testing and globalisation testing? what is the difference between them?

1 Answers   CDC Software,


1. How to capture data from images in QTP and produce them in Excel sheet ? 2. What is Terminal Emulator add-in installation and configuration procedure ? 3. Tell me how do u define action and transaction in QTP ? 4. Is QTP case sensitive ? 5. Problem with XML checkpoint ? 6. When was QTP 8.2 and Loadrunner 8.0 officially released to the market ? 7. Can we record on netscape browser does it require any special settings ? 8. How do I add new object to the object repository to any particular frame ? 9. Do we have rapid test scrpit wizard in QTP ? How to learn all the windows and objects in QTP 10. How to open Exceel sheet using QTP script ? 11. Is it necessary to learn VB script to work with QTP or we can manage with keword driven ? 12. What is descriptive programming in QTP ? 13. How to invoke the QTP from dos prompt and run a test without any interaction with human ? 14. What is the meaning of Context sensitive ? 15. How to retrive the property values from "Resource.mtr" after recording the script with "Standard checkpoints" ? 16. Where should we use accessbility checkpoints. Can u explain me with the example ? 17. How do we add object repository dynamically ? (During runtime) 18. How to record right click of a context menu and click on the selection ? 19. How to connect oracle database to QTP ? 20. How will you load few objects in Active Screen ? 21. Can I compare two DataBases using QTP ? 22. If the the two object have same class then how QTP will find the object ? 23. Can I change the runtime properties of an object ? How can I check if a parameter exists in database ? 24. What is the script for database check point, bitmapchek point, regular expression ? 25. What is QTP environmental variable ?

1 Answers  


how to create external data table?

1 Answers   TCS,


What are the Latest Feature are added In QTP 9.2?

2 Answers   Infotech,


What is a quick test professional?

0 Answers  


how to write the descriptive programming in QTP for remove the object value and substitute, with a variable then call the validation from excel

0 Answers  


Categories