Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to check whether data exists in excel..
#1
Solved: 8 Years, 2 Months, 2 Weeks ago
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....
Reply
#2
Solved: 8 Years, 2 Months, 2 Weeks ago
try with using .usedRange and find out the number of rows.
Thanks,
SUpputuri
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Want to read the data from excel and set read value in the JavaTable rajeevk7 0 2,355 07-10-2017, 04:20 PM
Last Post: rajeevk7
  dtLocalSheet empty even though excel file contains data cantorre 2 2,451 05-10-2017, 12:47 PM
Last Post: vidhi
  Reading data from excel sheet serenediva 1 9,695 03-03-2017, 10:07 AM
Last Post: vinod123
  Report Viewer showing hundreds of WebElement.Exists? themoon 1 2,354 03-09-2016, 02:43 PM
Last Post: vinod123
  Importing data from Excel into Data table of QTP Chitti 1 4,945 11-01-2013, 05:54 PM
Last Post: Parke

Forum Jump:


Users browsing this thread: 1 Guest(s)