Using a excel spreadsheet

[Stevan]

is there a way I can have values from a excel spreadsheet, and have them entered automatically when using test complete based on what is in the excel spreadsheet?

[Marsha_R]

Yes, there is.  Here's how it works:

https://support.smartbear.com/testcomplete/docs/testing-with/working-with-external-data-sources/exce...

[AlexKaras]

Also, consider Excel object provided by TestComplete.

[Stevan]

Well, I got it to somewhat work, but it only puts in the last word from excel. 

Excel reads -  THIS IS A EXCEL TEST. When I run the test, all it puts in the field from excel it the word TEST.

Why is it not reading the whole text from excel?

[Marsha_R]

Let's see a screenshot of the code you're using.  Hard to tell what's going on otherwise.

[Stevan]

Here is my test 

[Marsha_R]

Right after your Excel-Read Value, do a Log.Message and use the LastOperationResult option that's in this example.  Run the test again and it will put the value to the test log so we can see it.

https://support.smartbear.com/testcomplete/docs/keyword-testing/basic/result.html

[Stevan]

Does this look correct -  I ran it , but not sure how to read the log file. 

[Marsha_R]

The log appears when your test has finished running.  I expect to see a line in there that has your Excel value in it.

https://support.smartbear.com/testcomplete/docs/testing-with/log/detailed/index.html

[Stevan]

My test fails after reading the excel and I get the following --