Hi All,
Here is another article on testing and working with XML files. There is a growing demand for testing XMl files as most of the companies get there data in XML format and also send data in XML format.
I was testing xml files in one of my projects and wanted to convert the xml data into xls and found this very useful tool called XMLtoXLS. You can download this application from http://www.forgram.com/. Its a freeware and very useful to convert the xml data to xls.
Once the data is converted XLS you can use the data for automation and convert it back to XML if you want to prepare some test data. I will write a seperate article on how to convert a xls data to xml using excel macros. Its no rocket science and you should be able to learn it no time.
Happy Testing
Pavandeep Puddupakkam
Hi Praveen,
I’m having a requirement to do performance test and the input fiel would be xml.
i have a sample file of 3 records and i have to make it big for 1lakh records.
i’m able to open the file in xls – openwith – excel ad option.
trying to increase the data and the problem starts here when i try to convert back it to xml file.
Please help.
sorry for the typo in name – it should be “Pavandeep”