pyexcel突然不再打开.xlsx(或.xls)

Question

我已经安装了所有必需的依赖项:

pyexcel==0.7.0
pyexcel-ezodf==0.3.4
pyexcel-io==0.6.6
pyexcel-ods3==0.6.1
pyexcel-xls==0.7.0

(和其他一些，我省略了)。上周，我的代码还在工作。现在我无法打开相同的。xls

>>> p = Path("data/jr1305221.xls")
>>> p.exists()
True
>>> pyexcel.get_book(file_name=p)
Traceback (most recent call last):
File "<stdin>", line 2, in <module>
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelcore.py", line 47, in get_book
book_stream = sources.get_book_stream(**keywords)
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalcore.py", line 36, in get_book_stream
a_source = SOURCE.get_book_source(**keywords)
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 85, in get_book_source
return self.get_a_plugin(
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 69, in get_a_plugin
source_cls = self.load_me_now(
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 41, in load_me_now
if source.is_my_business(action, **keywords):
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelplugins__init__.py", line 56, in is_my_business
raise IOError("Unsupported file type")
OSError: Unsupported file type
>>>

或.xlsx

>>> p = Path('data/dummy.xlsx')
>>> p.exists()
True
>>> pyexcel.get_book(file_name=p)
Traceback (most recent call last):
File "<stdin>", line 1, in <module>
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelcore.py", line 47, in get_book
book_stream = sources.get_book_stream(**keywords)
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalcore.py", line 36, in get_book_stream
a_source = SOURCE.get_book_source(**keywords)
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 85, in get_book_source
return self.get_a_plugin(
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 69, in get_a_plugin
source_cls = self.load_me_now(
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelinternalsource_plugin.py", line 41, in load_me_now
if source.is_my_business(action, **keywords):
File "C:UsersUser McUserAppDataLocalProgramsPythonPython310libsite-packagespyexcelplugins__init__.py", line 56, in is_my_business
raise IOError("Unsupported file type")
OSError: Unsupported file type
>>>

即使在我的docker容器中，它也停止工作了。

作为替代，我也尝试过

with open('data/dummy.xlsx', 'r') as f:
pyexcel.get_book(file_name=f)

并得到相同的错误。

我又读了一遍文档。我已将代码回滚到上周。我到底做了什么，要受到这样的惩罚?上帝为什么离弃我?

Answer 1

file_name需要是一个字符串，我在传递一个pathlib.PosixPath

。，返回错误:

p = Path('my_file')
pyexcel.get_book(file_name=p)

如此:

pyexcel.get_book(file_name='my_file')

您可以使用pyexcel.get_book(file_name=my_file.as_posix())从PosixPath获得字符串表示。