module 'openpyxl' has no attribute 'load_wordbook'

唠唠啊

wb = openpyxl.load_wordbook(r'D:\SYSTEM\MSO-LYL\Desktop')
Traceback (most recent call last):
  File "<pyshell#3>", line 1, in <module>
    wb = openpyxl.load_wordbook(r'D:\SYSTEM\MSO-LYL\Desktop')
AttributeError: module 'openpyxl' has no attribute 'load_wordbook'

满脸问号。。。难道是版本问题？

冬雪雪冬

workbook

唠唠啊

wb = openpyxl.load_workbook(r"D:\SYSTEM\MSO-LYL\Desktop\办公篇.xls")
Traceback (most recent call last):
  File "<pyshell#23>", line 1, in <module>
    wb = openpyxl.load_workbook(r"D:\SYSTEM\MSO-LYL\Desktop\办公篇.xls")
  File "C:\Users\YLLiu\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 312, in load_workbook
    reader = ExcelReader(filename, read_only, keep_vba,
  File "C:\Users\YLLiu\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 124, in __init__
    self.archive = _validate_archive(fn)
  File "C:\Users\YLLiu\AppData\Local\Programs\Python\Python38-32\lib\site-packages\openpyxl\reader\excel.py", line 94, in _validate_archive
    raise InvalidFileException(msg)
openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support the old .xls file format, please use xlrd to read this file, or convert it to the more recent .xlsx file format.

唠唠啊

。xls版本太老不支持么

唠唠啊

冬雪雪冬 发表于 2019-12-19 08:55
workbook

这问题问的太随意了

gywjj

根据提示，是不支持，要用xlrd.open_workbook(filename[, logfile, file_contents, ...])打开

参天小草

唠唠啊 发表于 2019-12-19 09:17
。xls版本太老不支持么

openpyxl不支持xls，要先转化一下。单个文件可以直接另存为xlsx，批量的话网上有VBA代码