原因分析：要从excel文件获取的sheet不存在。
for n in N1:name = n[n.index('R'):n.index('-数量')]re = load_workbook(path2+'1.xlsx')re.save(path2+'2.xlsx')rb = re['sheet']print(rb)
问题解决：修改rb = re[‘sheet’]里的’sheet’，改成与excel里sheet一致的名称。
rb = re['Sheet']
详细解决方案
KeyError: ‘Worksheet sheet does not exist.‘
热度：58 发布时间：2023-12-16 03:19:00.0
相关解决方案
- Files' name is invalid or does not exist (1205).这是关于什么的异常
- 怎么将字符串得到控件id 的后续有关问题The name 'dd1' does not exist in the current context
- Parser Error Message: The file '/MasterPage.master' does not exist.解决办法
- word中不显示图片，再有套用的EXCEL表格不显示，只显示embed excel.sheet.8.0
- worksheet.OleObject.Add有关问题
- word中不显示图片，还有套用的EXCEL表格不显示，只显示embed excel.sheet.8.0?解决方案
- (Excel)Sheet.GetRange("A1" "C5")中表示起止的行列号能改成纯数字吗?比如(1,1),(5,3),该如何处理
- 选择 Excel 多张 sheet,该如何解决
- bootstrap.jar which is referenced by the classpath, does not exist.
- CSS（Cascading Style Sheet ）级联样式表小结
- 【上载】css、php、jquery的cheat sheet
- property position does not exist in css Level1.解决办法
- ORA-00942: table or view does not exist,该怎么解决
- 【JSP引来报错】-package javax.servlet.jsp does not exist
- 前端助理工程师必备 Cheat Sheet
- how to verify an element does NOT exist in Selenium 二
- 哪位大哥帮忙啊，异常：package com.ur.util does not exist
- 上传图片有关问题！大家帮帮忙！java.lang.IllegalArgumentException: This path does not exist (1135)
- java.lang.IllegalArgumentException: This path does not exist
- 请问一下 使用webogic 9运行JSP 程序 提示 Package com.jspsmart.upload does not exist
- Tomcat有关问题:Document base does not exist or is not a readable directory
- Sheet index (0) is out of range (0.1) POI操作Excel异常
- This path does not exist (1135),该怎么处理
- 上传报错：Files' name is invalid or does not exist (1205)
- hibernate “could not execute query” “Table 'user.tab_employee' doesn't exist”,该如何处理
- hibernate报错 ： Table '小弟我使用的数据库.all_sequences' doesn't exist. 好冷门的有关问题，估计这辈子都找不到答案
- jspsmartupload 出现Files' name is invalid or does not exist
- META-INF/MANIFEST.MF does not exist 小弟我该怎么处理
- java.lang.IllegalArgumentException: This path does not exist (1135)
- 100分急求：Positional parameter does not exist,该怎么解决