在python中将excel转换为XML

import openpyxl
import xml.etree.ElementTree as ET

def excel_to_xml(input_file, output_file):
    # 打开Excel文件
    wb = openpyxl.load_workbook(input_file)
    sheet = wb.active

    # 创建XML根节点
    root = ET.Element("data")

    # 遍历Excel行
    for row in sheet.iter_rows(values_only=True):
        # 创建XML子节点
        item = ET.SubElement(root, "item")

        # 遍历Excel列
        for value in row:
            # 创建XML子节点的子节点
            child = ET.SubElement(item, str(value))

    # 创建XML文档并写入文件
    tree = ET.ElementTree(root)
    tree.write(output_file, encoding="utf-8", xml_declaration=True)

input_file = "input.xlsx"
output_file = "output.xml"
excel_to_xml(input_file, output_file)