Re^2: excel to xml conversion and then comparison with another XML

Do you mean to convert the xml file which is generated as a output of perl script to excel. Then compare both the spreadsheets i.e. the spreadsheet which I created manually with the one converted from xml. will this be more convinient than comparing 2 xmls?

Comment on Re^2: excel to xml conversion and then comparison with another XML

Replies are listed 'Best First'.
Re^3: excel to xml conversion and then comparison with another XML by mscharrer (Hermit) on Apr 24, 2008 at 11:59 UTC
No, comparing the two XML files would be better. My point was that you take the XML generated by Excel as reference, i.e. you assume that Excel will produce correct, valid XML and differences to the Perl XML would mean that the Perl script made an error. I personally trust the Perl XML generator more than Excel. So I would take the Perl XML output as reference if Excel is generating correct XML. But don't start a Linux/Windows or Perl/MS Office flame war here ... you can use the modules I mentioned in my last post to compare the two XMLs, you just have to critical interpret the results.	[reply]

Replies are listed 'Best First'.

Re^3: excel to xml conversion and then comparison with another XML
by mscharrer (Hermit) on Apr 24, 2008 at 11:59 UTC

But don't start a Linux/Windows or Perl/MS Office flame war here ... you can use the modules I mentioned in my last post to compare the two XMLs, you just have to critical interpret the results.

[reply]