[Python] (해결) ValueError: Your version of xlrd is 2.0.1. In xlrd >= 2.0, only the xls format is supported.

1. 에러 메세지

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

 

2. 해결

$ pip install openpyxl

 

3. openpyxl 버전 확인

### openpyxl 버전 확인 (3.0.x 버전 확인)
(base) JH@JH_COM:~/JH$ pip show openpyxl
Name: openpyxl
Version: 3.0.10
Summary: A Python library to read/write Excel 2010 xlsx/xlsm files
Home-page: https://openpyxl.readthedocs.io
Author: See AUTHORS
Author-email: charlie.clark@clark-consulting.eu
License: MIT
Location: /opt/conda/lib/python3.8/site-packages
Requires: et-xmlfile
Required-by: 


### xlrd 버전 확인 (그대로임)
(base) JH@JH_COM:~/$ pip show xlrd
Name: xlrd
Version: 2.0.1
Summary: Library for developers to extract data from Microsoft Excel (tm) .xls spreadsheet files
Home-page: http://www.python-excel.org/
Author: Chris Withers
Author-email: chris@withers.org
License: BSD
Location: /opt/conda/lib/python3.8/site-packages
Requires: 
Required-by:

 

아마 openpyxl 패키지의 버전이 낮은것이 원인이지 않을까 싶다! 에러 메세지에서 명시된 xlrd의 버전은 그대로 임에도 불구하고 해결이 된 것을 보아하니!