pip错误SSL:CERTIFICATE_VERIFY_FAILED的解决方法

使用pip install openpyxl时出现错误：

  Could not fetch URL https://pypi.tuna.tsinghua.edu.cn/simple/openpyxl/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.tuna.tsinghua.edu.cn', port=443): Max retries exceeded with url: /simple/openpyxl/(Caused by SSLError(SSLError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed (_ssl.c:833)'),)) - skipping
 Could not find a version that satisfies the requirement openpyxl (from versions: )

No matching distribution found for openpyxl

添加信任主机选项，重新执行pip：

pip --trusted-host pypi.tuna.tsinghua.edu.cn install openpyxl