Spire.XLS API

XlsWorksheetBase Protect Method (String)

Protects worksheet with password.protect the sheet except select lock/unlock cells.

Examples

The following code illustrates how to protect the sheet except select lock/unlock cells:

<para>//Create worksheet</para><para>Workbook workbook = new Workbook();</para><para>Worksheet worksheet = workbook.Worksheets[0];</para><para>//Protects the first worksheet's content with password</para><para>worksheet.Protect("123456");</para><para>//Save to file</para><para>workbook.SaveToFile("Protect.xlsx");</para>

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

public void Protect(
	string password
)

Public Sub Protect ( 
	password As String
)

public:
virtual void Protect(
	String^ password
) sealed

abstract Protect : 
password : string -> unit 
override Protect : 
password : string -> unit

Parameters

password: Type: System String
Protection password.

Implements

ITabSheet Protect(String)

Remarks

Password should be less than 15 symbols.

Reference

XlsWorksheetBase Class

Protect Overload

Spire.Xls.Core.Spreadsheet Namespace

XlsWorksheetBase AddLanguageSpecificTextSet("LST64301456_0?cpp=::|nu=."); Protect Method (String)

Parameters

Implements

Reference

XlsWorksheetBase Protect Method (String)