Sunday, 10 August 2014

Transferring Excel data to XML



I'm new to handeling XML in python so be easy on me. i've been trying transfer my excel data to an xml file that looks like so:



<?xml version="1.0" encoding="UTF-8"?>
<xml>
<shelter>
<adress>..</adress>
<code>...</code>
<neighborhood>..</neighborhood>
</shelter>
<shelter>
<adress>...</adress>
<code>...</code>
<neighborhood>...</neighborhood>
</shelter>
</xml>


my excel spread sheet looks like so:


enter image description here


Rather simple right? I tried a couple of methodes on excel also i tried to write a script to do but cant seem to make it work. Any ideas? Thanks a lot!


No comments:

Post a Comment