Python -将文件夹中的所有XML文件解析为CSV文件

import os
import csv
import xml.etree.ElementTree as ET

def parse_xml_to_csv(folder_path, output_file):
    with open(output_file, 'w', newline='') as csvfile:
        writer = csv.writer(csvfile)
        writer.writerow(['Tag', 'Text'])  # 写入CSV文件的表头

        for filename in os.listdir(folder_path):
            if filename.endswith('.xml'):
                xml_file = os.path.join(folder_path, filename)
                tree = ET.parse(xml_file)
                root = tree.getroot()

                for element in root.iter():
                    tag = element.tag
                    text = element.text
                    writer.writerow([tag, text])  # 写入CSV文件的每一行

# 示例用法
folder_path = 'path/to/xml/folder'
output_file = 'path/to/output.csv'
parse_xml_to_csv(folder_path, output_file)