ValueError:工作表索引0无效，找到0个工作表.无法在python中使用panda打开xlsx

Question

有人能帮我弄清楚为什么我的文件不能打开吗。

import pandas as pd
file = "C://Dev//20211103_logfile Box 2.8.xlsx"
temp=pd.read_excel(file)

这是完整的错误！

PS C:Dev> & C:/Users/keyur/AppData/Local/Programs/Python/Python39/python.exe c:/Dev/test_excel.py      
C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderworkbook.py:88: 
UserWarning: File contains an invalid specification for 20211103_logfile. This will be removed
warn(msg)
Traceback (most recent call last):
File "c:Devtest_excel.py", line 6, in <module>
temp=pd.read_excel(file)
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasutil_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasioexcel_base.py", line 372, in read_excel
data = io.parse(
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasioexcel_base.py", line 1272, in parse
return self._reader.parse(
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasioexcel_base.py", line 537, in parse
sheet = self.get_sheet_by_index(asheetname)
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasioexcel_openpyxl.py", line 546, in get_sheet_by_index
self.raise_if_bad_sheet_by_index(index)
File "C:UserskeyurAppDataLocalProgramsPythonPython39libsite-packagespandasioexcel_base.py", line 468, in raise_if_bad_sheet_by_index
raise ValueError(
ValueError: Worksheet index 0 is invalid, 0 worksheets found
PS C:Dev>

Answer 1

您的excel有问题，试着制作一个新的excel并复制所有数据，然后再试一次，这种方法对我有效。