- Last post
- 7 Responses
Is it possible to convert an Excel spreadsheet to XML? What's the best way to do this?
yup. "Save as" XML.
It's not that simple...looks like I need to map the entires to XML somehow
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..
to row looks like: (\t = ta)_
ID /t Name /t Rank
and the XML you want looks like:
thanks vaxorcist...online converter turned out to be the way to go
what was the URL of the online converter?
yes, that's pretty much what I was thinking....