为什么pandas to_excel函数有时编码错误?

Question

代码

import pandas as pd
error_code_link_lst = []
error_code_link_lst.append('twdJK7dzQR_x298_x298_x49147_x')
error_code_link_lst.append('1665207170810_x828_x1470_x745770_x.jpg')  # _x1470_     ᑰ
error_code_link_lst.append('h4fdn32sjG_x593_x593_x199560_x')
error_code_link_lst.append('xEQpZ7JjkZ_x288_x288_x3108_x')            # _x3108_     ㄈ
error_code_link_lst.append('SGkZYZKCRR_x298_x298_x49147_x')
df = pd.DataFrame()
df['link'] = [i for i in error_code_link_lst]
for i in df['link']:
print(i)
df.to_excel('error.xlsx', index=None)

终端显示正确:

twdJK7dzQR_x298_x298_x49147_x
1665207170810_x828_x1470_x745770_x.jpg
h4fdn32sjG_x593_x593_x199560_x
xEQpZ7JjkZ_x288_x288_x3108_x
SGkZYZKCRR_x298_x298_x49147_x

但是在xlsx文件中，它看起来像是在一个错误的编码

<表类>链接tbody><<tr>twdJK7dzQR_x298_x298_x49147_x1665207170810 _x828ᑰx745770_x.jpgh4fdn32sjG_x593_x593_x199560_xxEQpZ7JjkZ_x288_x288ㄈxSGkZYZKCRR_x298_x298_x49147_x

尝试在to_excel函数中指定encoding='utf8'作为参数。Excel截图