Forum Discussion

baoshenyi's avatar
baoshenyi
11 years ago

Compare field value with column data in excel

Hello,



Could someone tell me how to do it?



1. I used search criteria from excel to retrieve data from DB (data driven loop).

2. Could the field values can be exported to one excel sheet?

3. When I use same search criteria to do test, I would like compare field values with excel column value. How to do it?



Thanks lots!



Shenyi

1 Reply

  • TanyaYatskovska's avatar
    TanyaYatskovska
    Icon for Alumni rankAlumni
    11 years ago
    Hi Shenyi,

     


    You will need to create your own comparison function. To get the needed data from Excel, I suggest that you use its COM object. The "Working With Excel Files via COM" article contains a sample of how to get the value of the specified cell in Excel.