Xceed Logo
Shop
Xceed Workbooks for .NET v3.0 Documentation
Xceed.Workbooks.NET Assembly / Xceed.Workbooks.NET Namespace / Protection Class
Example


In This Topic
    Protection Class
    In This Topic
    Represents the possible properties of the Cell protection process.
    Syntax
    'Declaration
 

    Public Class Protection 
   Inherits Xceed.Workbooks.NET.StyleBase(Of IReadonlyProtection)
   Implements IReadonlyProtection 
    'Usage
 

    Dim instance As Protection
    public class Protection : Xceed.Workbooks.NET.StyleBase<IReadonlyProtection>, IReadonlyProtection
    Example
    using( var workbook = Workbook.Create( "AddProtection.xlsx" ) ) 
  { 
    // Gets the first Worksheet; a Workbook always contains at least 1 Worksheet. 
    var worksheet = workbook.Worksheets[ 0 ]; 

    // Sets the Worksheet protection : only formatting Cells and inserting Rows/Columns will be allowed. 
    var protection = new WorksheetProtection() { AllowFormatCells = true, AllowInsertRows = true, AllowInsertColumns = true }; 

    // Protects the 1st Worksheet with a password. 
    worksheet.Protect( protection, "xceed" ); 

    // Saves Workbook to disk; 
    workbook.Save(); 
  }
    Inheritance Hierarchy

    System.Object
       Xceed.Workbooks.NET.StyleBase<T>
          Xceed.Workbooks.NET.Protection

    Public Constructors
     NameDescription
    Public ConstructorProtection Constructor  
    Top
    Public Properties
     NameDescription
    Public PropertyHiddenFormulaGets or sets if the content of a Cell or the formula it contains are displayed in the formula bar or not.  
    Public PropertyLockedGets or sets if the Cell is locked or not.  
    Top
    Public Methods
     NameDescription
    Public MethodEquals  
    Public MethodGetHashCode  
    Top
    Protected Methods
     NameDescription
    Protected MethodOnPropertyChanged (Inherited from Xceed.Workbooks.NET.StyleBase<IReadonlyProtection>)
    Top
    Supported Frameworks

    .NET: net5.0, net5.0-windows, net6.0, net6.0-macos, net6.0-windows, net7.0, net7.0-macos, net7.0-windows, net8.0, net8.0-browser, net8.0-macos, net8.0-windows, net9.0, net9.0-browser, net9.0-macos, net9.0-windows, net10.0, net10.0-browser, net10.0-macos, net10.0-windows.

    .NET Framework: net40, net403, net45, net451, net452, net46, net461, net462, net463, net47, net471, net472, net48, net481.

    See Also

    Reference

    Protection Members
    Xceed.Workbooks.NET Namespace

    Send Feedback