Class ExcelSheetProtection

Sheet protection ExcelEncryption ExcelProtection

Inheritance

object

XmlHelper

ExcelSheetProtection

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: OfficeOpenXml

Assembly: EPPlus.dll

Syntax

public sealed class ExcelSheetProtection : XmlHelper

Properties

AllowAutoFilter

Allow users to use autofilters

Declaration

public bool AllowAutoFilter { get; set; }

Property Value

Type	Description
bool

AllowDeleteColumns

Allow users to delete columns

Declaration

public bool AllowDeleteColumns { get; set; }

Property Value

Type	Description
bool

AllowDeleteRows

Allow users to delete rows

Declaration

public bool AllowDeleteRows { get; set; }

Property Value

Type	Description
bool

AllowEditObject

Allow users to edit objects

Declaration

public bool AllowEditObject { get; set; }

Property Value

Type	Description
bool

AllowEditScenarios

Allow users to edit senarios

Declaration

public bool AllowEditScenarios { get; set; }

Property Value

Type	Description
bool

AllowFormatCells

Allow users to format cells

Declaration

public bool AllowFormatCells { get; set; }

Property Value

Type	Description
bool

AllowFormatColumns

Allow users to Format columns

Declaration

public bool AllowFormatColumns { get; set; }

Property Value

Type	Description
bool

AllowFormatRows

Allow users to Format rows

Declaration

public bool AllowFormatRows { get; set; }

Property Value

Type	Description
bool

AllowInsertColumns

Allow users to insert columns

Declaration

public bool AllowInsertColumns { get; set; }

Property Value

Type	Description
bool

AllowInsertHyperlinks

Allow users to insert hyperlinks

Declaration

public bool AllowInsertHyperlinks { get; set; }

Property Value

Type	Description
bool

AllowInsertRows

Allow users to Format rows

Declaration

public bool AllowInsertRows { get; set; }

Property Value

Type	Description
bool

AllowPivotTables

Allow users to use pivottables

Declaration

public bool AllowPivotTables { get; set; }

Property Value

Type	Description
bool

AllowSelectLockedCells

Allow users to select locked cells

Declaration

public bool AllowSelectLockedCells { get; set; }

Property Value

Type	Description
bool

AllowSelectUnlockedCells

Allow users to select unlocked cells

Declaration

public bool AllowSelectUnlockedCells { get; set; }

Property Value

Type	Description
bool

AllowSort

Allow users to sort a range

Declaration

public bool AllowSort { get; set; }

Property Value

Type	Description
bool

IsProtected

If the worksheet is protected.

Declaration

public bool IsProtected { get; set; }

Property Value

Type	Description
bool

Methods

SetPassword(string)

Sets a password for the sheet.

Declaration

public void SetPassword(string Password)

Parameters

Type	Name	Description
string	Password