Skip to content

Class ExcelProtection

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Sets protection on the workbook level ExcelEncryption ExcelSheetProtection

public class ExcelProtection : XmlHelper

Inheritance

object ← XmlHelper ← ExcelProtection

Inherited Members

object.Equals(object?, object?)
object.Equals(object?)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object?, object?)
object.ToString()

Properties

LockRevision

Lock the workbook for revision

public bool LockRevision { get; set; }

Property Value

bool

LockStructure

Locks the structure,which prevents users from adding or deleting worksheets or from displaying hidden worksheets.

public bool LockStructure { get; set; }

Property Value

bool

LockWindows

Locks the position of the workbook window.

public bool LockWindows { get; set; }

Property Value

bool

WriteProtection

File sharing settings for the workbook.

public ExcelWriteProtection WriteProtection { get; }

Property Value

ExcelWriteProtection

Methods

SetPassword(string)

Sets a password for the workbook. This does not encrypt the workbook.

public void SetPassword(string Password)

Parameters

Password string

The password.