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

Filed under:
|
|

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

Related posts about Xml

Related posts about excel