如何在python中使用selenium将锚标记及其超链接复制到excel中。

from selenium import webdriver
import openpyxl

driver = webdriver.Chrome()  # 使用Chrome浏览器，需要提前安装ChromeDriver并配置到系统环境变量中

driver.get("https://example.com")  # 替换为你需要爬取的网页URL

anchors = driver.find_elements_by_tag_name("a")  # 定位到所有的<a>标签元素
data = []  # 存储锚标记和超链接的数据
for anchor in anchors:
    text = anchor.text  # 获取锚标记的文本
    href = anchor.get_attribute("href")  # 获取锚标记的超链接
    data.append([text, href])  # 将锚标记和超链接添加到数据列表中

workbook = openpyxl.Workbook()
sheet = workbook.active
for row in data:
    sheet.append(row)  # 将数据逐行写入工作表
workbook.save("anchors.xlsx")  # 保存Excel文件

from selenium import webdriver
import openpyxl

driver = webdriver.Chrome()
driver.get("https://example.com")

anchors = driver.find_elements_by_tag_name("a")
data = []
for anchor in anchors:
    text = anchor.text
    href = anchor.get_attribute("href")
    data.append([text, href])

workbook = openpyxl.Workbook()
sheet = workbook.active
for row in data:
    sheet.append(row)
workbook.save("anchors.xlsx")

driver.quit()