Sharepoint Excel Automation from Python : File fails to replace/upload when the Excel sheet is open in editing mode/desktop mode

[saistesla]

Hi All,

I have done sharepoint excel automation from Jupyter notebook (web based). It has access to company's database, it fetches latest data, reads sharepoint excel, appends the dataframe into excel and uploads the excel back to sharepoint.

However, when uploading, it fails whenever the excel is opened in editing/desktop mode, and works if its viewing mode.

Is there any setting in Azure app or sharepoint or may be python code that forces upload even if user is using?

Please guide. Thanks