批量访问URL是否可以访问脚本

 

import requests
import xlwt
from xlwt import Workbook

# 读取txt文件中所有URL
with open("urls.txt", "r") as f:
    urls = [line.strip() for line in f.readlines()]

# 创建工作簿并添加工作表
wb = Workbook()
ws = wb.add_sheet("URL Test Results")

# 添加表头行
ws.write(0, 0, "URL")
ws.write(0, 1, "Status")

# 遍历每个URL并测试
for i, url in enumerate(urls):
    try:
        response = requests.get(url, timeout=5)
        if response.status_code == 200:
            ws.write(i+1, 0, url)
            ws.write(i+1, 1, "Accessible")
        else:
            ws.write(i+1, 0, url)
            ws.write(i+1, 1, f"Returned status code {response.status_code}")
    except requests.exceptions.Timeout:
        ws.write(i+1, 0, url)
        ws.write(i+1, 1, "No response within 5 seconds")
    except requests.exceptions.RequestException as e:
        ws.write(i+1, 0, url)
        ws.write(i+1, 1, f"Threw an exception: {e}")

# 保存工作簿为xls文件
wb.save("url_test_results.xls")