1 files changed, 14 insertions, 0 deletions
diff --git a/python/xmltotab.py b/python/xmltotab.py
new file mode 100644
index 00000000..ba8b2921
--- /dev/null
+++ b/python/xmltotab.py
@@ -0,0 +1,14 @@
+from lxml import etree
+import csv
+
+ns = '{urn:schemas-microsoft-com:office:spreadsheet}'
+
+doc = etree.parse('/home/share/guillaume/grid1_1cz1rlvt.xml')
+tree = doc.getroot()
+
+with open("output.csv", "w") as fh:
+    csvwriter = csv.writer(fh)
+    for row in tree.findall(".//{0}Row".format(ns)):
+        csvwriter.writerow([cell.findtext('{0}Data'.format(ns)) for cell in row])
+
+