使用python在excel中检查一组超链接的活动和非活动状态

import openpyxl
import requests

workbook = openpyxl.load_workbook('your_file.xlsx')
worksheet = workbook['Sheet1']  # 替换为你的工作表名称

for row in worksheet.iter_rows():
    for cell in row:
        if cell.hyperlink is not None:
            url = cell.hyperlink.target
            # 进一步检查链接的活动状态

response = requests.head(url)
if response.status_code == 200:
    status = '活动'
else:
    status = '非活动'

worksheet.cell(row=cell.row, column=cell.column+1).value = status

import openpyxl
import requests

workbook = openpyxl.load_workbook('your_file.xlsx')
worksheet = workbook['Sheet1']  # 替换为你的工作表名称

for row in worksheet.iter_rows():
    for cell in row:
        if cell.hyperlink is not None:
            url = cell.hyperlink.target
            response = requests.head(url)
            if response.status_code == 200:
                status = '活动'
            else:
                status = '非活动'
            worksheet.cell(row=cell.row, column=cell.column+1).value = status

workbook.save('your_file.xlsx')