Editing an Excel file without tables using MSGraph API

Dennis Tran 0 Reputation points
2024-06-11T07:50:01.5933333+00:00

Hi all,

I want to use the MSGraph API in order to edit excel files on Sharepoint. I now see that you need a workbookTable_id in order to use the python function:

result = await graph_client.drives.by_drive_id('drive-id').items.by_drive_item_id('driveItem-id').workbook.tables.by_workbook_table_id('workbookTable-id').rows.by_workbook_table_row_id('workbookTableRow-id').patch(request_body)

The workbook we work with however, do not always contain tables since it acts weird in the browser version (which most of my colleagues use).

My question now is, is having a table mandatory in order to use MSGraph API and if so, is it maybe possible to read the excel file using the MSGraph API and convert it into a Pandas dataframe? Because then, after editing, I can upload it back on Sharepoint.

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
11,069 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,606 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,648 questions
0 comments No comments
{count} votes