Micro Focus QTP (UFT) Forums
How to check whether data exists in excel.. - Printable Version

+- Micro Focus QTP (UFT) Forums (https://www.learnqtp.com/forums)
+-- Forum: Micro Focus UFT (earlier known as QTP) (https://www.learnqtp.com/forums/Forum-Micro-Focus-UFT-earlier-known-as-QTP)
+--- Forum: UFT / QTP Beginners (https://www.learnqtp.com/forums/Forum-UFT-QTP-Beginners)
+--- Thread: How to check whether data exists in excel.. (/Thread-How-to-check-whether-data-exists-in-excel)



How to check whether data exists in excel.. - venkatesh9032 - 03-05-2014

I have a excel file..



it contains data from 20 th row...

the excel file was fully jumbled...

i am writing script to validate excel..

but how can i check whether the excel file is having data or not...
if excel file is having data i need to report pass....


RE: How to check whether data exists in excel.. - supputuri - 03-06-2014

try with using .usedRange and find out the number of rows.