如何把Dataframe保存到EXCEL的不同SHEET中!

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版权协议,转载请附上原文出处链接和本声明。