Error while opening .xlsx file after openpyxl and interaction with that file
Created originally on Bitbucket by vilniuspaul (Paulius V)
Hello, All, I have two files: smth_update.xlsx(more then one sheet with internal links) and smth_data.xlsx(one sheet). My python script is pulling out data from smth_update.xlsx file to pandas dataframe, it filters rows which have 'yes' in one of the columns and then - cell by cell writes filtered values to smth_data.xlsx file and saves it, then in smth_update.xlsx file changes all 'yes' values to 'no' and saves those changes. After code stops running, when I try to open one of those files (both) I get an error (shown in attached picture). Could someone please help me with this issue. Thank you,
Best regards,
Paul
Attachments: Capture