|
发表于 2019-10-23 10:29:09
|
显示全部楼层
为什么我copy这代码,但是运行出错,是什么问题??不理解each_row[1].value = data_updates[each_row[0].value]?为什么不是等于data_updates[each_row[1].value?
下面是出错的界面:
runfile('C:/Users/coco/.spyder-py3/temp.py', wdir='C:/Users/coco/.spyder-py3')
Traceback (most recent call last):
File "<ipython-input-1-ffe1257465b1>", line 1, in <module>
runfile('C:/Users/coco/.spyder-py3/temp.py', wdir='C:/Users/coco/.spyder-py3')
File "D:\Anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 827, in runfile
execfile(filename, namespace)
File "D:\Anaconda\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)
File "C:/Users/coco/.spyder-py3/temp.py", line 26, in <module>
main()
File "C:/Users/coco/.spyder-py3/temp.py", line 16, in main
wb = openpyxl.load_workbook("豆瓣TOP250电影.xlsx")
File "D:\Anaconda\lib\site-packages\openpyxl\reader\excel.py", line 311, in load_workbook
data_only, keep_links)
File "D:\Anaconda\lib\site-packages\openpyxl\reader\excel.py", line 126, in __init__
self.archive = _validate_archive(fn)
File "D:\Anaconda\lib\site-packages\openpyxl\reader\excel.py", line 98, in _validate_archive
archive = ZipFile(filename, 'r')
File "D:\Anaconda\lib\zipfile.py", line 1204, in __init__
self.fp = io.open(file, filemode)
FileNotFoundError: [Errno 2] No such file or directory: '豆瓣TOP250电影.xlsx'
|
|