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