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
6 years ago

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.