Password protected Excel file

Jul 8, 2010 at 12:20 PM
All, How we can make password protected Excel file using EPPlus. If you have any idea please share here. Thanks, -------------- Nagen
Coordinator
Jul 8, 2010 at 1:20 PM

You can't create encrypted workbooks, if that is what you want to do.

The component uses the System.IO.Packaging API and I don't think it supports encrypted xlsx files.

You can protect a worksheet using a password (Worksheet.Protection.SetPassword method), but that only locks cells, hide formulas etc, for locked cells.

Jan