Create password protected excel file using Closedxml library

Question

I am new in c# asp.net and I tried to create XLS file using third party library "Closedxml". Now I also want to protect the XLS file with password how I can achieve this.

Your help would be appreciable. Thanks in advance Ashish

You could just google it and it would give you numerous solutions. Here is one: msdn.microsoft.com/en-us/library/7czw9wzs.aspx (Keep in mind that you will need to add the ref to the excel lib in your project) And here is a duplicate: stackoverflow.com/questions/915999/… — Noël Widmer
– Noël Widmer, Commented May 20, 2015 at 6:10
It looks like you can't password protect it (or remove password protection) with ClosedXML, but @NoelWidmer 's links should be sufficient from protecting it after you've created it with ClosedXML. — Mir
– Mir, Commented Jun 17, 2015 at 20:28

NightShadeQueen · Accepted Answer · 2015-09-18 19:19:28Z

7

Had the same issue - needed to protext an excel file without using the interop libraries.

With ClosedXML you can password protect at the worksheet level: 
var ws = wb.Worksheets.Add("someworksheet");
ws.Protect("123");  // 123 will be the password

And it looks like you can lock the structure of the workbook (prevent worksheet add/delete/rename) without the option of setting a password, although have not tested this bit extensively:

var wb = new XLWorkbook();
wb.Protect(bool LockStrucure, bool LockWindows);

references: sheet protection example

edited Sep 18, 2015 at 19:19

NightShadeQueen

3,3633 gold badges27 silver badges37 bronze badges

answered Sep 18, 2015 at 19:11

JesseZ

911 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Stephanie Over a year ago

this is possible in PowerShell?

Noobie3001 Over a year ago

This doesn't work for me. The Excel file opens without requesting a password.

twostepdevelopers Over a year ago

THIS IS NOT WORKING FOR ME

Cerveser · Accepted Answer · 2018-09-20 18:19:22Z

3

To protect the file with a password is not possible in ClosedXML, see github

answered Sep 20, 2018 at 18:19

Cerveser

8701 gold badge11 silver badges26 bronze badges

5 Comments

ModusPwnens Over a year ago

Downvote because it is possible, see @JesseZ answer.

Cerveser Over a year ago

check my link, it's not possible, JesseZ answer doesn't work.

ModusPwnens Over a year ago

maybe we're talking about different things because JesseZ's answer 100% worked for me. That's for password protecting a worksheet from editing, not the entire file from opening. Is that what you're talking about?

Cerveser Over a year ago

Yes I'm talking about password protecting the entire file from opening.

Ryan Sorensen Over a year ago

+1 because, @Cerveser, you're absolutely correct. You can protect individual sheets from being edited, but you cannot password protect the document from being opened with ClosedXML. The original question did not specify which type of protection they wanted.

Collectives™ on Stack Overflow

Create password protected excel file using Closedxml library

2 Answers 2

3 Comments

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related