raise KeyError("Worksheet {0} does not exist.".format(key)) KeyError: 'Worksheet Sheet does not exist.'

This error is raised when you try to access a worksheet in a workbook using a key (usually a string) that does not match the name of any existing worksheet in the workbook.

For example, if you have a workbook with three worksheets named "Sheet1", "Sheet2", and "Sheet3", and you try to access a worksheet using the key "Sheet", you will get this error because there is no worksheet named "Sheet".

To fix this error, make sure you are using the correct key (the name of an existing worksheet) when trying to access a worksheet in the workbook.

相关问题

KeyError: 'Worksheet Sheet does not exist.'

这个错误通常是由于你在代码中引用了一个不存在的工作表名称，比如说`Sheet`。你需要确保你的Excel文件中存在一个名为`Sheet`的工作表，或者你可以使用已经存在的工作表名称。

如果你不确定工作表的名称，可以在代码中使用`worksheet_names`属性来获取工作表名称的列表，例如：

workbook = openpyxl.load_workbook('example.xlsx')
worksheet_names = workbook.sheetnames
print(worksheet_names)

这将打印出Excel文件中所有工作表的名称。你可以从中选择一个正确的工作表名称，然后在代码中使用它来引用工作表。例如：

workbook = openpyxl.load_workbook('example.xlsx')
worksheet = workbook['Sheet1']

在这个例子中，我们使用了`Sheet1`这个名称来引用Excel文件中的一个工作表，避免了`Worksheet Sheet does not exist`这个错误。

raise KeyError("Worksheet {0} does not exist.".format(key))

This line of code raises a KeyError with a message indicating that the specified worksheet does not exist.

A KeyError is raised when a key is not found in a dictionary or other mapping object. In this case, it suggests that the code is trying to access a worksheet that is not present in the workbook.

The message is formatted using the format() method to include the name of the missing worksheet in the error message. This can help the user or developer to identify the specific worksheet that is causing the issue.