csv文件
code
from xml.etree.ElementTree import Element,ElementTree,tostring
import json,csv
def csvtoxml(fname):
with open(fname,'r') as f:
reader=csv.reader(f)
header=next(reader)
root=Element('Daaa')
print('root',len(root))
for row in reader:
erow=Element('Row')
root.append(erow)
for tag,text in zip(header,row):
e=Element(tag)
e.text=text
erow.append(e)
beatau(root)
return ElementTree(root)
def beatau(e,level=0):
if len(e)>0:
e.text='\n'+'\t'*(level+1)
for child in e:
beatau(child,level+1)
child.tail=child.tail[:-1]
e.tail='\n' + '\t'*level
et=csvtoxml(r'C:\Temp\ff.csv')
et.write(r'C:\Temp\fff.xml')
from xml.etree.Elemen