While Adding the Row to the xlsx File I want to add it as Rich Text

Avadh Dobaria 0 Reputation points
2023-08-24T02:41:07.7633333+00:00

PATCH https://graph.microsoft.com/v1.0/me/drive/items/{id}/workbook/worksheets/{sheet-id}/range(address='A1:B2')

Content-type: application/json

{

"values" : [["Hello", "100"],["1/1/2016", null]],

"formulas" : [[null, null], [null, "=B1*2"]],

"numberFormat" : [[null,null], ["m-ddd", null]]

}

**While Using the Update Range Api If I want to add Value as Bold or Italic , So How would I do that Is there any api Available for it ?

For Example:
**
{

"values" : [["Hello", "100"],["1/1/2016", null]],

"formulas" : [[null, null], [null, "=B1*2"]],

"numberFormat" : [[null,null], ["m-ddd", null]]

}

For this JSON paylaod I want to add Hello as bold and 100 as italic or any other font style

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,449 questions
0 comments No comments
{count} votes