Excel Python多表合并处理，跨表取列

Excel Python多表数据合并，跨表取列

import openpyxl as xl
wb = xl.load_workbook('E:/testE/hahj.xlsx') # 加载excel文件
wb2 = xl.load_workbook('E:/testE/hahj2.xlsx') # 加载excel文件2


wb.create_sheet('新建sheet页', index = 2) # 新建sheet
listSheet = wb.sheetnames  # 加载所有的sheet页  页名称
listSheet2 = wb2.sheetnames  # 加载2表  页名称

sheet3 = wb2[listSheet[1]]  # 旧表

sheet_number = len(wb.worksheets) #多少表
# print(sheet_number)
sheet = wb[listSheet[0]]  # 旧表
sheet1 = wb[listSheet[1]]  # 旧表
sheet2 = wb[listSheet[2]]  # 新表


# 复制sheet某列  第1行开始    sheet.max_row+1表示多少行
for i in range(1, sheet.max_row +1):
    sheet2['A{0}'.format(i)].value = sheet['A{0}'.format(i)].value
    sheet2['B{0}'.format(i)].value = sheet['B{0}'.format(i)].value
    sheet2['C{0}'.format(i)].value = sheet1['B{0}'.format(i)].value
    sheet2['D{0}'.format(i)].value = sheet3['B{0}'.format(i)].value
#
 for i in range(0, sheet_number - 1): #删除总表数-1 的sheet
     wb.remove(wb[listSheet[i]])

# for i in range(1, sheet2.max_row + 1):
#    sheet2['C{0}'.format(i)] = '=SUBSTITUTE(A{0},"替换我吧",B{1})'.format(i, i)
wb.save('E:/testE/1.xlsx')
wb.close()

鸣谢: GalicFeather .