Forum Discussion
How to update an Excel sheet in OneDrive from a Python script running locally?
- Dec 21, 2022
You can use the Microsoft Graph API to update an Excel sheet stored in OneDrive from a Python script running locally. Here's an example of how you can do this:
-
First, you will need to register your app in the Azure portal and get the necessary credentials (client ID and client secret) to authenticate your app with the Microsoft Graph API.
-
Next, install the requests and adal libraries in your Python environment:
- Then, use the adal library to obtain an access token for the Microsoft Graph API:
- Now you can use the requests library to make API calls to the Microsoft Graph API. For example, to update a cell in an Excel sheet stored in OneDrive, you can use the PATCH method and pass the access token in the Authorization header:
I hope this helps! Let me know if you have any questions.
(external link removed by moderator) -
You can use the Microsoft Graph API to update an Excel sheet stored in OneDrive from a Python script running locally. Here's an example of how you can do this:
-
First, you will need to register your app in the Azure portal and get the necessary credentials (client ID and client secret) to authenticate your app with the Microsoft Graph API.
-
Next, install the requests and adal libraries in your Python environment:
- Then, use the adal library to obtain an access token for the Microsoft Graph API:
- Now you can use the requests library to make API calls to the Microsoft Graph API. For example, to update a cell in an Excel sheet stored in OneDrive, you can use the PATCH method and pass the access token in the Authorization header:
I hope this helps! Let me know if you have any questions.
Hi traza8545,
I was able to view all the items present in my ondrive using a Graph API https://graph.microsoft.com/v1.0/me/drive/root/children/sites.
Also found another API to add rows to an excel sheet: https://graph.microsoft.com/v1.0/drives/{drive-id}/items/{item-id}/workbook/worksheets/Sheet1/tables/{table-id}/rows/add
But it keeps giving me the error mentioned below: