Python错误集锦：openpyxl打开表格工作表时提示KeyError: ‘Worksheet sheet does not exist.’

最新推荐文章于 2024-08-25 22:10:23 发布

原创

最新推荐文章于 2024-08-25 22:10:23 发布 · 1.2k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#python

原文链接：http://www.juzicode.com/python-error-worksheet-sheet-does-not-exist

错误提示：

openpyxl打开表格sheet页时提示KeyError: ‘Worksheet sheet does not exist.’

#juzicode.com/VX公众号:juzicode 
from openpyxl import load_workbook 
wb = load_workbook('profile.xlsx') 
ws = wb['sheet'] 
vals = []
for row in ws.iter_rows(values_only=True): # 迭代读出
    vals.append(row)
    print(row)

==========运行结果：
---------------------------------------------------------------------------
KeyError                                  Traceback (most recent call last)
Cell In[9], line 4
      2 from openpyxl import load_workbook