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

[SBsteve]

Quick Test Pro (QTP) 9.0
Windows XP sp 2

Question:

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?

Thanks,
SBsteve

 

[DPlank]

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.

Cheers,
Dave

"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

 

[SBsteve]

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

Please see my new post on Nested Loops.

Thanks,
SBsteve