How use Api to format cell in Excel

Question

I'm testing a api to format cells, i need fill cells with an color an change the font color. I'm using this api for fill the cells, this api response is 200 but the worksheet doesn't change. Can you tell me why is wrong in this request?

curl --location --request PATCH 'https://graph.microsoft.com/v1.0/me/drive/items/01EO6SZSSLUJF4YHMCERBKKJE4QB72GM6L/workbook/worksheets('\''Planilha1'\'')/range(address='\''A1:A2'\'')/format' \ --header 'Authorization: ${myToken}' \ --header 'Content-Type: application/json' \ --data '{     "values": [         {             "range": "A1:A2",             "format": {                 "fill": {                         "color": "#FFFFFF"                 }             }         }     ] }'

Answer 1

Hello Leonardo Ribeiro Bet,

Thanks for reaching out. Does the issue occur if you select a different color for the fill for example #FF0000? #FFFFFF code is for the color white.

Answer 2

Hello Leonardo Ribeiro Bet,

Thanks for the update. This issue will require further investigation. I would suggest opening a support ticket for the issue.

Thanks.