Forum Discussion

nastester's avatar
nastester
Regular Contributor
9 months 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
  • rraghvani's avatar
    rraghvani
    9 months ago

    Replace the square brackets with round brackets in your code, and it will work.

Marsha_R's avatar
Marsha_R
Champion Level 3

"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
9 months ago

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
    Champion Level 3
    9 months ago
    Try putting the exact path in that line just to see if it's actually accessible.