Ask a Question

Using a excel spreadsheet


Using a excel spreadsheet

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?

Champion Level 3
Champion Level 3

Also, consider Excel object provided by TestComplete.


  /Alex [Community Champion]
[Community Champions] are not employed by SmartBear Software but
are just volunteers who have some experience with the tools by SmartBear Software
and a desire to help others. Posts made by [Community Champions]
may differ from the official policies of SmartBear Software and should be treated
as the own private opinion of their authors and under no circumstances as an
official answer from SmartBear Software.
The [Community Champion] signature is assigned on quarterly basis and is used with permission by SmartBear Software.

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?




Champion Level 3

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

Here is my test 




Champion Level 3

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.

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




Champion Level 3

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




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




Showing results for 
Search instead for 
Did you mean: