如何使用python从网页下拉列表中提取数据并在excel中打印

import requests
from bs4 import BeautifulSoup
import openpyxl

url = "网页的URL地址"
response = requests.get(url)

soup = BeautifulSoup(response.text, "html.parser")

select_element = soup.find("select", {"name": "下拉列表的name属性值"})

options = select_element.find_all("option")
data = []
for option in options:
    value = option["value"]
    text = option.text
    data.append((value, text))

workbook = openpyxl.Workbook()
sheet = workbook.active
for row in data:
    sheet.append(row)
workbook.save("文件路径.xlsx")