以下代码实现在excel新建sheet 不会被覆盖
writer = pd.ExcelWriter('path',mode='a', engine='openpyxl',if_sheet_exists='new')
statistics_df.to_excel(writer, sheet_name='xxxx')
writer.save()
writer.close()
以下代码实现在excel新建sheet 不会被覆盖
writer = pd.ExcelWriter('path',mode='a', engine='openpyxl',if_sheet_exists='new')
statistics_df.to_excel(writer, sheet_name='xxxx')
writer.save()
writer.close()