Traceback (most recent call last):
File "c:/Users/Admin/Desktop/读取文件.py", line 4, in <module>
data=pd.read_excel(filepath,'sheet1')
File "C:\Users\Admin\AppData\Roaming\Python\Python37\site-packages\pandas\util\_decorators.py", line 311, in wrapper
return func(*args, **kwargs)
File "C:\Users\Admin\AppData\Roaming\Python\Python37\site-packages\pandas\io\excel\_base.py", line 364, in read_excel
io = ExcelFile(io, storage_options=storage_options, engine=engine)
File "C:\Users\Admin\AppData\Roaming\Python\Python37\site-packages\pandas\io\excel\_base.py", line 1192, in __init__
content_or_path=path_or_buffer, storage_options=storage_options
File "C:\Users\Admin\AppData\Roaming\Python\Python37\site-packages\pandas\io\excel\_base.py", line 1071, in inspect_excel_format
content_or_path, "rb", storage_options=storage_options, is_text=False
File "C:\Users\Admin\AppData\Roaming\Python\Python37\site-packages\pandas\io\common.py", line 710, in get_handle
handle = open(handle, ioargs.mode)
FileNotFoundError: [Errno 2] No such file or directory: 'C:\\Users\\Admin\\Desktop\\字典20191018.xlsx'
读取文件的文件名必须英文,中文文件名则会出现上述问题