Asking warning message after saving workbook in openpyxl

Issue #640 invalid
created an issue

wb_write = openpyxl.load_workbook(file_path)

first_sheet = wb_write.get_sheet_names()[0]

ws = wb_write.get_sheet_by_name(first_sheet)

here row=1 ,column= 5

ws.cell(row=i, column=mt_mac_id_column).value = MT_MAC

After writing data into xlsx file and saved in the same workbook.

Opened manually xlsx file in windows Changes are reflected in xlsx file but while closing the xlsx file it is asking for confirmation like "do you want to save the changes you made to file"

Why it is asking for confirmation? How do I avoid this warning?

Comments (3)

  1. CharlieC

    Excel saves files slightly differently than openpyxl does. For example it saves the calculated values of formulae. So it is common for Excel to make changes to files created by openpyxl but this is not a bug.

  2. Log in to comment