升级了Python 到3.10,然后pandas写的ExcelWriter也跟着升级了,以下是版本:

pandas=1.5.0

xlwt==1.3.0

然后是执行原来的导数据到Excel的代码报错警告:

 FutureWarning: save is not part of the public API, usage can give in unexpected results and will be removed in a future version
 

writer = pd.ExcelWriter("excel_path.xlsx")
..... 
writer.save()

解决办法:

升级之后,writer.save()接口已经私有化,调用close()即可。

writer = pd.ExcelWriter("excel_path.xlsx")
#..... 
#writer.save()
writer.close()

close()接口源码:

查看writer.close()接口,里面源码会调用save()并执行关闭接口。

Logo

为开发者提供学习成长、分享交流、生态实践、资源工具等服务,帮助开发者快速成长。

更多推荐