Regarding Excel to XML data import
If i have posted this query in wrong forum please guide me to the correct one.
My query is regarding importing data from excel to xml.
So here is the thing,
We get data in excel format which describes acceptable values for each field in system .
For e.g excel mentions what are the valid values for firstname field in system. based on those values we create a our valid test case to test with values given
There are 2 ways to validate, either by UI or Load files via backend.
For loading data we use predefined format of XML. this xml takes data from excel & loads it to the system.
Right now we are doing manual task of pasting values from excel to xml.
Is there any tool/way that i can import the data from excel to xml?
Please let me know.
Any links/vids/info would be very helpful.
@meridian_05 we already have XML schema. I just need to move the data from excel to XML.
Nonetheless i will give a shot & see what i could do.