import pyexcel as ct

#先导入需要操作excel表格的模块

excel=ct.get_book_dict(file_name="D:\he.xlsx")

excel2=ct.get_book_dict(file_name="D:\eh.xlsx")

#获取两个表信息

vor=[]

wen=[]

excel.update(vor)

excel2.update(wen)

#合并两个表内容

for i in excel:

for j in excel2:

vor+=excel[i]

vor[:]+=excel2[j]

ct.save_as(array = vor[0:7], dest_file_name = "D:\wdl.xlsx")

#用循环遍历加入新的excelbiaoge