[python-uk] PermissionError: [Errno 13] Permission denied: 'Abc.xlsx'

When I enter data using Tkinter form in an Excel file when the excel file is closed there is no error but when I enter data using Tkinter form when the excel is already open following error comes: Exception in Tkinter callback Traceback (most recent call last): File "C:\Users\Dani Brothers\Anaco

Re: [python-uk] PermissionError: [Errno 13] Permission denied: 'Abc.xlsx'

Responding to list in case this helps someone else as well: When you open a file in Window ("when the excel is already open following error") there will generally (or maybe always, I don't recall precisely) be an exclusive lock taken on the file. This means that while another application has a

Re: [python-uk] PermissionError: [Errno 13] Permission denied: 'Abc.xlsx'

You might consider the idea that a script which modifies the spreadsheet should read from one file, and write to a different one. This might not fit your scenario, but if it does, then the write will never encounter the locking exception. On Wed, Feb 9, 2022, at 03:58, SW wrote: > Responding to