如何将XML从URL解析为excel表格？

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

# 发送HTTP GET请求获取XML数据
url = "http://example.com/xml_data"
response = requests.get(url)
xml_data = response.text

# 解析XML数据
root = ET.fromstring(xml_data)

# 创建Excel文件
workbook = Workbook()
sheet = workbook.active

# 遍历XML节点，提取数据并写入Excel文件
row_index = 1
for child in root:
    column_index = 1
    for sub_child in child:
        sheet.cell(row=row_index, column=column_index, value=sub_child.text)
        column_index += 1
    row_index += 1

# 保存Excel文件
workbook.save("output.xlsx")