excel importing xml data question
I'm running a Universe system where they have a "TOXML"
By doing a simple list such as:
"LIST ICPM ITM DES.60 SIZ ICQF.DLR ICQF.DLS ID-SUPP LPTR TOXML"
to a spool hold file, and then exporting this file to Windows as a " ~~
..xml" file -
I can then open this file with Excel - and lo and behold - instant spread
The problem is that Excel imports the data via a sort where column 1 is the
"DES.60" data, column 2 is the "ICQF.DLR" and so on where column 5 is the
Clearly not the order that was specified.
Here is a snippet from the xml file:
The question is - does anyone know of a way to get Excel to import the data
is the same order as it was created?
Any help is appreciated.