How to add protection to a Programatically Exported Excel sheet?

Question

0.00/5 (No votes)

See more:

Hi I am having a collection which i want to export to Excel sheet. Along with export functionality i also want to add protection to the excel sheet. I doesn't want the user to edit that file, not by using 'Password'.
I am using SpreadsheetDocument from OpenXmlPackage in my WPF application, .NET framework as 3.5.
How can i achieve this through the code?
thank you

Posted 30-Dec-13 1:51am

Member 9990662

Updated 30-Dec-13 3:51am

Nelek

v3

Add a Solution

Comments

Maciej Los 30-Dec-13 9:43am

Is there any reason to export data to Excel, if you don't want to let users edit it?
Rather export data to pdf using iTextSharp library.

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-12-30T03:46:00

Solution 1

Please, read my comment to the question first.

Have a look here: Overview of Protected Office Open XML Documents[^]

Posted 30-Dec-13 3:46am

Maciej Los

How to add protection to a Programatically Exported Excel sheet?

1 solution

Solution 1

Add your solution here

Preview 0

How to add protection to a Programatically Exported Excel sheet?

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us