Service Virtualization

Expand all | Collapse all

In my DevTest testcase, need to write some results in an existing excel sheet.

  • 1.  In my DevTest testcase, need to write some results in an existing excel sheet.

    Posted Dec 06, 2016 04:40 AM

    Hi,

     

    In my devtest testcase, we need to read some data from a excel and at the end I need to update the row with a result in the same excel. Please suggest me how to achieve this requirement.

     

    Thanks in advance.

     

    Regards,

    Mohan



  • 2.  Re: In my DevTest testcase, need to write some results in an existing excel sheet.
    Best Answer

    Posted Dec 09, 2016 11:57 AM

    Hi Mohan,

     

    You can do this in a JSR-223 script step using Apache POI.  See this most for more information:

     

    Writing Response to Excel File - LOG Utility 

     

    Josh



  • 3.  Re: In my DevTest testcase, need to write some results in an existing excel sheet.

    Broadcom Employee
    Posted Dec 11, 2016 10:06 PM

    This script is really good to write data to Excel. Thanks Josh.