Pankajyadav
11 years agoNew Contributor
Write properties to output Excel file
import jxl.*
import jxl.write.*
file = new File("D:\\soapui-practice\\OutputResult.xls")
if(!file.exists()){
log.info "file does not exists create new worksheet headers, and first line of values";
WritableWorkbook workbook1 = Workbook.createWorkbook(file)
WritableSheet sheet1 = workbook1.createSheet("Worksheet Number 1", 0)
log.info(sheet1.isHidden())
Label label1 = new Label(0, 0, "Header1");
sheet1.addCell(label1);
Label label2 = new Label(1, 0, "Header2");
sheet1.addCell(label2);
Label valuel = new Label(0, 1, "value1R1C1");
sheet1.addCell(valuel);
Label value2 = new Label(1, 1, "value2R1C2");
sheet1.addCell(value2);
workbook1.write()
workbook1.close()
}else{
log.info "file exists open worksheet headers, and update from next rows";
WritableWorkbook book = Workbook.createWorkbook( file, Workbook.getWorkbook(file) )
sheet = book.getSheet( 0 )
newRow = sheet.rows
sheet.insertRow( newRow )
def value1 = new Label( 0, newRow, "value1R2C1")
sheet.addCell( value1 )
def value2 = new Label( 1, newRow, "value1R2C2")
sheet.addCell( value2 )
log.info newRow
book.write()
book.close()
}
import jxl.write.*
file = new File("D:\\soapui-practice\\OutputResult.xls")
if(!file.exists()){
log.info "file does not exists create new worksheet headers, and first line of values";
WritableWorkbook workbook1 = Workbook.createWorkbook(file)
WritableSheet sheet1 = workbook1.createSheet("Worksheet Number 1", 0)
log.info(sheet1.isHidden())
Label label1 = new Label(0, 0, "Header1");
sheet1.addCell(label1);
Label label2 = new Label(1, 0, "Header2");
sheet1.addCell(label2);
Label valuel = new Label(0, 1, "value1R1C1");
sheet1.addCell(valuel);
Label value2 = new Label(1, 1, "value2R1C2");
sheet1.addCell(value2);
workbook1.write()
workbook1.close()
}else{
log.info "file exists open worksheet headers, and update from next rows";
WritableWorkbook book = Workbook.createWorkbook( file, Workbook.getWorkbook(file) )
sheet = book.getSheet( 0 )
newRow = sheet.rows
sheet.insertRow( newRow )
def value1 = new Label( 0, newRow, "value1R2C1")
sheet.addCell( value1 )
def value2 = new Label( 1, newRow, "value1R2C2")
sheet.addCell( value2 )
log.info newRow
book.write()
book.close()
}