pandas导出到Excel报URLS数量超出65530警告

1. 使用如下方法，记得writer.close()关闭文件

writer = pd.ExcelWriter('xxxx.xlsx',engine='xlsxwriter',engine_kwargs={'options': {'strings_to_urls': False}})
df_all.to_excel(writer, index=False)
writer.close()

2. 如果报错如下：

TypeError: init() got an unexpected keyword argument 'engine_kwargs

3. 换用如下方法：在初始化writer后使用writer.book.strings_to_urls = False  # 关闭自动转换功能

writer = pd.ExcelWriter('xxxx.xlsx',engine='xlsxwriter',engine_kwargs={'options': {'strings_to_urls': False}})
writer.book.strings_to_urls = False  # 关闭自动转换功能
df_all.to_excel(writer, index=False)
writer.close()