How do I convert XML data into an excel.

onkar

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

whaaker

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:

• https://docs.parasoft.com/display/SOA20201/_Parameterizing+Tests+with+Values+Extracted+from+Another+Test

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:

• https://docs.parasoft.com/display/SOA20201/Configuring+Report+Settings

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