只有少数excel文件没有复制到目标

Question

我有一个文件夹，其中有586 excel文件与.xls和.xlsx格式，然后我使用shutil和我转移文件到目标，如下面的代码。你知道吗

import shutil
import glob

for filename in glob.glob('C:\\Users\\Documents\\sample_folder\\**\\**', recursive=True):
    if filename.endswith('.xlsx') or filename.endswith('.xls'):
    shutil.copy(filename,"C:\\Users\\Documents\\excel-files")

事情进展顺利，398个文件成功地传输到目标，但我没有得到剩余的文件，它显示了一个错误，如

File "C:\Users\AppData\Local\Programs\Python\Python36-32\lib\shutil.py", line 121, in copyfile with open(dst, 'wb') as fdst: PermissionError: [Errno 13] Permission denied: 'C:\Users\Documents\excel-files\XYZ 1310_template.xlsx'

Answer 1

我很确定你的shutil（部分代码不是正确的方法）。你知道吗

Your just trying to copy the filename which is a variable and has names of the files in it.

whereas shutil.copy("src","dest") is required src, is from the source not the filename there.

  shutil.copy("src"+filename,"C:\\Users\\Documents\\excel-files")