Forum Discussion
Hi richie ,
Thanks for your reply,
PFB groovy script
import com.eviware.soapui.support.XmlHolder
import com.eviware.soapui.support.GroovyUtils;
import jxl.*
import jxl.write.*
Workbook workbook1 = Workbook.getWorkbook(new File("E:\\Book11.xls"))
Sheet sheet1 = workbook1.getSheet(0)
size= sheet1.getRows().toInteger()
WritableWorkbook workbook = Workbook.createWorkbook(new File("E:\\output.xls"))
WritableSheet sheet = workbook.createSheet("Sheet1", 0)
for (def i=0;i<size;i++){
def cin_id = sheet1.getCell(0,i)
def cin_value = cin_id.getContents()
log.info(cin_value)
testRunner.testCase.testSuite.project.setPropertyValue("id",cin_value.toInteger())
def tCase = testRunner.testCase.testSuite.testCases["CapitalTestCase"]
def tStep = tCase.testSteps["Code11"]
tStep.run(testRunner, context)
}
- richie5 years agoCommunity HeroHey Yasar,
Have you tried moving the .toInteger() method outside the setProperty method?
E.g.
testRunner.testCase.testSuite.project.setPropertyValue("id",cin_value).toInteger()
If that doesnt work and it should i believe if thats the only issue (although my groovy skills are poor), you could set to int type separately immediately after the setProperty command.
Try above and report back and i'll suggest the other option i know if above doesnt work, although i think this is correct relative to the error response you got.
Ta
Rich- Yasar5 years agoNew Contributor
Hi richie ,
I've tried moving toInteger() outside setProperty method, like below
testRunner.testCase.testSuite.project.setPropertyValue("country_name",cin_value).toInteger()and getting below error
java.lang.NullPointerException: cannot invoke method toInteger() on null object error at line: 19
- Yasar5 years agoNew Contributor
Hi richie ,
I've found the mistake, i've created a test suite level property but I used setProperty method on project level property in my groovy script, below works fine
code change:
testRunner.testCase.testSuite.setPropertyValue("country_name",cin_value)
thanks a lot for ur precious time
Related Content
- 2 years ago