Service Virtualization

  • Private Community
 View Only

  • 1.  Json to Excel filter

    Posted Apr 11, 2017 03:45 PM

    Hi,

     

    Is there any custom jar to convert JSON to Excel in DevTest?

     

    Thanks

    Jagadish



  • 2.  Re: Json to Excel filter

    Broadcom Employee
    Posted May 08, 2017 11:12 PM

    what format are you expecting in the Excel sheet ? 



  • 3.  Re: Json to Excel filter

    Posted May 10, 2017 11:11 AM

    you mean xls or xlsx? I am looking for xslx format.



  • 4.  Re: Json to Excel filter
    Best Answer

    Broadcom Employee
    Posted May 24, 2017 11:14 AM

    One option is to write the Json responses  to a CSV file using the ' Write Step  to file step .  This file can then be opened  in EXCEL.  

    The other options is to write your own custom code.  

     

    Thanks

     

    Shiney.