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 Rank

    and the XML you want looks like:

    <employee>
    <id>111</id>
    <name>joe smith</name>
    <rank>vice president</rank>
    </employee>

    etc...

View thread