chrisd37's avatar
chrisd37
Copper Contributor
Jul 14, 2023
Status:
New

Azure/Graph add rows to protected Excel worksheet

I'm using an Azure web app to add a row to an Excel workbook worksheet table.  This works fine, adding rows as needed, right up till I turn on worksheet protection for this worksheet.

 

My Azure account was created by the same user (email address) as my Office 365 Business Basic account (the one that is currently $6/month), so Excel ought to see my row being inserted by the Workbook owner.

 

I enable protection and tick the "add rows" box to allow rows being added.  I invite "myself" for sharing, using the e-mail address that is the Office 365 Business license owner and also the Azure app owner.

 

Soon as worksheet protection is enabled, the azure app gets 403 forbidden when it attempts to add a row.  Turning worksheet protection back off, the azure app resumse inserting rows just fine.

 

My goal here is to all the Azure App and Office Business owner to add rows to a worksheet of defined structure, and to prevent humans from breaking the structure and thus breaking the app. (While i realize a database would be the preferred method for this scenario, with Excel reading its worksheet table data from the database, I don't get to make that call.  "Excel only" is a requirement I have to work with)

 

I don't care about password protection.  I just want the owner to be able to add rows, and for humans the workbook file is shared with, they need to be able to work on other worksheets to do their pivot tables and whatever all else, using the data worksheet as their source, but never being able to change the data worksheet.

 

I think this functionality does not exist and/or does not work, but maybe my azure app identity as seen by Excel isn't the Excel sheet owner?  If that's the case, my idea submission here will be for the 403 forbidden response, or maybe "access denied" log  on the Excel side, to report attempted accesse where permission was denied, and to supply the attempted credential.  That way it would be apparent if the Azure app connected via Graph lacks "owner" status and perhaps that my worksheet sharing grant on the azure app owner email address isn't "enough" for the azure app to get its job done, adding rows to a protected worksheet where "add rows" is set as being permitted.

No CommentsBe the first to comment