Service Virtualization

  • Private Community

  • 1.  How we can store responses in Excel file rows one after another?

    Posted Oct 03, 2017 09:17 AM

    I can see to read values rom Excel as data set? but how we can save responses for each iteration of test casein excel or csv file.

     

    I can see option Save property Value to file using append mode but now sure how it is going to help with creating Exel file with Append mode. If I am creating Excel file , will it store each response in separate rows with Append Mode on.

     

    Please advise.

     

    Cheers..

    Shivam Garg



  • 2.  Re: How we can store responses in Excel file rows one after another?

    Posted Oct 03, 2017 09:21 AM

    Hi Shivam, 

     

    Which product are you working in?

     

    Best regards,

    Taylor



  • 3.  Re: How we can store responses in Excel file rows one after another?

    Posted Oct 03, 2017 09:23 AM

    Hello Taylor,

     

    10.1 version , I am using.

     

    Cheers.



  • 4.  Re: How we can store responses in Excel file rows one after another?
    Best Answer

    Broadcom Employee
    Posted Oct 03, 2017 10:28 AM

    Hi Shivam,

     

    You can't store directly to an *.xlsx file with out-of-the-box DevTest unless you use a custom scriptable step or custom step using the Apache POI library.

     

    However, you can easily write to a *.csv file which is easily opened by Excel.

     

    --Mike