How to Create an XML File from an Excel File
Posted
by nicorellius
on Super User
See other posts from Super User
or by nicorellius
Published on 2010-05-20T02:50:23Z
Indexed on
2010/05/20
2:50 UTC
Read the original article
Hit count: 302
I have an Excel spreadsheet file that has 5 or so columns and hundreds of lines. I need to convert this (export these data) to an XML file. I'm interested in three of the columns and they correspond to these XML tags, where info1 can be followed by info2, info3, etc...
<?xml version="1.0" encoding="UTF-8" ?>
<list>
<info1>
<id>111</id>
<value>222</value>
<des>333</des>
</info1>
</list>
If possible, I would like to avoid building this XML manually. It wouldn't be too much trouble to rearrange the Excel file such that the three columns I'm interested in were in their own file. But then I would need to export those data into an XML file of the above format. Any ideas?
© Super User or respective owner