Can you edit MS Teams documents (spreadsheets specifically) with Python code WHILE others continue collaborating on the Document

Question

Desired Output: Python script that fills cells in spreadsheet that others are collaborating on simultaneously. This would be a Teams/Sharepoint document.

Due Diligence:

https://techcommunity.microsoft.com/t5/teams-developer/programatically-accessing-files-shared-in-teams/m-p/763916

https://stackoverflow.com/questions/57103597/grabbing-files-from-microsoft-teams-using-python

---

In short, I want to know if there is a way my script could 'enter' a (Microsoft Teams) spreadsheet (and manipulate data) the same/similar to anyone else collaborating on the same document together (simultaneously).

Answer 1

Microsoft teams files stores in sharepoint. if you know the location you can access same sharepoint site using powershell. Please go through the below links. LInk1
link2
link3
Build script based on your requirement.