保存后,Excel文件中的所有工作表都将被删除,但我写入新数据的工作表除外,如何修复
def teach_add_3():
with pd.ExcelWriter('bd1.xlsx', engine='openpyxl', mode='a') as writer:
df.to_excel(writer, sheet_name='teachers')
teacher = input("Enter teacher: ")
subject = input("Enter subject: ")
df.loc[index, 'Преподаватели'] = teacher
df.loc[index, 'Предметы'] = subject
df.to_excel(writer, sheet_name='teachers')
在本例中,我们将使用如下“附加”模式打开自己的ExcelWriter:
确保安装
openpyxl
模块相关问题 更多 >
编程相关推荐