Python之openpyxl合并Excel文档

1.代码

#coding=utf-8
import os
import glob
 
import openpyxl
 
def merge_xlsx_files(xlsx_files):
    wb = openpyxl.load_workbook(xlsx_files[0])
    ws = wb.active
    ws.title = "merge_result"
     
    for filename in xlsx_files[1:]:
        workbook = openpyxl.load_workbook(filename)
        sheet = workbook.active
        for row in sheet.iter_rows(min_row=2):
            values = [cell.value for cell in row]
            ws.append(values)        
    return wb
     
def get_all_xlsx_files(path):
    xlsx_files = glob.glob(os.path.join(path,'*.xlsx'))
    sorted(xlsx_files,key=str.lower)
    return xlsx_files
     
def main():
    xlsx_files = get_all_xlsx_files('E:\py')
    wb = merge_xlsx_files(xlsx_files)
    wb.save('merge_form.xlsx')
      
if __name__ == '__main__':
    main()