Forum Discussion
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.
Thank you for understanding.
Ahaan
8 years agoNew 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
- 16 hours ago
- 16 hours ago
- 20 hours ago
- 2 days ago