hanker

Python - read_excel 에러 (ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.) 본문

Python/Python Error

Python - read_excel 에러 (ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.)

hanker 2021. 3. 9. 09:52
반응형

ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported. Install openpyxl instead.

 

pandas로 read_excel(xlms)시 오류가 발생했다. 

오류 로그에 xlrd 2.0 이상 버전은 xls만 지원한다고 한다.

xlrd 버전을 1.0.2로 바꾸고 진행해도 오류가 안없어져서 openpyxl을 설치했더니 오류가 나지 않는다!

 

pip install openpyxl

 

반응형
저작자표시

'Python > Python Error' 카테고리의 다른 글

ValueError: time data "" doesn't match format "%Y-%m-%d", at position 1. You might want to try:  (0) 2025.02.27
Python Er - raise ValueError("The number of derivatives at boundaries does not " f"match: expected {nt-n}, got {nleft}+{nright}")  (0) 2025.02.24
ValueError: zero-dimensional arrays cannot be concatenated 오류 발생 원인  (0) 2024.10.03
I tensorflow/core/util/port.cc:153] oneDNN custom operations are on. You may see slightly different numerical results due to floating-point round-off errors from different computation orders. To turn them off, set the environment variable `TF_ENABLE_ONEDN  (0) 2024.09.23
unicodeescape' codec can't decode bytes in position 2-3:  (0) 2024.09.21
'Python/Python Error' Related Articles more