User Profile
Sophus_Stein
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: How to update an Excel sheet in OneDrive from a Python script running locally?
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: { "error": { "code": "ItemNotFound", "message": "The requested resource doesn't exist.", "innerError": { "code": "itemNotFound", "message": "The requested resource doesn't exist.", "date": "2022-12-23T10:34:02", "request-id": "73ddfb08-ab4d-4c5b-b094-e199f408c608", "client-request-id": "53f7fb58-cf12-7a18-e9c4-88f6ec786849" } } } Will you be able to help me on this? Thanks23KViews0likes0CommentsRe: How to update an Excel sheet in OneDrive from a Python script running locally?
Hi traza8545, Thank you for your reply. My requirement is to update/write to an already existing excel worksheet. Will you be able to reply with the specific API for this action? Apologize for the inconvinience but im not able to find an API for update purposes.23KViews0likes0CommentsHow to update an Excel sheet in OneDrive from a Python script running locally?
Hi, I have a python3 script which generates a particular set of data that gets updated to a locally stored Csv/Excel file. I am using Openpyxl package in python to achieve the same. But the requirement has changed such that the data should be available in a shared platform were multiple personnals can view, edit and export as and when required. This lead to the idea of creating an excel sheet in the microsoft office 365 Excel and updating the sheet so that all the requirements can be met. Unfortunately, I couldnt find any documentation or tutorial that lets someone update an Excel sheet in office 365 even though i spent a considerable amount of time searching online. My requirement is to have an API that can take the row in some format and update it to the Excel sheet under my login. Please help me find a solution to this question or any other alternative that would help to achieve the matter at hand.Solved
Recent Blog Articles
No content to show