Forum Discussion

Jason1's avatar
Jason1
New Contributor
6 years ago

How 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 w...
HimanshuTayal's avatar
HimanshuTayal
Community Hero

Hi Jason1,

 

In my way using of POI or JXL will be a good approach, as you can moulde your groovy code according to your need.

If you are facing any issue with groovy code please attach a screenshot of error, may be we can help.

 

 

Jason1's avatar
Jason1
New Contributor
6 years ago

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?

Thanks

  • aaronpliu's avatar
    aaronpliu
    Frequent Contributor
    6 years ago

    firstly, to ensure you import required package, as follows:

    import org.apache.poi.ss.usermodel.Cell
import org.apache.poi.ss.usermodel.Row
import org.apache.poi.xssf.usermodel.XSSFSheet
import org.apache.poi.xssf.usermodel.XSSFWorkbook

     secondly, you'd better to use try...catch for any I/O operation, as like

     try {
            FileOutputStream outputStream = new FileOutputStream(FILE_NAME)
            workbook.write(outputStream)
            workbook.close()
        } catch (FileNotFoundException e) {
            e.printStackTrace()
        } catch (IOException e) {
            e.printStackTrace()
        }
    • Olga_T's avatar
      Olga_T
      SmartBear Alumni (Retired)
      6 years ago

      Hi all,

       

      aaronpliu, HimanshuTayal, thank you for your time looking into this!

       

      Jason1, did you manage to accomplish your task? If your question was answered, don't hesitate to mark the reply that helped you as a solution to this topic. You can do this by clicking the Accept as Solution button below the appropriate reply. 

      We are looking forward to hearing from you.