保存后,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')
在这种情况下,我们将使用"附加";模式如下:
with pd.ExcelWriter('bd1.xlsx', engine='openpyxl', mode='a') as writer:
df.to_excel(writer, sheet_name='teachers')
确保安装openpyxl
模块。
pip install openpyxl