Quote:
Originally Posted by joefromchicago
You're using Excel to open xml files? I didn't know that was possible.
|
It's been possible starting in Excel 2007. It is, however, an enormous pain in the neck. You're much better off using an actual xml editor.
In Excel you'll need to create an xml schema, map every element from the xml file onto it, and hope like hell you don't run into any abstract elements, substitution groups, mixed content, recursive structures more than one level deep, or any other complications Excel can't deal with. Excel can infer the schema from the xml file structure but it doesn't do so very well. I've rarely had an inferred schema turn out right.