How to create a password protected Excel file?

Question

I have a list type of object and i need to create a excel file which should required password to open that excel file in ASP.NET C#.

I have tried ClosedXML package but that is not working well. And also I have tried much more example but I didn't found any good example.

Please, If any one have done these type of example then please let me know.

Much Appreciation !

If it's an .xslx file - which is just a zip of xml files - you could try to unzip and then rezip it with a password. You should check if Excel supports this. — ckuri
– ckuri, Commented Aug 21, 2018 at 7:21

Hossein · Accepted Answer · 2018-08-21 06:18:59Z

2

If you want an Excel password all you need is something like this:

using Microsoft.Office.Interop.Excel

//create your spreadsheet here...

WorkbookObject.Password = password;
WorkbookObject.SaveAs("spreadsheet.xls")

This requires Excel to be installed.

answered Aug 21, 2018 at 6:18

Hossein

3,1233 gold badges18 silver badges35 bronze badges

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

10 Comments

Jayant Sharma Over a year ago

Thanks for reply Mr. Hossein, I have tried that also but this is not working for me.

Hossein Over a year ago

@JayantSharma See this. c-sharpcorner.com/blogs/protecting-excel-files-programmatically

Jayant Sharma Over a year ago

An exception of type 'System.Runtime.InteropServices.COMException' occurred in App_Web_x0oyenfd.dll but was not handled in user code this is the error when I am using Microsoft.Office.Interop.Excel

Jayant Sharma Over a year ago

When I am creating a instance as Workbook workbook = new Workbook(); then system is through error

Hossein Over a year ago

@JayantSharma This issue isn't caused by your code. Maybe your pc had both Office version on it, and after uninstalling once and rebooting, the issue was fixed

|

Collectives™ on Stack Overflow

How to create a password protected Excel file?

1 Answer 1

10 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

10 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related