Class ExcelSheetProtection

Namespace

OfficeOpenXml

Assembly

EPPlus.dll

Sheet protection ExcelEncryption ExcelProtection

public sealed class ExcelSheetProtection : XmlHelper

Inheritance

object

XmlHelper

ExcelSheetProtection

Inherited Members

object.GetType()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

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