Class ExcelSheetProtection¶

Namespace: OfficeOpenXml
Assembly: EPPlus.dll

Sheet protection ExcelEncryption ExcelProtection

public sealed class ExcelSheetProtection : XmlHelper

Inheritance¶

object ← XmlHelper ← ExcelSheetProtection

Inherited Members¶

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

Properties¶

AllowAutoFilter¶

Allow users to use autofilters

public bool AllowAutoFilter { get; set; }

Property Value¶

bool

AllowDeleteColumns¶

Allow users to delete columns

public bool AllowDeleteColumns { get; set; }

Property Value¶

bool

AllowDeleteRows¶

Allow users to delete rows

public bool AllowDeleteRows { get; set; }

Property Value¶

bool

AllowEditObject¶

Allow users to edit objects

public bool AllowEditObject { get; set; }

Property Value¶

bool

AllowEditScenarios¶

Allow users to edit senarios

public bool AllowEditScenarios { get; set; }

Property Value¶

bool

AllowFormatCells¶

Allow users to format cells

public bool AllowFormatCells { get; set; }

Property Value¶

bool

AllowFormatColumns¶

Allow users to Format columns

public bool AllowFormatColumns { get; set; }

Property Value¶

bool

AllowFormatRows¶

Allow users to Format rows

public bool AllowFormatRows { get; set; }

Property Value¶

bool

AllowInsertColumns¶

Allow users to insert columns

public bool AllowInsertColumns { get; set; }

Property Value¶

bool

AllowInsertHyperlinks¶

Allow users to insert hyperlinks

public bool AllowInsertHyperlinks { get; set; }

Property Value¶

bool

AllowInsertRows¶

Allow users to Format rows

public bool AllowInsertRows { get; set; }

Property Value¶

bool

AllowPivotTables¶

Allow users to use pivottables

public bool AllowPivotTables { get; set; }

Property Value¶

bool

AllowSelectLockedCells¶

Allow users to select locked cells

public bool AllowSelectLockedCells { get; set; }

Property Value¶

bool

AllowSelectUnlockedCells¶

Allow users to select unlocked cells

public bool AllowSelectUnlockedCells { get; set; }

Property Value¶

bool

AllowSort¶

Allow users to sort a range

public bool AllowSort { get; set; }

Property Value¶

bool

IsProtected¶

If the worksheet is protected.

public bool IsProtected { get; set; }

Property Value¶

bool

Methods¶

SetPassword(string)¶

Sets a password for the sheet.

public void SetPassword(string Password)

Parameters¶

Password string