说明:path是你所有文件存放的目录,先去循环所有的文件内容,然后写入到test.xls文件里


import os
path = 'file'
# path=r'D:\file'
for filename in os.listdir(path):
    fullname = os.path.join(path, filename)
    # 如果是linux系统导出来的数据用utf-8,如果是windows则用gbk
    f1 = open(fullname, encoding='gbk')
    for i in f1:
        if "电子邮箱" in i:
            continue
        with open('test.xls',encoding='gbk',mode='a+')as f2:
            f2.write(i)
            f2.close()
    f1.close()