Forum Discussion

nastester's avatar
nastester
Regular Contributor
2 years ago
Solved

Keyword test not working as Script test

I have Keyword tests which compare Excel workbook values to the frontend web application using the Excel Read Value and Compare Property operations.  These Keyword tests work fine but when convertin...
Debugging
Script Tests
Test Creation
Test Run
web testing
Marsha_R's avatar
Marsha_R
Icon for Champion Level 3 rankChampion Level 3
2 years ago
Copy Link

"of undefined" in the error message is telling you that the function was unable to get your Excel sheet so it has no reference for the CellByName call.

 

Did you use the Convert To Script function to get this code or did you write it separately? If you didn't use Convert To Script function, then I suggest trying that and seeing what code TestComplete gives you.

 

If you did use that convert function, be sure and run this script in the spot in your test where it has access to all the variables that it needs. Running it stand alone may not work. 

  • nastester's avatar
    nastester
    Regular Contributor
    2 years ago
    Copy Link

    I did use convert to script.  The excel path is ProjectSuite.Path + *sheet name*.   I don't know why it would be accessible within the project via Keyword tests but not by Script tests. 

    • Marsha_R's avatar
      Marsha_R
      Icon for Champion Level 3 rankChampion Level 3
      2 years ago
      Copy Link
      Try putting the exact path in that line just to see if it's actually accessible.