Submit and vote on feature ideas.

Welcome to the new Parasoft forums! We hope you will enjoy the site and try out some of the new features, like sharing an idea you may have for one of our products or following a category.

How do I convert XML data into an excel.

onkar
onkar 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:
ABC
123

I want to convert these data in Excel in table format

Answers

  • whaaker
    whaaker Posts: 59

    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.