python - 即使在安装 pyexcel-xls 和 pyexcel-xlsx 后也无法使用 Pyexcel 打开 Excel 文件

Question

我尝试使用 pyexcel 打开一个简单的 excel 文件，但是出现以下错误：

SupportingPluginAvailableButNotInstalled: Please install one of these plugins for read data in 'xlsx': pyexcel-xls,pyexcel-xlsx

我的代码：

import pyexcel as pe
sheet = pe.get_sheet(file_name=k, name_columns_by_row=0,skip_empty_rows=True)

我尝试过的事情：

pip install pyexcel-xls;
pip install pyexcel-xlsx;
Use anaconda instead of IDLE;
reinstall Python 3.7

然而，没有运气

完整错误：

runfile('H:/Data/Data/clean_data.py', wdir='H:/Data/Data')
Reloaded modules: d_help
.\added_c\profile1 (1).xlsx
[autoreload of pyexcel.internal failed: Traceback (most recent call last):
  File "C:\Users\XX\Anaconda3\lib\site-packages\IPython\extensions\autoreload.py", line 244, in check
    superreload(m, reload, self.old_objects)
  File "C:\Users\XX\Anaconda3\lib\site-packages\IPython\extensions\autoreload.py", line 378, in superreload
    module = reload(module)
  File "C:\Users\XX\Anaconda3\lib\imp.py", line 314, in reload
    return importlib.reload(module)
  File "C:\Users\XX\Anaconda3\lib\importlib\__init__.py", line 169, in reload
    _bootstrap._exec(spec, module)
  File "<frozen importlib._bootstrap>", line 630, in _exec
  File "<frozen importlib._bootstrap_external>", line 728, in exec_module
  File "<frozen importlib._bootstrap>", line 219, in _call_with_frames_removed
  File "C:\Users\XX\Anaconda3\lib\site-packages\pyexcel\internal\__init__.py", line 37, in <module>
    white_list=WHITE_LIST,
  File "C:\Users\XX\Anaconda3\lib\site-packages\lml\loader.py", line 137, in scan_plugins_regex
    do_import(module_name)
  File "C:\Users\XX\Anaconda3\lib\site-packages\lml\utils.py", line 42, in do_import
    return _do_import(plugin_module_name)
AttributeError: module 'pyexcel' has no attribute 'plugins'
]
Traceback (most recent call last):

标签： pythonexcelpyexcel