I have few xml files generated on running some perl script on a document. This xml files list the property of the document. For ex. a word document having properties like author, title, creation date, modification date, size etc are listed in this xml.
Now i have to compare this xml with the excel file in which I have manualy written the document properties. Purpose is to test if the perl script is generating proper xml file by comparing it with excel having the property names in column and values in the rows.
For this I m thinking to parse the excel file in xml format and then compare both the xmls. Is my approach correct and how to code for this in perl?