How do I convert XML data into an excel.

onkaronkar Posts: 9
edited July 2020 in SOAtest

I want to fetch data from XML and put it into an excel.
My XML data is like:

I want to convert these data in Excel in table format


  • whaakerwhaaker Posts: 47

    Hi, it would be helpful if you could explain why you would like to do this. Depending on what you are trying to achieve, there may be different recommendations on how to best proceed. For example, if you are trying to accumulate some dynamic data during test execution so that you can later have subsequent test steps iterate over it, you don't need to use Excel for that. You will instead want to use SOAtest's built-in Writable Data Source:

    If you are looking to do some kind of custom reporting, then I encourage you to first explore SOAtest's reporting options, soatestcli (or SOAtest Server's REST API), and especially what is available in the raw report.xml file that can be used as a starting point for custom reporting via XSLT:

    If there's another reason you're asking for this, please share so I can help.

Sign In or Register to comment.