Forum Discussion
Ahaan
New Contributor
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.
Related Content
Recent Discussions
- 11 days ago