import java.util.*; import java.lang.*; import jxl.* import jxl.write.* createStatusFile () void createStatusFile() { def filePath = "C:\\temp\\soapui\\" def fileName = "TestSuiteResult"+new java.text.SimpleDateFormat("yyyyMMdd'T'HHmmss").format(new Date())+".xls" def fullFilePath = filePath+fileName def excelFile = new File(fullFilePath) WritableWorkbook workbook1 = Workbook.createWorkbook(new File(fullFilePath)) WritableSheet sheet1 = workbook1.createSheet("RunReport", 0) Label ProjectName = new Label(0, 0, "ProjectName"); Label TStepName= new Label(1,0,"TestStepName"); Label TStatus= new Label(2,0,"Status"); sheet1.addCell(ProjectName); sheet1.addCell(TStepName); sheet1.addCell(TStatus); sheet1.setColumnView(0, 40); sheet1.setColumnView(1, 40); sheet1.setColumnView(2, 15); Label Projectlabel = new Label(0, 1, "ProjectName"); sheet1.addCell(Projectlabel); Label testStt = new Label(1, 1, "TestStepName"); sheet1.addCell(testStt); Label Status = new Label(2, 1, "Status"); sheet1.addCell(Status); workbook1.write() workbook1.close() }