Hi,
I am testing using the Microsoft Graph Explorer, and I can successfully add a new worksheet to a workbook using the REST API, but is it possible to also add data to the new empty worksheet? There doesn't seem to be a POST option for new rows in a worksheet.
Alternatively, it seems I can add rows to a Table within the spreadsheet (https://docs.microsoft.com/en-us/graph/excel-write-to-workbook and https://docs.microsoft.com/en-us/graph/api/table-post-rows?view=graph-rest-1.0&tabs=http).
However, when I add a table to a spreadsheet, and then use the GET command https://graph.microsoft.com/v1.0/me/drive/items/{drive-item-id}/workbook/worksheets/{sheet-id}/tables
I get the following error, even though the worksheet does contain a table:
{
"error": {
"code": "ItemNotFound",
"message": "The requested resource doesn't exist.",
"innerError": {
"code": "itemNotFound",
"message": "The requested resource doesn't exist.",
"date": "2021-02-15T01:47:03",
"request-id": "4d499bbd-82ca-4fb6-8e18-312bffa24386",
"client-request-id": "a3073642-7c42-de6a-463e-d9e25c42b340"
}
}
}
I also get this error when I try and POST data to the table, using both /rows/add and /columns
Appreciate any help I can get with this.
Thanks
Ian