Can you access a password protected Excel file saved on a SharePoint site using GRAPH API?

Tim Moffatt 20 Reputation points
2023-07-10T20:56:17.2533333+00:00

I have been able to use this syntax in the Graph API to access the data ins a table in an excel file so long as the file does not have a password protecting it.

https://graph.microsoft.com/v1.0/sites/<SITEID>/drives/<FOLDERID>/items/<FILEID>/workbook/tables/<TABLEID>/rows

But When I use that same syntax on a file that does have a password protecting the workbook I get an error that the workbook has a password and I cannot access it. So what I need is a way to modify the API URL above to allow me to enter the password for the workbook.

Is there a way to add some kind of additional parameter to the URL to allow me to enter the password & unlock the workbook when I'm getting the data out of the table using the Graph API?

Microsoft Graph
Microsoft Graph
A Microsoft programmability model that exposes REST APIs and client libraries to access data on Microsoft 365 services.
10,013 questions
Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,328 questions
SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,210 questions
0 comments No comments
{count} votes

Accepted answer
  1. ChengFeng - MSFT 4,995 Reputation points Microsoft Vendor
    2023-07-11T06:35:25.4233333+00:00

    HI@Tim Moffatt

    Thanks for letting us know your user experience. According to your case description, I do understand how frustrated you are now.

     

    When I received the case, I searched a lot of documents did a lot of researches. And I feel regretful to inform you that it is not possible to modify the content of password-protected Excel files using the Graph API?

     

    And I noticed that some end users have also proposed the same request, it is highly recommended that you can vote this ticket. Many features of our current products are designed and upgraded based on customers’ feedback. With requirements like this increase, the problem may well be released in the future. Thanks for your understanding.

     

    feedback


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

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    Best Regards

    Cheng Feng


0 additional answers

Sort by: Most helpful