How to Create an XML File from an Excel File
- by nicorellius
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?
