blob: ba8b2921c2541951580391e7e02da58559d73e89 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
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])
|
