result = [] # 这个方法是搜寻上面目录下的所有Excel文件 defsearch(dirname=dirname, filename=""): for item in os.listdir(dirname): item_path = os.path.join(dirname, item) if os.path.isdir(item_path): # 这里用了递归, search(item_path, filename) elif os.path.isfile(item_path): if filename in item: global result # 很简单吧,不需要解释了,好累你直接拷下来就行了 result.append(item_path)
# 主方法,py文件就是从这里执行的 if __name__ == '__main__': # 调用方法 search(dirname, filename) # 创建写Excel文件的对象 workbook = xlwt.Workbook() # 创建sheet worksheet = workbook.add_sheet('test') a = 0 for item in result: # print(item) # 获取数据 book = xlrd.open_workbook(item) sheet = book.sheet_by_index(0) # 获取值 value = sheet.col_values(colx=0) # 获取值 value1 = sheet.row_values(rowx=2); # 读取客户编码
for i inrange(len(value)): # print(i) a = a + 1 print(value[i]) # 写入 worksheet.write(a,0,value[i]) temp = item.replace('D:\File\Mixed\用户文件夹\桌面\mz报表\合肥市直主副卡记录(1)\合肥市直主副卡记录\\', '') # 写入 worksheet.write(a,1,value1) # 写入 worksheet.write(a,2,temp) # 保存文件 workbook.save(r'D:\File\Mixed\用户文件夹\桌面\mz报表\excelwrite1.xls')