openpyxl.utils.exceptions.IllegalCharacterError 解决办法: 下载xlsxwriter库,然后to_excel时,令engine='xlsxwriter’即可 pip install xlsxwriter import xlsxwriter df.to_excel('./file_out.xlsx', engine='xlsxwriter', index=False)