Forum Discussion

EkremMese1's avatar
EkremMese1
Contributor
6 months ago

Item cannot be found in the collection corresponding to the requested name or ordinal

I created a test with scripting. Everything was working fine.  Then I decided to use a Data Driven Testing approach with an excel file.  My code started to give me the error in the caption.  ...
  • EkremMese1's avatar
    EkremMese1
    6 months ago

    Hello again, 

    I just find out that the issue is cause by not closing the driver in the methods that I called in my code. 

    DDT.CloseDriver(DDT.CurrentDriver.Name);

    This line solved issue for me. 

rraghvani's avatar
rraghvani
Champion Level 3
6 months ago

So the example is not working?

I suggest you try something very simple to output a value, e.g.

function search_with_loop() {
    DDT.ExcelDriver("C:\\Temp\\Book2.xlsx", "Sheet1");
    DDT.CurrentDriver.DriveMethod("SearchPerson.search_for_existing_record");
}

function search_for_existing_record() {
    Log.Message(DDT.CurrentDriver.Value("Person ID"));
}

The message "...requested name or ordinal" usually indicates that the column name is not correct or not formatted correctly. You have the following, the latter, does not have an underscore.

DDT.CurrentDriver.Value("Last_Name")
DDT.CurrentDriver.Value("Person ID")