Pandas导出Excel的时候出现openpyxl.utils.exceptions.IllegalCharacterError异常问题

导入xlsxwriter 库

data = pd.DataFrame.from_records(results)
data.to_excel(writer, sheet_name=sheet_title,
columns=columns, engine='xlsxwriter', index=False)

engine设置为“xlsxwriter”即可将特殊字符完美解决