Jason1
New Contributor
Joined 7 years ago
User Profile
User Widgets
Contributions
Re: How to write test result to excel file
This is the code I used in SoapUI: def filePath = "C:/Work/Data/Sasktel/Commercail Wireless/1. Internal Flags/OR/OR-ICT00345.xlsx" FileInputStream inputStream = new FileInputStream(new File(filePath)); XSSFWorkbook workbook = new XSSFWorkbook(inputStream); XSSFSheet sheet = workbook.getSheetAt(0); rowNumInt = rowNumInt + 1 Row row = sheet.createRow(rowNumInt); Cell cell = row.createCell(25); cell.setCellValue(result); inputStream.close(); FileOutputStream outputStream = new FileOutputStream(filePath); workbook.write(outputStream); workbook.close(); outputStream.close(); This is the exception I get: ERROR:java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList java.lang.NoClassDefFoundError: org/openxmlformats/schemas/spreadsheetml/x2006/main/CTExtensionList Do you have a solution to fix this? Thanks1.8KViews0likes3CommentsHow to write test result to excel file
I need to write the test result (Pass / Fail) to my test data file. In my test data file, every 4 rows is one request, so I need to write one test result every 4 rows. That means I need to know which row to wirte the test result. There are 2 ways to do this as I know so far: 1. use POI to write the excel file, but I get error CTExtensionList. I don't find a way to fix it yet 2. use datasink context pointer. I don't know if SoapUI has this function or not. Can we write mutiple rows to output excel file (DataSink) in one groovy script step? I mean if we can write one row of Excel file, then move to next row in one step? Thanks1.9KViews0likes5Comments