sheet_name = f'{self.date_selected.year}年{self.date_selected.month}月'
writer = pd.ExcelWriter(f'{self.path}\\门店助手\\门店排班表.xlsx')
book = load_workbook(writer.path)
if sheet_name in book.sheetnames:
del book[sheet_name]
writer.book = book
self.table.to_excel(writer, sheet_name)
writer.save()
writer.close()
QMessageBox.information(self, "提示信息", "保存成功!", QMessageBox.Ok)
self.table.to_excel(writer, f'{self.date_selected.year}年{self.date_selected.month}月')
writer.save()
writer.close()
版权声明:本文为weixin_49096826原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接和本声明。