如何在Python for Selenium Automation中读取XML数据和写入Excel工作表

import xml.etree.ElementTree as ET
import openpyxl

# 读取XML数据
tree = ET.parse('data.xml')
root = tree.getroot()

# 创建Excel工作簿
workbook = openpyxl.Workbook()
sheet = workbook.active

# 写入表头
sheet.cell(row=1, column=1, value='Name')
sheet.cell(row=1, column=2, value='Age')

# 写入XML数据到Excel
row_index = 2
for person in root.iter('person'):
    name = person.find('name').text
    age = person.find('age').text

    sheet.cell(row=row_index, column=1, value=name)
    sheet.cell(row=row_index, column=2, value=age)

    row_index += 1

# 保存Excel工作簿
workbook.save('data.xlsx')

<data>
    <person>
        <name>John</name>
        <age>30</age>
    </person>
    <person>
        <name>Alice</name>
        <age>25</age>
    </person>
</data>