Python openpyxl 告诉我" No such file or directory:"即使 python 文件与 excel 文件位于同一目录中，等等

Question

这里是初学者。我尝试过制作新的excel文件，在excel文件打开时运行python代码，尝试过重命名excel文件，但都不起作用。我只是在关注这个youtube教程：https://www.youtube.com/watch?v=7YS6YDQKFh0&t=14s

from openpyxl import Workbook, load_workbook
workbook = load_workbook("Test2.xlsx")

错误：

Traceback (most recent call last):
File "c:UsersNameDesktopPython ProjectsExcel ManipulationExcel_Test.py", line 3, in <module>
workbook = load_workbook("Test2.xlsx")
File "C:UsersNameAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 315, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File "C:UsersNameAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 124, in __init__
self.archive = _validate_archive(fn)
File "C:UsersNameAppDataLocalProgramsPythonPython39libsite-packagesopenpyxlreaderexcel.py", line 96, in _validate_archive
archive = ZipFile(filename, 'r')
File "C:UsersNameAppDataLocalProgramsPythonPython39libzipfile.py", line 1239, in __init__
self.fp = io.open(file, filemode)
**FileNotFoundError: [Errno 2] No such file or directory: 'Test2.xlsx'
PS C:UsersName>** 

Answer 1

我找到了一个解决方案。事实证明，您只需要复制文件位置，将其转换为原始字符串，并在末尾添加\ExcelFile：

from openpyxl import Workbook, load_workbook
location = r'C:UsersNameDesktopPython ProjectsExcel ManipulationTest2.xlsx'
workbook = load_workbook(location)

Derp。