#encoding=utf-8 import os import xlrd import xdrlib,sys import xlwt def mv_wav_file(filename): new_name = "A+" + filename + ".wav" old_name = filename + ".wav" os.rename(r'C:\Users\weifu\Desktop\S0999\\'+old_name,r'C:\Users\weifu\Desktop\S0999\\'+new_name+".wav") def read_excel(): data =xlrd.open_workbook(r'C:\Users\weifu\Desktop\S0999\source_files.xls') table = data.sheet_by_index(0) nrows = table.nrows ncols = table.ncols for i in range(nrows): print(str(table.row(i)[0].value)+":"+str(table.row(i)[1].value)) if(str(table.row(i)[1].value)=="A"): mv_wav_file(str(table.row(i)[0].value)) read_excel()
发表评论