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

[Dennis Lee Bieber]

On Fri, 11 Feb 2022 20:37:57 +0100, "Peter J. Holzer" <hjp-python at hjp.at>
declaimed the following:

>Interestingly, Excel did have the ability for multiple users editing the
>same file at some time (maybe early 2000s? Way before Google docs or
>Office 365). It had to be explicitely enabled and it didn't work very
>reliably (at least not with Samba as file servers), so we never really
>used it but it is clear that somebody at MS thought that users needed or
>at least wanted that ability.

	A quick Google does find mention of "shared workbooks":
https://docs.microsoft.com/en-us/office/troubleshoot/excel/use-shared-workbook
https://support.microsoft.com/en-us/office/what-happened-to-shared-workbooks-150fc205-990a-4763-82f1-6c259303fe05

	The preferred mode requires "Microsoft 365 subscription" and latest
Office version:
https://support.microsoft.com/en-us/office/collaborate-on-excel-workbooks-at-the-same-time-with-co-authoring-7152aa8b-b791-414c-a3bb-3024e46fb104

	However -- the key feature is that these are Excel-Excel(-Excel...)
operations (and the co-author mode needs M$ subscription and use of
OneDrive cloud storage). 

	Most Python libraries are working directly with the Excel format data
file, not by running Excel. 

	Caveat: there is a product that appears to use the Excel component API
to control Excel itself, not just read/write xls(*) files -- so it might
understand the older shared workbook mode, but I'd recommend a detailed
study of the API and the sharing operations first:
https://www.xlwings.org/
https://docs.xlwings.org/en/stable/
"""
xlwings (Open Source) is a BSD-licensed Python library that makes it easy
to call Python from Excel and vice versa:
    *	Scripting: Automate/interact with Excel from Python using a syntax
close to VBA.
    *	Macros: Replace VBA macros with clean and powerful Python code.
    *	UDFs: Write User Defined Functions (UDFs) in Python (Windows only).
"""

	If running under Windows, similar capability should be possible using
the win32py (or whatever the current name is) extension... Or with more
difficulty, ctypes!


-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
	wlfraed at ix.netcom.com    http://wlfraed.microdiversity.freeddns.org/