How to check whether data exists in excel..

[venkatesh9032]

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....

[supputuri]

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