//import org.apache.poi.ss.usermodel.*; //import org.apache.poi.hssf.usermodel.*; import org.apache.poi.xssf.usermodel.*; import org.apache.poi.ss.util.*; import org.apache.poi.ss.usermodel.*; import org.apache.poi.ooxml.*; import org.apache.poi.*; import java.io.*; def path = context.expand( '${#TestSuite#path}' ) path = path + "output3.xlsx"; //def f = new FileInputStream(path); File f = new File(path) //NPOIFSFileSystem f = new NPOIFSFileSystem(new File(path)); //OPCPackage f = OPCPackage.open(new File(path)); XSSFWorkbook workbook = XSSFWorkbookFactory.createWorkbook(f,false); XSSFSheet sheet = workbook.getSheetAt(0); //def groovyUtils = new com.eviware.soapui.support.GroovyUtils(context) //def myTestCase = context.testCase //Row row = sheet.createRow(1); //Cell cell = row.createCell(0); //cell.setCellValue((String) "Setting Value"); sheet.createRow(1).createCell(0).setCellValue("TODO - Populate with data"); workbook.write(f) f.close(); //f.withOutputStream { os -> workbook.write(os) }