Class ExcelSheetProtection

Sheet protection ExcelEncryption ExcelProtection

Inheritance

System.Object

XmlHelper

ExcelSheetProtection

Inherited Members

XmlHelper.AddSchemaNodeOrder(String[], String[])

XmlHelper.AddSchemaNodeOrder(String[], String[], Int32[])

XmlHelper.GetBoolFromString(String)

XmlHelper.CreatespPrNode(String, Boolean)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.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
System.Boolean

AllowDeleteColumns

Allow users to delete columns

Declaration

public bool AllowDeleteColumns { get; set; }

Property Value

Type	Description
System.Boolean

AllowDeleteRows

Allow users to delete rows

Declaration

public bool AllowDeleteRows { get; set; }

Property Value

Type	Description
System.Boolean

AllowEditObject

Allow users to edit objects

Declaration

public bool AllowEditObject { get; set; }

Property Value

Type	Description
System.Boolean

AllowEditScenarios

Allow users to edit senarios

Declaration

public bool AllowEditScenarios { get; set; }

Property Value

Type	Description
System.Boolean

AllowFormatCells

Allow users to format cells

Declaration

public bool AllowFormatCells { get; set; }

Property Value

Type	Description
System.Boolean

AllowFormatColumns

Allow users to Format columns

Declaration

public bool AllowFormatColumns { get; set; }

Property Value

Type	Description
System.Boolean

AllowFormatRows

Allow users to Format rows

Declaration

public bool AllowFormatRows { get; set; }

Property Value

Type	Description
System.Boolean

AllowInsertColumns

Allow users to insert columns

Declaration

public bool AllowInsertColumns { get; set; }

Property Value

Type	Description
System.Boolean

AllowInsertHyperlinks

Allow users to insert hyperlinks

Declaration

public bool AllowInsertHyperlinks { get; set; }

Property Value

Type	Description
System.Boolean

AllowInsertRows

Allow users to Format rows

Declaration

public bool AllowInsertRows { get; set; }

Property Value

Type	Description
System.Boolean

AllowPivotTables

Allow users to use pivottables

Declaration

public bool AllowPivotTables { get; set; }

Property Value

Type	Description
System.Boolean

AllowSelectLockedCells

Allow users to select locked cells

Declaration

public bool AllowSelectLockedCells { get; set; }

Property Value

Type	Description
System.Boolean

AllowSelectUnlockedCells

Allow users to select unlocked cells

Declaration

public bool AllowSelectUnlockedCells { get; set; }

Property Value

Type	Description
System.Boolean

AllowSort

Allow users to sort a range

Declaration

public bool AllowSort { get; set; }

Property Value

Type	Description
System.Boolean

IsProtected

If the worksheet is protected.

Declaration

public bool IsProtected { get; set; }

Property Value

Type	Description
System.Boolean

Methods

SetPassword(String)

Sets a password for the sheet.

Declaration

public void SetPassword(string Password)

Parameters

Type	Name	Description
System.String	Password