Page History

Description

Excerpt
Sets or returns the password used to encrypt the spreadsheet. Standard "Office 97/2000 Compatible" encryption is used to encrypt the spreadsheet. This is the default encryption used by Excel 97 and later versions.

Signature

	C#
	C#

 public System.String EncryptPassword{ get; set; }

Signature

	vb.net
	vb.net

Public Property EncryptPassword() As String

Remarks
To further protect your spreadsheet, you can protect the workbook structure using the Workbook.Protect() method or write-protect individual worksheets using the Worksheet.Protect() method.

Example

Code Block

	csharp
	csharp
title	C#


          //--- Get the EncryptPassword value for the workbook
          string pwd = wb.EncryptPassword;

          //--- Set the EncryptPassword value for the workbook
          wb.EncryptPassword = "MyPassword";

Code Block

	vb.net
	vb.net
title	vb.net


          '--- Get the EncryptPassword value for the workbook
          Dim pwd As String = wb.EncryptPassword

          '--- Set the EncryptPassword value for the workbook
          wb.EncryptPassword = "MyPassword"

Space Shortcuts

Page tree

Versions Compared

Old Version 6

New Version Current

Key