Home Create Excel document with EPPlus and assign user with Information Rights Management
Reply: 0

Create Excel document with EPPlus and assign user with Information Rights Management

user43381
1#
user43381 Published in September 19, 2018, 9:08 am

Is there a way, using EPPlus, to create an Excel document and protect it's content so that only specific user(s) can access the information inside it. This is possible when manually creating an Excel document and using the IRM capabilities within Excel, but I've not yet found a way of doing this at the point the Excel document is created using EPPlus.

I have tried embedding a VBA sub routine using Workbook_Open(), but many companies set policies to prevent running Macros on Office documents when they open because of the threat of viruses/malware.

IRM primarily controls WHO can access the content of the document, which is different to the Worksheet Protection capabilities in EPPlus that restrict WHAT someone can do.

share|improve this question
  • 4
    Possible duplicate of Setting Excel worksheet protection with EPPlus – Paul Karam Apr 17 at 8:26
  • 1
    IRM is very different to "worksheet protection". It determines WHO is permitted to access the contents of the document. Worksheet protection determines WHAT can be done with the document, though IRM also adds another layer to that. – JonO Apr 17 at 8:46

active oldest votes

Your Answer

StackExchange.ifUsing("editor", function () { StackExchange.using("externalEditor", function () { StackExchange.using("snippets", function () { StackExchange.snippets.init(); }); }); }, "code-snippets"); StackExchange.ready(function() { var channelOptions = { tags: "".split(" "), id: "1" }; initTagRenderer("".split(" "), "".split(" "), channelOptions); StackExchange.using("externalEditor", function() { // Have to fire editor after snippets, if snippets enabled if (StackExchange.settings.snippets.snippetsEnabled) { StackExchange.using("snippets", function() { createEditor(); }); } else { createEditor(); } }); function createEditor() { StackExchange.prepareEditor({ heartbeatType: 'answer', convertImagesToLinks: true, noModals: false, showLowRepImageUploadWarning: true, reputationToPostImages: 10, bindNavPrevention: true, postfix: "", onDemand: true, discardSelector: ".discard-answer" ,immediatelyShowMarkdownHelp:true }); } });
 
StackExchange.ready( function () { StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f49872932%2fcreate-excel-document-with-epplus-and-assign-user-with-information-rights-manage%23new-answer', 'question_page'); } );

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

Browse other questions tagged c# .net epplus or ask your own question.

StackExchange.ready(function(){$.get('/posts/49872932/ivc/c4f0');});
StackExchange.ready(function () { StackExchange.responsiveness.addSwitcher(); }) (function(i, s, o, g, r, a, m) { i['GoogleAnalyticsObject'] = r; i[r] = i[r] || function() { (i[r].q = i[r].q || []).push(arguments) }, i[r].l = 1 * new Date(); a = s.createElement(o), m = s.getElementsByTagName(o)[0]; a.async = 1; a.src = g; m.parentNode.insertBefore(a, m); })(window, document, 'script', 'https://www.google-analytics.com/analytics.js', 'ga'); StackExchange.ready(function () { StackExchange.ga.init({ sendTitles: true, tracker: window.ga, trackingCodes: [ 'UA-108242619-1' ] }); StackExchange.ga.setDimension('dimension2', '|c#|.net|epplus|'); StackExchange.ga.setDimension('dimension3', 'Questions/Show'); StackExchange.ga.trackPageView(); }); /**/ var _qevents = _qevents || [], _comscore = _comscore || []; (function() { var ssl = 'https:' == document.location.protocol, s = document.getElementsByTagName('script')[0], qc = document.createElement('script'); qc.async = true; qc.src = (ssl ? 'https://secure' : 'http://edge') + '.quantserve.com/quant.js'; s.parentNode.insertBefore(qc, s); _qevents.push({ qacct: "p-c1rF4kxgLUzNc" }); /**/ var sc = document.createElement('script'); sc.async = true; sc.src = (ssl ? 'https://sb' : 'http://b') + '.scorecardresearch.com/beacon.js'; s.parentNode.insertBefore(sc, s); _comscore.push({ c1: "2", c2: "17440561" }); })();
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.319875 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO