爬虫报错：​​​​ValueError: check_hostname requires server_hostname

检查了一下代码没有错误，搜索报错信息之后知道是因为Vpn服务没有关闭造成的，因为使用Chrom搜索引擎确实方便，避免了很多的垃圾广告，于是我买了一个Vpn服务，将Vpn服务关闭之后就可以正常运行。

import requests
import json
from openpyxl import Workbook, load_workbook

url = "https://www.ptpress.com.cn//masterpiece//getMasterpieceListForPortal"
headers = {
    "User-Agent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) "
                  "Chrome/95.0.4638.69 Safari/537.36 "
}

resp = requests.get(url, headers=headers)
# print(resp.text)
res = json.loads(resp.text)
results = res['data']

workbook = Workbook()
worksheets = workbook.worksheets[0]
worksheets.append(['bookName', 'bookId', 'picPath'])
for result in results:
    worksheets.append([result['bookName'], result['bookId'], result['picPath']])
    workbook.save('人民邮电.xlsx')