Stevan
4 years agoContributor
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?
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?
Here is my test
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
Does this look correct - I ran it , but not sure how to read the log file.
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