Service Virtualization

  • Private Community

  • 1.  Writing Response to Excel File - LOG Utility

    Posted May 18, 2016 06:05 AM

    Hi Folks,

     

    I am building one utility that will take request XML from Excel file through data set and will hit the service deployed on VSE.

    I want the response to be written in Same excel file in cell next to request XML.

    How can we write to Excel file in LISA.

    I am using LISA 6.0.

    TIA

     

    Regards

    Rahul V



  • 2.  Re: Writing Response to Excel File - LOG Utility
    Best Answer

    Posted May 20, 2016 12:41 AM

    I don't have any ready samples to show you but you can do this with Apache POI.  You can write this code in a Java Script step within your test case.  You may be able to find other examples on this forum on through a google search.

     

    HSSF and XSSF Examples



  • 3.  Re: Writing Response to Excel File - LOG Utility

    Posted May 20, 2016 03:52 AM

    Thanks a ton Josh.

     

    Went through Apache POI on google.

    Looks like some jar files need to be imported in LISA for Apache POI and a bit of code to workout on workbook(Excel) will help.

     

     

    Regards

    Rahul V



  • 4.  Re: Writing Response to Excel File - LOG Utility

    Posted May 20, 2016 09:06 AM

    No problem.  And to add the product does ship with the POI classes so you should be able to begin writing scripts immediately without adding any additional jars.