使用python XML库将xml转换为csv

import xml.etree.ElementTree as ET
import csv

tree = ET.parse('input.xml')
root = tree.getroot()

csv_file = open('output.csv', 'w')
csv_writer = csv.writer(csv_file)
csv_writer.writerow(['Column1', 'Column2', 'Column3'])  # 替换为实际的表头

for child in root:
    data = []
    data.append(child.find('Element1').text)  # 替换为实际的元素名称
    data.append(child.find('Element2').text)
    data.append(child.find('Element3').text)
    csv_writer.writerow(data)

csv_file.close()