Forum Discussion

Chandrakanth's avatar
Chandrakanth
Occasional Contributor
5 years ago
Solved

How to load a large XML data in Excel for Data driven testing

Hello Team,   I would like to know how to convert the bunch of XML data into excel for data driven testing. To explain it breifly, I have a large set of XML Responses and want to use that data in t...
  • Nastya_Khovrina's avatar
    Nastya_Khovrina
    5 years ago

    There is the XML type of a Datasource in ReadyAPI so, maybe, you can read an XML content to some property, and, then, parse it without using Excel. Also, please note that there is the Directory DataSource in ReadyAPI (you can use it to get the XML files content).

     

    But, ReadyAPI doesn't have built-in options for converting .xml file to .xslx format, you can do this using scripts in ReadyAPI or in another tool, for example like this: https://www.wikihow.com/Convert-XML-to-Excel.

Nastya_Khovrina's avatar
Nastya_Khovrina
SmartBear Alumni (Retired)
5 years ago

There is the XML type of a Datasource in ReadyAPI so, maybe, you can read an XML content to some property, and, then, parse it without using Excel. Also, please note that there is the Directory DataSource in ReadyAPI (you can use it to get the XML files content).

 

But, ReadyAPI doesn't have built-in options for converting .xml file to .xslx format, you can do this using scripts in ReadyAPI or in another tool, for example like this: https://www.wikihow.com/Convert-XML-to-Excel.