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

[MRAB]

On 2022-02-09 12:45, Christian Gollwitzer wrote:
> Am 09.02.22 um 08:46 schrieb NArshad:
>> 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:
> 
>> PermissionError: [Errno 13] Permission denied: 'Abc.xlsx'
>> 
>> 
>> 
>> What to do to correct this error? I have already searched on google search many times but no solution was found.
> 
> It's impossible. Excel locks the file deliberately when it is open, so
> that you can't overwrite it from a different program. Otherwise, the
> file could become inconsistent.
> 
It's the same the other way too; you can't open the file in Excel while 
Python has it open.

> The correct way to handle it in the GUI is to tell the user via a
> message box that the file is open and can't be written.
> 
> An alternative to writing the file directly would be that you remote
> control Excel; I think it provides a DDE API:
> https://support.microsoft.com/en-us/office/dde-function-79e8b21c-2054-4b48-9ceb-d2cf38dc17f9
>