题卡归档记录

import xlrd, os, shutil

from tkinter import filedialog





class Img():

def __init__(self):

super().__init__()



def guidang(self):

excel_path = filedialog.askopenfilenames(title='选择考生成绩', filetypes=[('Excel', '*.xls')])

img_old_path = filedialog.askdirectory(title='选择题卡图片所在路径')

img_save_path = filedialog.askdirectory(title='选择题卡保存路径')

for file_name in excel_path:

dir_name = os.path.basename(file_name).split('.')[0]

if not os.path.exists(img_save_path + '/' + dir_name):

os.makedirs(img_save_path + '/' + dir_name)

save_path = img_save_path + '/' + dir_name

# print(file_name)

sheet = xlrd.open_workbook(file_name).sheet_by_index(0)

total_num = sheet.nrows

for i in range(1, total_num):

row = sheet.row_values(i)

exam_no = str(row[1]).split('.')[0]

if os.path.exists(img_old_path + '/' + exam_no + '_A.jpg'):

shutil.copy(img_old_path + '/' + exam_no + '_A.jpg', save_path + '/' + exam_no + '_A.jpg')

else:

print(exam_no + '_A图片不存在')

if os.path.exists(img_old_path + '/' + exam_no + '_B.jpg'):

shutil.copy(img_old_path + '/' + exam_no + '_B.jpg', save_path + '/' + exam_no + '_B.jpg')

else:

print(exam_no + '_B图片不存在')





if __name__ == '__main__':

m = Img()

m.guidang()