解析多个XML节点值以导出到CSV

import csv
import xml.etree.ElementTree as ET

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

    # 创建CSV文件并写入表头
    with open(csv_file, 'w', newline='') as file:
        writer = csv.writer(file)
        writer.writerow(['Node1', 'Node2', 'Node3'])  # 根据实际情况修改表头

        # 遍历节点并提取值写入CSV
        for node1 in root.findall('Node1'):
            node1_value = node1.text

            for node2 in node1.findall('Node2'):
                node2_value = node2.text

                for node3 in node2.findall('Node3'):
                    node3_value = node3.text

                    # 将节点值写入CSV的一行
                    writer.writerow([node1_value, node2_value, node3_value])  # 根据实际情况修改列数

    print("XML节点值已成功导出到CSV文件。")

# 调用函数进行解析和导出
parse_xml_to_csv('input.xml', 'output.csv')

<Root>
    <Node1>
        <Node2>
            <Node3>Value1</Node3>
        </Node2>
    </Node1>
    <Node1>
        <Node2>
            <Node3>Value2</Node3>
        </Node2>
    </Node1>
    ...
</Root>