使用python XML或simplified_scrapy将xml转换为csv

import xml.etree.ElementTree as ET
import csv

def xml_to_csv(xml_file, csv_file):
    tree = ET.parse(xml_file)
    root = tree.getroot()

    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerow(['Column1', 'Column2', 'Column3'])  # 根据实际情况修改列名

        for child in root:
            data = [child.find('Element1').text, child.find('Element2').text, child.find('Element3').text]  # 根据实际情况修改元素名
            writer.writerow(data)

xml_to_csv('input.xml', 'output.csv')  # 替换为实际的输入和输出文件名

from simplified_scrapy import SimplifiedDoc, utils

def xml_to_csv(xml_file, csv_file):
    doc = SimplifiedDoc(utils.getFileContent(xml_file))
    rows = doc.selects('Row')  # 根据实际情况修改XPath表达式

    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerow(['Column1', 'Column2', 'Column3'])  # 根据实际情况修改列名

        for row in rows:
            data = [row.Element1.text, row.Element2.text, row.Element3.text]  # 根据实际情况修改元素名
            writer.writerow(data)

xml_to_csv('input.xml', 'output.csv')  # 替换为实际的输入和输出文件名

<Root>
    <Row>
        <Element1>Value1</Element1>
        <Element2>Value2</Element2>
        <Element3>Value3</Element3>
    </Row>
    <Row>
        <Element1>Value4</Element1>
        <Element2>Value5</Element2>
        <Element3>Value6</Element3>
    </Row>
    ...
</Root>