Forum Discussion
- Yasar4 years agoNew Contributor
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)}
- richie4 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- Yasar4 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
Related Content
- 11 months ago
Recent Discussions
- 18 days ago