1、把excel里文件名那一列复制,粘进一个空白的文本文件,命名为filelist.txt,上传到服务器。
2、在服务器上使用脚本导出,python脚本:
#! python #coding:utf-8 ##!/usr/bin/python # Filename : fileCp.py import sys import os import shutil fileList='filelist.txt' targetDir='files' filedir = open(fileList) line = filedir.readline() log = open('running.log','w') while line: line = line.strip(' '); basename = os.path.basename(line) exists = os.path.exists(line) if exists : print 'copy '+line+' to '+os.getcwd()+'/'+targetDir+'/'+basename log.write('copy '+line+' to '+os.getcwd()+'/'+targetDir+'/'+basename+' ') shutil.copy(line,targetDir+'/'+basename) else: print line+' not exists' log.write(line+' not exists'+' ') line = filedir.readline() log.close()