Excel to XML
Excel to XML
Out of context: Reply #3
- Started
- Last post
- 7 Responses
- vaxorcist0
there's XML, and.... there's XML....
save-as XML will give you what Microsoft thinks is the XML tagset... which may not be at all what you want....
If you want to map the entries to XML tags, like the top-line of each row being the sub-entity, that's probably a small PHP script to write output from a tab-separated export from Excel... I'm sure somebody has written this somewhere... it's probably a 2 hour job or so..
i.e.
to row looks like: (\t = ta)_
ID /t Name /t Rankand the XML you want looks like:
<employee>
<id>111</id>
<name>joe smith</name>
<rank>vice president</rank>
</employee>etc...