Click here to Skip to main content
15,169,185 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
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
Updated 30-Dec-13 4:51am
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

Please, read my comment to the question first.

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

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

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900