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

I really hate this new forum - I had earlier saw a screenshot of your spreadsheet (I think it was yours!), which I can't seem to find now!

From what I remember from the screenshot, columns C, D and E on row 3 had a few empty values. This might cause issues with DDT.ExcelDriver, or you might need to deal with empty value or error that's returned by DDT.CurrentDriver.Value() method.

I suggest you try the example that I have provided, but include all column to output the values, e.g.

var a = DDT.CurrentDriver.Value("Column A");
Log.Message(a);
var b = DDT.CurrentDriver.Value("Column B");
Log.Message(b);
var c = DDT.CurrentDriver.Value("Column C");
Log.Message(c);
DDT.CurrentDriver.Value("and so on");
...

This will given an indication as to what row and column is causing the issue.

With DDT, you need to ensure that the headers are correctly formatted, and the data is correctly formatted too. 

Here's an example where column F does not exist, error message is shown.

 

  • EkremMese1's avatar
    EkremMese1
    Contributor
    6 months ago

    Here is my Excel Sheet. 



    And I only use PersonID and LastName columns. 
    Same spread sheet works with some other function but not with my main function.