Script [from Keyword Test] has issue with XLS Data; engine could not find the object 'Sheet1$

Question

I have a few Data-Driven&nbsp;Keyword Tests that I converted to Script and am having issues executing them. The error message [below] concerns the XLS Data source. I have confirmed that my Keyword Test&nbsp;still runs fine.&nbsp;&nbsp;The script line that fails is the first reference to the Data storage object variable.Call Project.Variables.LtcTest17.Reset&nbsp;&nbsp;Is there a different syntax needed when using Data-Driven XLS input in a Script?&nbsp;&nbsp;

marsha_r · Accepted Answer

::looks around and fails to find Bag O' Wisdom::

Try double clicking on your project name in the Project Explorer and see if you get the tabs back on the bottom. Here's what mine looks like, and the DDT variables that were translated are all in the Temporary Variables list.

marsha_r · Answer

The ones I have converted were fine syntax-wise, but my Excel file turned out to be in a different place than TestComplete expected. &nbsp;Double-check the path definition in the Project variable and go look at the path it's using and make sure your file is actually there. &nbsp;

billa603 · Answer

Hi Marsha,I am new to TestComplete, so please bear with me.&nbsp;The only way I know to access the Project variables is via the tab at the bottom of the&nbsp;Workspace pane.&nbsp;Note: There are 2 other Tabs here as well, Test Steps and Parameters. When I view the Variables Tab, I only have one variable declared and that is my XLS file. The value is correct and does not look to have been changed. This Tab only appears when I select the Keyword Test in my Project Explorer.&nbsp;When I select the Script Tab in the Workspace, the Test Steps, Variables and Parameters tabs go away. Where should I look for variables associated with the Script?&nbsp;I am wondering if perhaps I set up my XLS data variable at the Keyword level instead of project level.&nbsp;I await your great wisdom.:-)&nbsp;Bill&nbsp;

billa603 · Answer

You are a genius !!!Now I see the complete list.I need to investigate further, but think I am headed in the right direction.&nbsp;thanks

billa603 · Answer

One thing that I am seeing is that it looks like each time I execute Convert to Script, a new temporary variable gets created.&nbsp;For example, the XLS data file variable in my original Keyword test is named Ltctest1, type DB Table. I just ran Convert to Script and now a new temporary variable named Ltctest18 is in the list. The actual default value is the same as the original. This new variable is referenced inthe generated script code, however, not i all places. Some of my Log Message calls still reference Ltctest1.&nbsp;Script:&nbsp; Call Project.Variables.LtcTest18.Reset&nbsp; While Not Project.Variables.LtcTest18.IsEOF&nbsp; yada yada yada......&nbsp;I am guessing that I might be doing something wrong&nbsp;for this to be happening. Maybe my project is not right or my variable is&nbsp;declared in the wrong place or I have an incorrect&nbsp;setting.&nbsp;Should I make my DB Table variable a persistent variable?&nbsp;I appreciate&nbsp;any further&nbsp;guidance.&nbsp;&nbsp;&nbsp;

marsha_r · Answer

Mine all converted to temporary variables and I think that's fine. &nbsp;You'll just need to update the log messages to the correct values.&nbsp;For your error message, do you see&nbsp;LtcTest17&nbsp; in your temp variables list? &nbsp;If you click on that line, you can get the ellipses button to come up in the default value box and that will open up the wizard. &nbsp;Step through there and double-check all the values to make sure they still match your file.&nbsp;&nbsp;

Forum Discussion

Script [from Keyword Test] has issue with XLS Data; engine could not find the object 'Sheet1$

6 Replies

Related Content

Keyword test not working as Script test

If Object exists - Script and Keyword

How to propagate script changes back to the keyword test?

Access a Keyword Test's description via script

Running a Data Driven Test using multiple Keywords and scripts

Recent Discussions

Searching for mapped object took too much time msg

Multiple execution of a test plan with different values from an Excel table

mht files are by default opening in Edge browser and its blank

Azure Devops Integration supports Testcomplete Base Fixed Dektop Module License

Devops integration support