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
转载于:https://www.cnblogs.com/chunqing/p/9051997.html