My application contains a drop that has all 50 states abbreviated. I want to compare the values in that drop down to an Excel file that consist of all 50 states abbreviated and listed in a single column. Am I able to create a test up until the point of selecting the dropdown element, then have the test compare the list to the values in the Excel file?
So far, I've attempted to select the step of the drop down and data bind that step to the Excel sheet. I've also attempted to data bind the find logic of that element (described in the link you provided).
My expectation is that, if I data bind my drop down to the values of an Excel sheet to verify the states, if I were to (for example) delete or rename a state within the Excel sheet, then the test would fail when trying to compare the two. Is this correct?
I am trying to do something similar to the YouTube video titled "Taking Data Driven Web Testing for A Spin with Test Studio." The only difference is that I want to iterate though a single column of state abbreviations.
Thanks for you help, Elena!