python 報錯:raise IllegalCharacterError(f"{value} cannot be used in worksheets.") openpyxl.utils.exceptions.IllegalCharacterError

myrj發表於2024-07-20

報錯:

raise IllegalCharacterError(f"{value} cannot be used in worksheets.")
openpyxl.utils.exceptions.IllegalCharacterError: 圖爾蓀託合提麥合蘇提 cannot be used in worksheets.

出錯行:df.to_excel("i:\\te3\\"+bb,index=False)

解決方法:df.to_excel("i:\\te3\\"+bb,index=False,engine="xlsxwriter")

相關文章