MS Graph Update/Set Excel value in a cell

Question

I haven't found any example to update/insert a value in one cell of an specific worksheet with Microsoft Graph API.

Is this in general possible?

Kind regards, Martin

Answer 1

It is possible, using single cell reference. Send PATCH request to (for example) one drive workbook:

 https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets('one_of_your_worksheet_name')/cell(row=0,column=0)

Request body example:

{
 "values": [ ["I am cell A:1"] ],
 "valueTypes": [ ["String"]]
}