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()