如何在selenium中打开下载的excel文件

from selenium import webdriver
from selenium.webdriver.chrome.options import Options

chrome_options = Options()
chrome_options.add_experimental_option("prefs", {
    "download.default_directory": "/path/to/download/folder",
    "download.prompt_for_download": False,
    "download.directory_upgrade": True,
    "safebrowsing.enabled": True
})

driver = webdriver.Chrome(chrome_options=chrome_options)

import os

file_path = "/path/to/download/folder/filename.xlsx"

while not os.path.exists(file_path):
    time.sleep(1)  # 等待1秒

# 确保文件完全下载完成
time.sleep(2)  # 可根据实际情况调整等待时间

import openpyxl

workbook = openpyxl.load_workbook(file_path)
worksheet = workbook.active

# 读取数据
data = []
for row in worksheet.iter_rows(values_only=True):
    data.append(row)

# 处理数据
# ...

# 关闭Excel文件
workbook.close()

pip install openpyxl