[python]raise IllegalCharacterErroropenpyxl.utils.exceptions.IllegalCharacterError

import os
import pandas as pd
source_dir="/Users/kelisiduofu/note/知网/4、其他/Meta表数据清洗/结果2/"
write_dir="/Users/kelisiduofu/note/知网/4、其他/Meta表数据清洗/res.xlsx"
writer=pd.ExcelWriter(write_dir,engine='openpyxl') #指定生成的excel路径和名称

for root, dirs, files in os.walk(source_dir):
    print(files) #当前路径下所有非目录子文件的文件名
    for file in files:
        print(source_dir+file)
        tmp=pd.read_csv(source_dir+file, sep="\t", encoding="utf-8", low_memory=False, header=None)
        tmp.to_excel(excel_writer=writer, sheet_name=file, index = False) #如何不设置index = False,则第一列为空列、
    writer.close()

点进来,找了半天实在找不到办法..那就暴力的解决问题吧,最起码运行完了,输出结果是对的

 把这两行注释掉即可