hi...
this is the scripts...i spent a lot on this..could you help me out.
import java.io.File;
import com.eviware.soapui.support.*;
import java.util.*;
import java.util.Date;
import jxl.*;
import jxl.write.*
import java.lang.*;
def Exp_Value = context.expand( '${EXPECTED VALUE}' )
log.info (Exp_Value)
def Response_Value = context.expand( '${SUM}' )
log.info (Response_Value)
if (Exp_Value == Response_Value)
{
def getStep = testRunner.testCase.getTestStepByName( "Properties" )
getStep.setPropertyValue("Teststatus", "PASSED")
}
else
{
def getStep = testRunner.testCase.getTestStepByName( "Properties" )
getStep.setPropertyValue("Teststatus", "FAILED")
}
def test_status = context.expand( '${Teststatus}' )
log.info(test_status)
Workbook workbook1 = Workbook.getWorkbook(new File("D:\\data\\write.xls"));
WritableWorkbook objWritableExcel = Workbook.createWorkbook(new File("D:\\data\\write.xls"), workbook1)
WritableSheet objSheet = objWritableExcel.getSheet(0);
k = objSheet.getRows();
l = objSheet.getColumns();
for (tc_row in 1..k-1)
Label N1 = new Label(0,tc_row,Exp_Value)
objSheet.addCell(N1)
Label N2 = new Label(1,tc_row,Response_Value)
objSheet.addCell(N2)
Label N3 = new Label(2,tc_row,test_status)
objSheet.addCell(N3)
objWritableExcel.write()
objWritableExcel.close()
workbook1.close()
testRunner.gotoStepByName( "Groovy Script1")