python批量合并excel文件.zip

# -*- coding: utf-8 -*- from openpyxl import load_workbook, Workbook import glob path = "C:\\Users\\Administrator\\Desktop\\bbb" #修改（存放excel文件的路径） new_workbook = Workbook() new_sheet = new_workbook.active #获取活动表 # 用flag变量明确新表是否已经添加了表头，只要添加过一次就无须重复再添加 flag = 0 for file in glob.glob(path + '/*.xlsx'): #glob：可用通配符匹配路径 workbook = load_workbook(file) #加载excel文件 sheet = workbook.active #获取活动表 coloum_A = sheet['A'] #从A列开始 row_lst = [] for cell in coloum_A: if cell: print(cell.row) row_lst.append(cell.row) if not flag: header = sheet[1] header_lst = [] for cell in header: header_lst.append(cell.value) new_sheet.append(header_lst) flag = 1 for row in row_lst: data_lst = [] for cell in sheet[row]: data_lst.append(cell.value) new_sheet.append(data_lst) new_workbook.save(path + '/' + '符合筛选条件的新表.xlsx') #意思就是C:\Users\Administrator\Desktop\bbb\符合筛选条件的新表.xlsx