Can you read cells using Graph API from in a worksheet that is protected ?

Question

Hi there

I am trying to integrate Excel via SharePoint/OneDrive into monday.com. All I need to do is read certain cells and plug them into monday. However, the files I will be reading from have columns that are protected (in the near future I'd like to restrict columns on a per-person basis) and from my research there there doesn't seem to be away to read protected cells. It's very vague though, so I just need clarity. Again, all I need to do is read, not write to the sheet or modify its contents and that distinction is where lines get blurred.

Any help would be appreciated :)

Answer 1

Based on the information available, the Microsoft Graph API allows for a range of operations on Excel files, including reading and modifying data in Excel documents. However, it is important to note that if a worksheet is protected, certain operations may not be possible. The API includes features for range and worksheet protection, and it is likely that reading cells from a protected worksheet would be restricted. For more detailed information on the capabilities and limitations regarding protected worksheets, you can refer to the official Microsoft Graph documentation or explore the Excel API endpoints provided by the Graph API.

https://learn.microsoft.com/en-us/graph/api/worksheetprotection-protect?view=graph-rest-1.0

Hope this helps.

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".