Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.


Count rows in an unique column in QTP's global datatable

Count rows in an unique column in QTP's global datatable

Quick Test Pro (QTP) 9.0
Windows XP sp 2


When importing an excel file that has several columns each
with different number of rows into QTP's Global datatable,
how can you count the number of rows in a particular column?


RE: Count rows in an unique column in QTP's global datatable

Hi SBSteve

QTP works on the prerequisite that each row of the Global datatable is one iteration of the test being executed.

This means that each column will require the same number of rows, or at least handling where individual columns have no data.

AFAIK, the only way you could do this would be with an instance of the FileSystemObject, examining the excel version of the file, but that's not likely to help you in what you are trying to achieve.

Can you explain what you're trying to do and the composition of your data?  That will help direct the answer.


"Yes, I'll stop finding bugs in the software - as soon as you stop writing bugs into the software."  <-- Me

For all your testing needs: forum1393: Systems & Software Testing

RE: Count rows in an unique column in QTP's global datatable

Thanks for your reply Dave, but I think I may have been on the wrong path.

Please see my new post on Nested Loops.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close