4,375 questions
Programmatically read restricted excel file
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 65%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
Rando
5
Reputation points
I have a series of Excel's that are protected by the business. I have the required permissions to view the file manually however I would like to create a programmatic way to extract the data from these excels. I have tried using Python to read and extract the data from these Excels but have encountered the applied protection restrictions. Is there a way I can access these files programmatically? Maybe using Azure permissions?
Microsoft 365 and Office Development Other
Microsoft 365 and Office Excel For business Windows
3,888 questions
{count} vote
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(105.60000000000001, 46%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
DANIEL COHEN 0 Reputation points2024-05-22T15:18:53.94+00:00 Further to Rando's question, the user interface of restricting access using the built in agent offers this screen:
There is a tick box that indicates that access can be done programmatically. Can you please elaborate on what access is allowed, and how it can be done?
Sign in to comment
Sign in to answer