Random value using Keyword test
I've got an Excel worksheet with 500 customer IDs under one column. I'd like for TestComplete to randomly choose one of the IDs to use when the customer logs in. How is that accomplished using keyword...
Forum Discussion
AlexeyKolosov
Staff
StaffHi Robert,
You can use one of the three approaches described in the Working With Microsoft Excel Files help topic to read data from Excel files. As for generating random values, you'll need to use a short script for that and call the script from your keyword test. For example, if your project's scripting language is VBScript (default), the script code will look like this:
The function can be called from your keyword test via the Run Script Routine operation.
You can use one of the three approaches described in the Working With Microsoft Excel Files help topic to read data from Excel files. As for generating random values, you'll need to use a short script for that and call the script from your keyword test. For example, if your project's scripting language is VBScript (default), the script code will look like this:
Function getRandomNumber
' Generate random number from 0 to 500
getRandomNumber = Round(rnd() * 500)
End Function
The function can be called from your keyword test via the Run Script Routine operation.