function searchdatainexcel(strpath, searchcol, searchval)
path="c:abc. xls"
set searchdata=DDT. exceldriver(strpath, "sheet1", true)
do while not searchdata. EOF
if aqconvert. vartostr(searchdata. value(searchcol)) =searchvalue then
blnflag=true
exit do
else
blnflag =false
end if
searchdata. next
loop
if blnflag =true then
log. message "record match"
else
log. message "record not match"
end if
end function
Tuesday, November 20, 2018
Test Complete - Find value is present in excel sheet or not
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment