inflearn logo
강의

Course

Instructor

Free Python Course (Usage 4) - Business Automation (RPA)

Create a file

환경설정 시 openpixl

458

graceha734383141

18 asked

0

선생님께서 하신대로 그대로 따라했는데 다음과 같은 오류가 뜹니다
 
 
PS D:\Visual Studio> pip install openpyxl WARNING: Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))': /simple/openpyxl/ WARNING: Retrying (Retry(total=3, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))': /simple/openpyxl/ WARNING: Retrying (Retry(total=2, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))': /simple/openpyxl/ WARNING: Retrying (Retry(total=1, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))': /simple/openpyxl/ WARNING: Retrying (Retry(total=0, connect=None, read=None, redirect=None, status=None)) after connection broken by 'SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))': /simple/openpyxl/ Could not fetch URL https://pypi.org/simple/openpyxl/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.org', port=443): Max retries exceeded with url: /simple/openpyxl/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))) - skipping ERROR: Could not find a version that satisfies the requirement openpyxl (from versions: none) ERROR: No matching distribution found for openpyxl Could not fetch URL https://pypi.org/simple/pip/: There was a problem confirming the ssl certificate: HTTPSConnectionPool(host='pypi.org', port=443): Max retries exceeded with url: /simple/pip/ (Caused by SSLError(SSLCertVerificationError(1, '[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: EE certificate key too weak (_ssl.c:997)'))) - skipping

환경설정 rpa

Answer 1

0

graceha734383141

제가 searching 을 해보았더니 제 pc는 뭔가 pip 가 안되더라구요, 그래서 소스들을 수동으로 다운받아  build, install 하였습니다. 

pip install openpyxl 설치가 완료되었는데도 아래같이 에러가 발생합니다

0

227

1

이미지 처리 관련 질문

0

101

2

메모장 file 변수 오류

0

818

1

pip 오류

1

501

1

시트 이름 지정하려는데 title 명령이 안 먹혀요

0

384

1

퀴즈에 값을 일일히 입력해야 하나요

0

362

1

파이썬 코드가 완료되면 브라우저가 닫힙니다.

1

458

1

find_element_by_id, find_element_by_link_text 등의 함수가 존재하지 않습니다.

0

472

1

자동완성 Reference

0

221

0

elem 후 엔터 時 attribute error 발생

0

715

1

창 최대화관련

0

248

0

오류발생

0

669

0

값넣을때 ws['A1'] vs ws['A1'].value

0

288

1

함수 계산 결과 불러오기

0

264

0

coordinate_from_string 참조 문제

0

203

0

이미지 프린트 時 box 정보 안뜸

0

242

0

마우스의 좌표

0

262

0

Pilow 설치

0

226

0

pip3 install pyautogui 설치 후 moveTo

0

212

0

아웃룩 에서 사용 할때

0

239

0

문의 드립니다.

0

200

0

new_ws = wb["NewSheet"] 질문

0

185

0

install 時 ERROR 발생

0

360

1

코드 실행이 안되고 계속 오류만 뜹니다

0

271

1