Forum Discussion

testerA's avatar
testerA
Occasional Contributor
13 years ago

soapUI 4.5.1: how to read from excel file for load test

I am a new to SOAPUI testing, am using soapUI 4.5.1 for a load test. This is a data input I need to read from excel file and run a load test. When hard coded with one value, it works, how do I r...
testerA's avatar
testerA
Occasional Contributor
13 years ago
I am able to get value in the "Value"

e.g Value = 202;704;8235

How do I split this "Value" to
three property values

I need
areacode = 202
prefix = 704
linenumber = 8235

I tried this code

propTestStep.setPropertyValue("Value", tempValue)
def (areacode, prefix,linenumber) = "Value".split(";")



My data text file
202;704;8235
979;557;6114
310;533;7810
940;594;7006
903;327;5261

Http log shows

Thu Mar 07 18:58:24 EST 2013:DEBUG:>> " <cus:CallerID AreaCode="Value" LineNumber="Value" Prefix="Value"/>[\n]"