python 写入excel 效率_使用Python读写Excel文件（2）
为什么我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 "", line 1, in
runfile(C:/Users/coco/.spyder-py3/temp.py, wdir=C:/Users/coco/.spyder-py3)
File "D:Anacondalibsite-packagesspyder_kernelscustomizespydercustomize.py", line 827, in runfile
execfile(filename, namespace)
File "D:Anacondalibsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, exec), namespace)
File "C:/Users/coco/.spyder-py3/temp.py", line 26, in
main()
File "C:/Users/coco/.spyder-py3/temp.py", line 16, in main
wb = openpyxl.load_workbook("豆瓣TOP250电影.xlsx")
File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 311, in load_workbook
data_only, keep_links)
File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 126, in __init__
self.archive = _validate_archive(fn)
File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 98, in _validate_archive
archive = ZipFile(filename, r)
File "D:Anacondalibzipfile.py", line 1204, in __init__
self.fp = io.open(file, filemode)
FileNotFoundError: [Errno 2] No such file or directory: 豆瓣TOP250电影.xlsx
为什么我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 "", line 1, in runfile(C:/Users/coco/.spyder-py3/temp.py, wdir=C:/Users/coco/.spyder-py3) File "D:Anacondalibsite-packagesspyder_kernelscustomizespydercustomize.py", line 827, in runfile execfile(filename, namespace) File "D:Anacondalibsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile exec(compile(f.read(), filename, exec), namespace) File "C:/Users/coco/.spyder-py3/temp.py", line 26, in main() File "C:/Users/coco/.spyder-py3/temp.py", line 16, in main wb = openpyxl.load_workbook("豆瓣TOP250电影.xlsx") File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 311, in load_workbook data_only, keep_links) File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 126, in __init__ self.archive = _validate_archive(fn) File "D:Anacondalibsite-packagesopenpyxl eaderexcel.py", line 98, in _validate_archive archive = ZipFile(filename, r) File "D:Anacondalibzipfile.py", line 1204, in __init__ self.fp = io.open(file, filemode) FileNotFoundError: [Errno 2] No such file or directory: 豆瓣TOP250电影.xlsx