多个表单数据自动汇总

#python3读写excel

from openpyxl import Workbook
from openpyxl import load_workbook
import openpyxl


#读取数据
wb0=openpyxl.load_workbook('da.xlsx')#da
wb10=openpyxl.load_workbook('dat.xlsx')
wb1=openpyxl.load_workbook('data.xlsx')
wb2=openpyxl.load_workbook('test.xlsx')总表

sheets0=wb0.get_sheet_names()#获取sheet页#1
sheets10=wb1.get_sheet_names()#获取sheet页2
sheets1=wb1.get_sheet_names()#获取sheet页3

sheets2=wb2.get_sheet_names()#总表

sheet0=wb0.get_sheet_by_name(sheets1[0])#1
sheet1=wb1.get_sheet_by_name(sheets1[0])#2
sheet10=wb10.get_sheet_by_name(sheets1[0])#3

sheet2=wb2.get_sheet_by_name(sheets2[0])#总表1
sheet33=wb2.get_sheet_by_name(sheets2[1])#总表2
sheet3=wb2.get_sheet_by_name(sheets2[2])#总表3


max_row=sheet1.max_row#最大行数
max_column=sheet1.max_column#最大列数

for m in range(1,max_row+1):
    for n in range(97,97+max_column):#chr(97)='a'
        n=chr(n)#ASCII字符
        i='%s%d'%(n,m)#单元格编号
        cell0 = sheet0[i].value  # 获取data单元格数据1
        cell1=sheet1[i].value#获取data单元格数据2
        cell10 = sheet10[i].value  # 获取data单元格数据3

        sheet2[i].value=cell1#赋值到test单元格总表1
        sheet3[i].value = cell0  # 赋值到test单元格总表3
        sheet33[i].value = cell10  # 赋值到test单元格总表2

wb2.save('test.xlsx')#保存数据
wb1.close()#关闭excel
wb2.close()