python运行不了xlrd.open_workbook()

Question

代码是这样的：

import xlrd
data = xlrd.open_workbook('data_1.xlsx')

运行结果是这样的：

C:\Users\73116\AppData\Local\Programs\Python\Python39\python.exe C:/Users/73116/Desktop/Myfiles/demo_1.py
Traceback (most recent call last):
  File "C:\Users\73116\Desktop\Myfiles\demo_1.py", line 7, in <module>
    data = xlrd.open_workbook('data_1.xlsx')
  File "C:\Users\73116\AppData\Local\Programs\Python\Python39\lib\site-packages\xlrd\__init__.py", line 170, in open_workbook
    raise XLRDError(FILE_FORMAT_DESCRIPTIONS[file_format]+'; not supported')
xlrd.biffh.XLRDError: Excel xlsx file; not supported

Process finished with exit code 1

怎么破

Answer 1

xlrd不支持对xlsx文件的读取，如果要读取xlsx格式工作簿，建议安装和使用openpyxl，支持xlsx等文件读写及其他操作，pip install openpyxl。