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. 

EkremMese1's avatar
EkremMese1
Contributor

I wanted to see the Excel values in the console before I pass it to textbox3 in the line 15 

For that purpose I wrote line 12 and line 13

Now my code fails at line 12 

So that means its about parsing the data in excel. 

Marsha_R's avatar
Marsha_R
Moderator
6 months ago

Let's see a screenshot of your Excel sheet. We can't see the cell formatting but we might be able to spot something else. 

  • EkremMese1's avatar
    EkremMese1
    Contributor
    6 months ago


    I don't believe it is because of cell formatting. 
    Because if that was the case, all the functions would give the same error. But as I mentioned above when I use the same file for some other functions it works but in this particular one it's not working.