question

SrinivasJayaram-8124 avatar image
0 Votes"
SrinivasJayaram-8124 asked ·

WYSIWYG for Sharepoint graph explorer API

I am using microsoft sharepoint to host excel files on cloud. While for a project reason I am using Graph Explorer REST APIs to read and write contents to sharepoint.

Simple text scenarios:
For reading, I use the url of form

GRAPH_EXPLORER_URL
+ SITE_ID
+ "/drives/"
+ LIBRARY_ID
+ "/items/"
+ FILE_ID
+ "/workbook/worksheets('"
+ WORKSHEET + "')/range(address='" +
RANGE + "') "

I do get the contents in the range
and for write, I use the same URL, but with PATCH method, with the contents

{
values:[["1","2"]]
}



So the issue I have, is how to use WYSIWYG in API calls
Eg:
QNY24.png

This is from a WYSIWYG editor.
When I copy and paste this directly to sharepoint, I do get what I wanted
EO7Kh.png


But I am not sure, how to achieve this using API calls.
As when it considers this as a plain text, and even if I enter equivalent HTML code produced by
WYSIWYG in it, it considers as plain text.

I did explore https://docs.microsoft.com/en-us/graph/api/resources/rangefont?view=graph-rest-1.0
but, this applies to the whole cell and not to the section of texts in the cell.

Can anyone explain How to achieve this?


microsoft-graph-workbooks
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Deva-MSFT avatar image
0 Votes"
Deva-MSFT answered ·

The closest one i notice is that you can do this with whole cell using Graph APIs.

·
10 |1000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.