Forum Discussion

Ahaan's avatar
Ahaan
New Contributor
8 years ago

Need help with converting a String Property to Integer while Sending a soap request

Hi,   I am new to Soap UI and am trying the following scenario -   Scenario: Read an excel file for the data to be used in the Soap requests and also which Test steps are to be executed  and then...
  • Ahaan's avatar
    Ahaan
    8 years ago

    My mistake. It's #TestSuite# , I was trying with #testSuite#. Works properly now.

nmrao's avatar
nmrao
Champion Level 3
Would you mind posting the script? Otherwise, need write code by looking at your image of the post to give a try from other people end.

Thank you for understanding.
Ahaan's avatar
Ahaan
New Contributor
8 years ago

Here's the Groovy code:

 

import java.io.*
import jxl.*

def f=new File("C:\\Users\\Ahaan\\Desktop\\SOAPXLS\\Calculator.xls")
def wb=Workbook.getWorkbook(f)
def ws=wb.getSheet("DataSheet")
def rowcount=ws.getRows() 
log.info rowcount
for(def count=1;count<rowcount;count++)
{
Cell execute=ws.getCell(2,count)
if(execute.getContents().equalsIgnoreCase("Y"))
{
Cell data1=ws.getCell(3,count)
testRunner.testCase.testSuite.setPropertyValue("testData1",data1.getContents())
Cell data2=ws.getCell(4,count)
testRunner.testCase.testSuite.setPropertyValue("testData2",data2.getContents())
Cell TestStep=ws.getCell(1,count)
testRunner.runTestStepByName(TestStep.getContents())

}

}

 Thanks.