How to i programmatically change/set the sensitivity label of a excel document using C#.

Question

How to i programmatically change/set the sensitivity label of a excel document using C#.

Nikhil Nair 6

I have a shared location where I have a couple of Excel files. Now, I need to change the sensitivity label of those Excel files to 'external' along with the corresponding label ID. How can I achieve this in C#? Also, please advise me on whether I can set the sensitivity label while creating an Excel document from a byte array.

1 answer

Your answer

Answer 1

Jack J Jun 25,296

@Nikhil Nair ,

Please refer to the following Microsoft Learning to programmatically change/set the sensitivity label of a excel document using C#.

Quickstart: Set and get a sensitivity label (C#)

As for the question set the sensitivity label while creating an Excel document from a byte array, it seems that it is currently not supported by using above method.

Best Regards,

Jack

If the answer is helpful, please click "Accept Answer" and upvote it.

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.

Nikhil Nair 6 Reputation points

2023-06-22T11:15:50.27+00:00

@Jack J Jun I tried but its taking me to an another thread where it is requiring access token and authentication permissions (https://learn.microsoft.com/en-us/information-protection/develop/quick-app-initialization-csharp) . I need a solution where I can change the sensitive label on a word document which is stored in a folder not from an online place/sp location.
KARATZAS, ROBERT 5 Reputation points

2023-06-22T19:25:01.1766667+00:00

Bigger issue here, are things that are the output from some service. (i.e. I'm generating an Excel, .PDF, etc. from Power BI Report Server (on-premises), am I expected to make a call to Azure post-rendering, for every output generated? (when I have just a handful of labels?) (ditto for SSRS too)
Nikhil Nair 6 Reputation points

2023-06-23T06:35:12.24+00:00

Agree with KARATZAS, ROBERT.
Nikhil Nair 6 Reputation points

2023-06-23T06:35:33.6233333+00:00

agree with KARATZAS, ROBERT .
KARATZAS, ROBERT 5 Reputation points

2023-06-23T17:39:24.6233333+00:00

Don't get me wrong (on understanding the technical details presented here), but in the case of on-prem outputs, like PBIRS, Power Automate, etc.. I'd probably "mock" the consent delegate account needed with accounts which represent each service call type, and have the label values stored as part of that post-rendering process (applying the label(s).

Share via

How to i programmatically change/set the sensitivity label of a excel document using C#.

1 answer

Your answer