用python实现多页XML到Excel的转换

pip install openpyxl

import xml.etree.ElementTree as ET
from openpyxl import Workbook

def xml_to_excel(xml_file, excel_file):
    # 创建一个新的Excel文件
    workbook = Workbook()
    sheet = workbook.active
    
    # 解析XML文件
    tree = ET.parse(xml_file)
    root = tree.getroot()
    
    # 遍历XML文件的每个页
    for page in root:
        # 创建一个新的工作表
        sheet = workbook.create_sheet(title=page.tag)
        
        # 在工作表中添加表头
        headers = []
        for element in page[0]:
            headers.append(element.tag)
        sheet.append(headers)
        
        # 在工作表中添加数据
        for row in page[1:]:
            data = []
            for element in row:
                data.append(element.text)
            sheet.append(data)
    
    # 保存Excel文件
    workbook.save(excel_file)

xml_file = 'path/to/xml/file.xml'
excel_file = 'path/to/excel/file.xlsx'
xml_to_excel(xml_file, excel_file)